How would one remove old reorg information from the DB2
catalog?
Answer Posted / mehdee
The online REORG INDEX or REORG Table Space utility
reorganizes an index space or Table Space to improve access
performance and reclaim fragmented space.
RUNSTATS utility will collect inline statistics and update
DB2 catalog.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give the name of some fields form sqlca.
What are bind parameters in db2?
How can you classify the locks in db2?
What is the default page size of buffer pools?
List some fields from sqlca?
What are the two types of logging in the db2 database? Explain them.
Define data page.
What is the function of logging in the db2 database?
How do I add a column in db2?
What is the use of reorg in db2?
What is load replace in db2?
What is a system catalog table in db2?
What is the use of db2?
What is clone table?
What language is db2 written in?