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 Recovery? when will you run it?

Answer Posted / s.v.venkata sivaprasad

reorg is a db2 use to improve the performance and any unused
pages in table space is rearange it perticul order and
release free space
//job1 job....
//step1 exec pgm=IKJEFT01
//sysin dd *
reorg db123.tb123
//

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What action db2 takes when a program aborts in the middle of a transaction?

1156


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11686


What is the maximum length of sqlca?

1533


What is null in db2?

1031


When do you specify the isolation level?

1040


What is host variable in db2 cobol?

1084


Explain about rct in db2?

1114


How do you select a row using indexes in db2?

1141


What are the prerogatives?

1085


What is db2 instance?

1110


List out the data types available.

1158


What is the meaning concurrency in the db2 database?

1112


What type of database is db2?

973


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1202


Give a brief description of db2 isolation levels?

1076