What is Reorg Recovery? when will you run it?

Answer Posted / srinivas chennareddy

REORG utility will physically realign/reorganizes the
records in a table as per the clustered index and release
any free space.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define buffer pool.

628


What are the rules for db2 programming?

643


What is dbrm library?

578


Is it possible using max on a char column?

609


What is a db2 collection?

607






How can deadlocks be resolved?

543


How is deadlock resolved?

650


What is the syntax for seeing the columns and data types of a table in the db2 database?

578


How to restart a DB2 program?

1366


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6861


What is drop table?

584


What are the uses of db2 optimizer?

818


What is ibm db2 client?

523


Explain about cursor stability?

623


What is explain plan in db2?

592