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
What is release/acquire in bind?
What is the result of open cursor statement?
What is the maximum No of rows per page?
What is db2 and what is the use of db2 optimizer?
Explain correlated sub-queries.
What is universal database?
What is concurrency?
How do I change the column size in db2?
How to retrieve rows from a db2 table in embedded sql?
What is explain plan in db2?
What is the role of the data page in the db2 database?
Is ibm db2 free?
Which components manage deadlocks in db2?
How and when does the db2 enforces the unique key?
How do I delete a column in db2?