Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 14106 Views
- I also Faced
- E-Mail Answers
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 to resolve -805 . how to see dbrm and package not found
Give some example of statistics collected during RUNSTATS?
What is lock escalation?
what's the error code for Unique Index Violation?
How do I start db2 in windows?
What is a cursor?
What is CHECK PENDING ?
can any one expalin check point with an example?
what is check point and restart Logic ? why do we go for that ??
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What are the four lockable units for DB2?
COBOL 
