Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is REORG? what is the use?

asked mar September 4, 2014 11:35 AM  

What is REORG? what is the use?


1 Answers

answered By Mswami   0  

The REORG utility can be used to reorganize DB2 table spaces and indexes, thereby improving the efficiency of access to those objects. Reorganization is required periodically to ensure that the data is situated in an optimal fashion for subsequent access. Reorganization reclusters data, resets free space to the amount specified in the CREATE DDL, and deletes and redefines the underlying VSAM data sets for STOGROUP -defined objects.

There are three types of reorganizations supported by the DB2 REORG utility:

  • When REORG is run on an index, DB2 reorganizes the index space to improve access performance and reclaim fragmented space.
  • When REORG is run on a regular (non-LOB) table space, DB2 reorganizes the data into clustering sequence by the clustering index, reclaims fragmented space, and optimizes the organization of the data in the table space.

  • When REORG is run on a LOB table space, DB2 removes embedded free space and tries to make LOB pages contiguous. The primary benefit of reorganizing a LOB table space is to enhance prefetch effectiveness.

   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 1 year and 1 month ago ago
Number of Views -359
Number of Answers -1
Last updated
2 years and 1 month 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!