Interested to Buy Any Domain ? << Click Here >> for more details...
what is REORG? what is the use?
- 4 Answers
- 15709 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aasif
A common maintenance task performed by database
administrators is the reorganization of data in tables and
indexes, called "reorg." Table reorganization is used to
defragment a table, reclaim free space, and eliminate
overflow rows in order to improve data access performance.
Optionally it can be used to reorder data in the order of a
particular index, to optimize queries that use that index.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / s
It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / deepak dada
used for reorganising the datas in the tables after the
load utility
| Is This Answer Correct ? | 1 Yes | 0 No |
What is db2 bind?
What types of tables are there in the db2 database?
What is the physical storage length of timestamp data type?
Can we install 2 different versions of Db2 on same mainframe?
How do I delete a table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Is it possible to precompile if db2 goes down?
When do you specify the isolation level?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Give a brief description of db2 isolation levels?
What is explain in db2?
COBOL 
