Interested to Buy Any Domain ? << Click Here >> for more details...
what is REORG? what is the use?
- 4 Answers
- 15720 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 |
The only place of VSAM KSDS in DB2 is?
Is the primary key a clustered index?
Return code 100 means?
What is temporal table in db2?
What is dbrm?
What does db2 stand for?
How to resolve -502 sql code in DB2?
Normalization in DB2 – first normal form, second normal form
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is check constraint. Explain with example.
What is deadlock in db2?
COBOL 
