Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Overview

The BMC 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 product for reorganizing Db2 databases.

Related topic

Getting-started

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 SNAPSHOT UPGRADE FEATURE (SUF) (also known as  EXTENDED BUFFER MANAGER (XBM) 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 non-destructive manner, which allows you to easily make the objects available without having to recover

 

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