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
What is the use of db2 optimizer?
If I have a view which is a join of two or more tables, can this view be updateable?
What are union and union all?
Explain about rct.
What is ibm db2 connect?
What is alias in db2?
Is the primary key a clustered index?
What is explain in db2?
What is the difference between bind and rebind in db2?
When reorg is used?
What is drop table?
What is the information associated with sysibm.syslinks table?
How to retrieve rows from a db2 table in embedded sql?
Mention the different locking levels that are available in db2.
Is db2 a mainframe database?
