BMC System Performance for DB2

Optimize DB2 on z/OS system and buffer pool performance

DB2 on z/OS, while delivering significant value, consumes a large percentage of mainframe resources.  A poorly tuned DB2 system affects overall response time and can ultimately lead to costly hardware upgrades. How can you keep systems and buffer pools tuned to reduce DB2 costs and deliver optimal service levels?

BMC solution

BMC System Performance for DB2 monitors your DB2 systems to detect performance problems and correct them before they cause outages. It supplies critical data about DB2, including current thread activity, DB2 status and statistics, buffer pool status and statistics, and lockout events. With dynamic buffer pool tuning, BMC System Performance for DB2 adjusts pool sizes to optimize performance while considering overall storage usage and reduces overhead associated with DB2 dynamic statement cache management. BMC System Performance for DB2 includes the following products:

• BMC MainView for DB2
• BMC Pool Advisor for DB2
• BMC OPERTUNE for DB2

Features and benefits

• Comprehensive monitoring and management - monitors DB2 performance, issues early warnings, and drives automation to correct exceptions, improving availability and reducing risk
• Integrated DB2 storage pool management – dynamically tunes buffer, EDM, sort, and RID pools in real-time to improve performance and reduce risk of outages caused by unpredictable workload fluctuations.
• Dynamic DSNZPARM change support - improves productivity and avoids outage required to make some changes
• Efficient historical data collection - captures accounting and statistics for reporting and trend analysis
• Extensive batch reporting - provides DB2PM-like reports and other reports 
• DB2 performance management database - provides direct access to accounting and statistics data via SQL 

Key differentiators

• Buffer pool management - monitors and can dynamically adjust buffer pool configurations in response to workload fluctuations 
• Single system image – enables you to manage all DB2 subsystems in from a single point of control
• Advanced online history application - keeps thread history online and provides tools for comprehensive thread data analysis
• Integrates with MainView for z/OS, IMS, CICS, IP, VTAM, WebSphere MQ, and Transaction Analyzer using a single interface