Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Overview

The BMC Software utility products for Db2 address the needs of database administrators (DBAs) and system administrators by providing high-performance database administration and utility products. The REORG PLUS for DB2 product is a BMC Software product for reorganizing Db2 databases.

Disadvantages of disorganized data

Disorganized data decreases database efficiency in the following ways:

  • In sequential processing, more I/Os are required to retrieve disorganized data than are needed to retrieve data items that are physically adjacent to one another.
  • The retrieval inefficiency caused by the disorganization slows Db2 application response time and decreases user productivity.
  • A disorganized database wastes DASD space.

For Db2 to operate at maximum cost-effectiveness, the physical structures of the database must be organized as efficiently as possible. Without good organization, system performance declines while costs, in both time and money, rise.

The REORG PLUS solution

BMC developed a product line to respond to the needs of DBAs, system administrators, and other Db2 users who require high-performance database administration and utility products. The REORG PLUS product efficiently reorganizes Db2 data.

REORG PLUS replaces most of the functions of the IBM Db2 REORG utility and provides additional functions that are not available in other reorganization utilities.

REORG PLUS benefits

Advanced techniques and additional functions allow REORG PLUS to reorganize data faster than the IBM Db2 REORG utility does.

In addition, REORG PLUS offers the following significant benefits over other reorganization utilities:

  • Reduces costs of reorganizing Db2 data because fewer CPU cycles and EXCPs are used
  • Increases availability of Db2 data because the time needed to reorganize the data is reduced
  • Improves Db2 performance by allowing more frequent reorganizations because of reduced reorganization costs and elapsed times

If you have the BMC Software EXTENDED BUFFER MANAGER (XBM) product or its SNAPSHOT UPGRADE FEATURE (SUF) installed, you can use REORG PLUS to perform online reorganizations. Online reorganizations allow full application access to your Db2 objects during most of the reorganization process, thus minimizing the amount of time that data is unavailable to you. You can request an online reorganization by specifying SHRLEVEL CHANGE on the REORG command.

Performing an online reorganization provides the following benefits:

  • Allows full read/write (RW) access to Db2 data during the reorganization
  • Delivers improved data availability to meet growing 24 x 7 requirements
  • Operates in a nondestructive manner, which allows you to easily make the objects available without having to recover

Related topic

Getting-started

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*