What is REORG? When is it used?

Answer Posted / a

What vamshi is said is incorrect .i.e he told about
RUNSTATS utility.

Where in REORG is used to re organise the table after huge
manipulation say insert,delete of records etc.It provides
free space also.

Correct me if i wrong vamshi/anyone

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between spufi and qmf?

641


Why do chiropractors use drop table?

664


How do you stop a db2 database in linux?

570


What is the maximum size of varchar data type in db2?

647


List down the data types in the db2 database.

640






What are db2 objects?

641


Which command is used to remove all rows from a table?

553


can we view the access paths created by dbrm ? how ? thx

6262


What is rct?

755


What types of tables are there in the db2 database?

559


Define check constraint.

646


How do I delete a table in db2?

651


What is dbrm? What it contains? When it will be created?

595


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

633


Mention some fields that are a part of sqlca.

603