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 is bind in db2?
Explain db2.
What happens to the PLAN if index used by it is dropped?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is REORG? When is it used?
what is the use of cursors?
What is the syntax for FETCH in DB2 ?
Who uses db2?
How is a typical DB2 batch program executed ?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
what is difference between random and sequence file access
What is a Resource Control Table(RCT)? Describe its characteristics.