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 iseries database?
Mention the various locks that are available in db2.
Explain the benefits you can get from mainframe connect?
what is utility for parm lib
How is the value function used?
Why db2 is called db2?
What is bind and rebind in db2?
Which isolation level provides highest data integrity?
Where can you declare a cursor in a cobol-db2 program?
How does a cursor work?
Explain correlated sub-queries.
How do I copy a table in db2?
Mention the location where the output received from explain statement is stored.
What is nvl in db2?
Explain about cursor stability?