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?

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 are the disadvantages of PAGE level lock?

3 Answers  


How is the value function used?

0 Answers  


What is buffer pool?

0 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,


What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


Is db2 a database?

0 Answers  


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


Define sqlca.

0 Answers  


what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,


Categories