Interview Questions   Tutorials   Discussions   Programs   

DB2 - What does the REORG Utility do?




325
views
asked mar August 3, 2014 05:33 AM  

What does the REORG Utility do?


           

1 Answers



 
answered By Mswami   0  
REORG reorganizes data on physical storage to recluster rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space.  It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

REORG INDEX

The REORG INDEX online utility reorganizes an index space to improve access performance and reclaim fragmented space. You can specify the degree of access to your data during reorganization, and you can collect inline statistics by using the STATISTICS keyword.

REORG TABLESPACE
The REORG TABLESPACE online utility reorganizes a table space to improve access performance and to reclaim fragmented space. In addition, the utility can reorganize a single partition or range of partitions of a partitioned table space.

You can specify the degree of access to your data during reorganization. If you specify REORG TABLESPACE UNLOAD EXTERNAL, the data is unloaded in a format that is acceptable to the LOAD utility of any DB2 subsystem. You can also delete rows during the REORG job by specifying the DISCARD option.

Please refer IBM Site for more details.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -325
Number of Answers -1
Last updated
3 years and 4 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert