Interested to Buy Any Domain ? << Click Here >> for more details...
How would one remove old reorg information from the DB2
catalog?
- 2 Answers
- 6462 Views
- I also Faced
- E-Mail Answers
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
What is bufferpool in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is ibm db2 used for?
Why do we need reorg in db2?
Define check constraint.
Which component is responsible for db2 startup and shutdown?
List down the data types in the db2 database.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a page in db2?
How do I copy a table in db2?
What does reorg do in db2?
How do I delete a table in database?
What is universal database?
What is rebind in db2?
How to compare data between two tables in db2?
