What is REORG? When is it used?

Answer Posted / vamsikrishnamraju

Calculates statistics on the database to determine if
tables or indexes, or both, need to be reorganized or
cleaned up.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we bind in db2?

634


Why db2 is called db2?

596


What is reorg?

619


What is isolation level in db2?

578


i want to maintain uniqueness on pdf without make lf??????????

1637






Which component is responsible for db2 startup and shutdown?

630


Define buffer pool.

630


What is page size in db2?

564


What is buffer pool and list some of them?

630


What is bind package and plan in db2?

597


How would you find out the total number of rows in a db2 table?

579


What is the use of dclgen in db2?

591


Can we update view in db2?

562


How to create backup table in db2?

646


What is a page in db2?

613