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 check constraint. Explain with example.
How do you find the maximum value in a column in db2?
What does reorg do in db2?
How connect db2 database to datastage?
Explain package in db2 and its advantages?
What is dclgen (declaration generator)?
How is the value function used?
List out the data types available.
What is the reason behind not using select * in embedded sql programs?
How do I copy a table in db2?
How many databases are there?
What are the 2 sqlcodes that are returned?
Where do you specify them?
B37 abend during spufi?
What type of database is db2?