BMC MAINVIEW for DB2

Optimize DB2 subsystem performance

DB2 on z/OS, while delivering significant value, consumes a large percentage of mainframe resources. While a poorly tuned DB2 system affects overall response time and can ultimately lead to costly hardware upgrades, a finely tuned system helps to reduce the overall cost of ownership for DB2 on z/OS while delivering better service to end-users. 

BMC solution

BMC MAINVIEW for DB2 improves availability of critical databases and applications by automatically detecting exception conditions and providing corrective actions to fix problems before they cause outages. BMC MAINVIEW for DB2 reduces CPU usage to help the IT organization meet service level objectives. Automation and expert advice improve efficiency and productivity of database management personnel.

Features and benefits

• Provides a single point of control for viewing and managing the most complex DB2 environments.
• Improves productivity by simplifying performance tasks that lead to improved performance and reduced cost.
• Monitors DB2 to catch degradation, issue early warnings, and drive automation to correct exceptions, improving availability and reducing risk
• Simplifies catalog navigation with integrated catalog management tools to improve productivity of end users 
• Captures accounting information and statistics efficiently for reporting and trend analysis; performance data can be externalized to DB2 tables
• Provides DB2PM-like reports and other BMC reports; reports can be generated from native SMF data or BMC archive history data sets
• Provides direct access to accounting and statistics data via SQL through the DB2 performance management database

Key differentiators

• Single System Image (SSI) - provides ability to see all DB2 subsystems in the enterprise from a single point of control utilizing unique
• Integration with all BMC MAINVIEW products - supports end-to-end monitoring from a single panel
• Advanced online history application - keeps thread history online longer and provides tools for comprehensive analysis of thread data

Related Products

• BMC System Performance for DB2