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 |
Q3. How will you fetch duplicate values from a DB2 table?
how to resolve -805. give clear explination for that
What is precompiler in db2?
Explain in brief how does db2 determine what lock-size to use?
What is db2 bind?
What is a Cartesian product?
What os does db2 run on?
What is Reorg Recovery? when will you run it?
What are leaf pages?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
When DB2 connection fails, will online program work or give errors.
What will the DB2 optimizer do?