How would one remove old reorg information from the DB2
catalog?
Answer Posted / 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 View All Answers
How do I change the column size in db2?
What is drop table?
What db2 400?
What is null indicator in db2?
What is clone table?
What is the information associated with sysibm.syslinks table?
What is bind and rebind in db2?
What is isolation level in db2?
What is db2?
What happens in bind step in a db2 program?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to find the maximum value in a column in the db2 database?
What is the use of predicate?
What is sqlca’s maximum length?
Are view updateable?