How would one remove old reorg information from the DB2
catalog?

Answers were Sorted based on User's Feedback



How would one remove old reorg information from the DB2 catalog?..

Answer / s

MODIFY RECOVERY utility

Is This Answer Correct ?    1 Yes 0 No

How would one remove old reorg information from the DB2 catalog?..

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

Post New Answer

More DB2 Interview Questions

What types of tables are there in the db2 database?

0 Answers  


Can you use max on a char column?

0 Answers  


How to create db2 table in mainframe?

0 Answers  


What is cursor stability?

1 Answers  


What is db2 isolation?

2 Answers  






Define predicate?

0 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What is a db2 table?

0 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is the difference between group by and order by?

2 Answers   IBM, TCS,


What are the contents of dclgen?

0 Answers  


How does cobol compile db2 program?

0 Answers  


Categories