Solution integration
DASD MANAGER PLUS for DB2 is a component of the Database Performance for DB2 solution and the BMC Performance for DB2 Databases solution. Customers who acquire the BMC Performance for DB2 Databases solution benefit from the features of the following individual products and technologies.
Product components
The Database Performance for DB2 solution includes the following product components:
- DASD MANAGER PLUS for DB2
- REORG PLUS for DB2
- SNAPSHOT UPGRADE FEATURE for DB2 (SUF)
In addition to the Database Performance for DB2 utilities, the BMC Performance for DB2 Databases solution also includes BMC AMI Command Center.
Technology components
The Database Performance for DB2 solution includes the following technologies:
- BMCSORT (AUP)
- JCL Generation and Execution (AEX)
- User Interface Middleware (UIM) server
- BMC Mainframe DNA Host Services (DHS) and BMC Mainframe DNA
- Common console, a graphical user interface
- DB2 Solution Common Code DB2 Solution Common Code (SCC)
- DB2 Utilities Common Code (D2U)
- BMC Common Statistics (ATS)
Features
This solution provides you with the following features:
- Help determining which required maintenance tasks for your DB2 objects can be automated
- An improved and easy-to-use graphical user interface helps you to navigate and perform tasks more efficiently
- A common interface that enables users of all experience levels to execute and automate database maintenance tasks
- Improved DB2 performance, utilizing thresholds and statistics to generate reorganizations of the data only when needed. This feature also allows you to perform reorganizations without disrupting application access to the data
- The ability to enable you to use the Export utility to copy object definitions residing on a local controlling DASD MANAGER PLUS repository to destination DASD MANAGER PLUS repositories on other DB2 subsystems
- Help to determine when an exception condition warrants a corrective action
The ability to instruct REORG PLUS to use the DASD MANAGER PLUS exceptions table to determine whether an object should be reorganized (by using the value BMC on the CONDEXEC command option)
Using the exceptions table gives REORG PLUS an expanded set of conditions to determine whether the reorganization is needed. For information about the CONDEXEC command option, seeREORG PLUS for DB2 command and syntax reference.
Enhancements to the performance of REORG PLUS by using the value BMCSTATS on the ANALYZE command option
In the ANALYZE phase, REORG PLUS uses the statistics already gathered by BMCSTATS instead of gathering the statistics itself. For information about the ANALYZE command option, seeREORG PLUS for DB2 command and syntax reference.
Related topic