Solution integration
- DASD MANAGER PLUS for DB2REORG 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
.
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
- 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, see REORG 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, see REORG PLUS for DB2 command and syntax reference.