Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is release/acquire in bind?

1164


What is the result of open cursor statement?

1129


What is the maximum No of rows per page?

1117


What is db2 and what is the use of db2 optimizer?

1114


Explain correlated sub-queries.

1097


What is universal database?

1121


What is concurrency?

1306


How do I change the column size in db2?

1210


How to retrieve rows from a db2 table in embedded sql?

1448


What is explain plan in db2?

1052


What is the role of the data page in the db2 database?

1085


Is ibm db2 free?

1073


Which components manage deadlocks in db2?

1127


How and when does the db2 enforces the unique key?

1143


How do I delete a column in db2?

1157