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
Differentiate between cs and rr isolation levels? Where do you specify them?
What is query_cache_limit?
What is the default page size of buffer pools?
Why do chiropractors use drop table?
How to retrieve rows from a db2 table in embedded sql?
What does runstats do in db2?
define clustering index.
What is the usage of open cursor command?
Define db2 and its databases?
How do I add a column to a table in db2?
What is the connection string to connect to the DB2 Database ?
What is a storage group (stogroup)?
What is dbrm? What it contains?
What do you mean by rollback?
How to run db2 command in windows?