What does the REORG Utility do?
Answers were Sorted based on User's Feedback
Answer / guest
REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / harsha
Reorg is done when
1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode
| Is This Answer Correct ? | 6 Yes | 2 No |
How many sub queries can you combine together ?
What is difference between rollback and commit?
What is the result of open cursor statement?
Can we install 2 different versions of Db2 on same mainframe?
What is an instance in db2?
What is dbrm library?
where can we use index and subscript ? with example ?
How to insert more than one record using insert?
What DB2 Catalog column tell you when an index needs table reorganized ?
Can you use max on a char column?
How do I delete a column in db2?
What is reorg and runstats in db2?