what is REORG? what is the use?

Answer Posted / s

It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between cs and rr isolation levels? Where do you specify them?

580


What is cobol db2?

568


What is temporal table in db2?

601


Is the primary key a clustered index?

607


What is dbrm? When it will be created?

594






How to run db2 command in windows?

643


What is dpf in db2?

664


B37 abend during spufi?

979


What is phantom read in db2?

636


How do I change the column size in db2?

589


What is collection in db2 bind?

572


What is role in db2?

612


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1574


What is a plan and package in db2?

617


How do you pull up a query which was previously saved in qmf?

670