How would one remove old reorg information from the DB2
catalog?
Answers were Sorted based on User's Feedback
Answer / 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 |
What are db2 objects?
What are the four lockable units for DB2?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is a storage group (stogroup)?
how to fetch multiple records without using cursor
What is null indicator in cobol db2?
Define buffer pool.
What is dbrm? When it will be created?
what is the responsibility of the construction superintendent
What is JOIN and different types of JOIN.
How to check table size in db2 sap?
How is a typical DB2 batch program executed ?