Answer Posted / 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 |
Post New Answer View All Answers
How to restart a DB2 program?
What is host variable?
How do I copy a table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is ibm db2 client?
What do you mean by storage group (stogroup)?
How does coalesce work?
What is role in db2?
Explain package in db2 and its advantages?
Describe major components of db2?
How can we read records for specific member in CL? AND rpg?
What is blu acceleration in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What are db2 objects?
What is the difference between plan and package in db2?