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 does the REORG Utility do?

Answer Posted / harsha

Reorg is done when

1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is iseries database?

1050


Mention the various locks that are available in db2.

1041


Explain the benefits you can get from mainframe connect?

972


what is utility for parm lib

2379


How is the value function used?

1157


Why db2 is called db2?

1044


What is bind and rebind in db2?

1139


Which isolation level provides highest data integrity?

1119


Where can you declare a cursor in a cobol-db2 program?

1077


How does a cursor work?

993


Explain correlated sub-queries.

1034


How do I copy a table in db2?

1000


Mention the location where the output received from explain statement is stored.

1127


What is nvl in db2?

1096


Explain about cursor stability?

1052