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

What is reorg in DB2

Answer Posted / harish

Reorg is needed whenever indexed columns are updated frequently.

When indexed columns are updated frequently, then the index
for the table has to be created again.

So REORG utility is run which will drop the index and create
the index again for the table.

Is This Answer Correct ?    36 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

2389


what are bind concepts in db2 cobol?

1096


What is cloudant database?

1101


What is a bind in db2?

1043


How do I add a column to a table in db2?

1104


What is a db2 cursor?

1056


What is the use of dclgen in db2?

1085


What are concurrency issues?

1098


Differentiate between cs and rr isolation levels? Where do you specify them?

1071


What is reorg and runstats in db2?

1219


What is db2 connect?

1073


What are union and union all?

983


What is database alias db2?

1129


How connect db2 database to datastage?

1244


What parameters are used to control the free space in DB2?

1057