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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest

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

how can we find nth max salary from A table

5 Answers   IBM,

What is db2 connect?

0 Answers  

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

Explain various types of locks in db2?

0 Answers  

How would you print the output of an SQL statement from SPUFI?

2 Answers  

where will u check for sqlcode ?

2 Answers   TCS,

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

What is a synonym? How is it used?

2 Answers  

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories