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 a page in db2?
How do I add a column to an existing table in db2?
How to fetch the last row from the table in SQL (db2)?
What is drop table?
What is db2 command?
What are foreign keys in db2?
How do I change the column size in db2?
Before you give the explain statement, what are the prerogatives?
What is an instance in db2?
What is the use of commit in db2?
How will you return the number of records in table?
What is the use of dclgen in db2?
Mention data types used in db2 ?
what are bind concepts in db2 cobol?
What is the purpose of using commit?