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.

Integrating

REORG PLUS is also a component of the following BMC solutions. For more information, see the release notes for these solutions.

BMC AMI Database Performance for Db2 solution

The BMC AMI Database Performance for Db2  solution helps DBAs determine the maintenance tasks that are required on their Db2 objects and, optionally, automate execution of those tasks. The following REORG PLUS features are available only when you install the BMC AMI Database Performance for Db2 solution:

  • You can use the value BMC on the CONDEXEC installation or command option to instruct REORG PLUS to use the DASD MANAGER PLUS exceptions table to determine whether an object should be reorganized. Using the exceptions table gives REORG PLUS an expanded set of conditions to determine whether the reorganization is needed.
  • You can use the value BMCSTATS on the ANALYZE command option to enhance the performance of REORG PLUS. In the ANALYZE phase, REORG PLUS uses the statistics already gathered by BMCSTATS instead of gathering the statistics itself.

This solution includes the following products and primary technology components:

  • DASD MANAGER PLUS for DB2
  • REORG PLUS for DB2
  • SNAPSHOT UPGRADE FEATURE for DB2

BMC AMI Utilities for Db2 solution

The BMC AMI Utilities for Db2 solution delivers high availability of objects during data and database maintenance. The solution also significantly reduces runtime costs by minimizing CPU consumption.

This solution includes the following products and primary technology components:

  • CHECK PLUS for DB2
  • BMC Common Statistics
  • BMC AMI Copy for Db2 
  • LOADPLUS for DB2
  • BMC AMI Recover for Db2
  • REORG PLUS for DB2
  • SNAPSHOT UPGRADE FEATURE for DB2
  • UNLOAD PLUS for DB2

BMC Database Performance for DB2 solution

The BMC AMI Database Performance for Db2 solution helps DBAs determine the maintenance tasks that are required on their Db2 objects and, optionally, automate execution of those tasks. The following REORG PLUS features are available only when you install the Database Performance for DB2 solution:

  • You can use the value BMC on the CONDEXEC installation or command option to instruct REORG PLUS to use the DASD MANAGER PLUS exceptions table to determine whether an object should be reorganized. Using the exceptions table gives REORG PLUS an expanded set of conditions to determine whether the reorganization is needed.
  • You can use the value BMCSTATS on the ANALYZE command option to enhance the performance of REORG PLUS. In the ANALYZE phase, REORG PLUS uses the statistics already gathered by BMCSTATS instead of gathering the statistics itself.

This solution includes the following products:

  • DASD MANAGER PLUS for DB2
  • REORG PLUS for DB2
  • SNAPSHOT UPGRADE FEATURE for DB2

 

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