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 |
How to retrieve rows from a db2 table in embedded sql?
My SQL is not performing well. Describe how will you fine tune it?
How to know the primary key of a table without defining the primary key in the table?
What does a deadlock mean in DB2?
can i code union in cobol-db2 pgm ?
What is blu acceleration in db2?
what is the name of the default db2 catalog database?
What are the Isolation levels possible ?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
How do I create a view in db2?
What's the difference between DB2 active log and archive log? Thanks a lot...
Define db2.