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 are the various isolation levels possible?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 catalog database?
What are the 2 sqlcodes that are returned?
What do you mean by commit and rollback?
What is dbrm library?
How do I optimize a query in db2?
Where do you specify them?
Which isolation level provides maximum concurrency?
List down the data types in the db2 database.
Name the lockable units in DB2?
What is runstats db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a db2 tablespace?
What is view db2?
