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 types of tables are there in the db2 database?
Can you use max on a char column?
How to create db2 table in mainframe?
What is cursor stability?
What is db2 isolation?
Define predicate?
Q3. How will you fetch duplicate values from a DB2 table?
What is a db2 table?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the difference between group by and order by?
What are the contents of dclgen?
How does cobol compile db2 program?