Prevent Availability Risks and Optimize Db2 Performance
Easy visibility into key Db2 metrics through SMF records is crucial to proactively prevent availability risks and to effectively manage and optimize performance.
Comprehensive Solutions to Your Db2 Performance Management Issues
Quickly Troubleshoot Db2 Performance Issues
Reduce Mean Time To Resolution for unpredictable problems.
Discover potential issues before they occur with automated site assessments and easily resolve them
Tune and Optimize Db2 Performance
Tune and optimize your Db2 performance for maximum efficiency.
Comprehensive pre-built reports provide day-one access to tuning recommendations and overall site health.
Extensive Report-Customization and Integrations
Easily integrate data from different sources and customize reports.
Edit, expand, and customize reports with built-in options to add sources, hone in on specific data, view data in different ways, and more.
Identify Db2 Performance Trends and Anomalies
Gain elevated insights and predictability with trending and anomaly detection.
Trending and compare features provide critical before/after views and help you understand performance and resource utilization trends of your Db2 servers.
Health Insights Assessments – Enterprise-wide
Automated assessments of 80+ metrics for every Db2 member and buffer pool in your environment help identify potential risks to availability and performance.
In this example with key Buffer Pool metrics, exceptions relating to hit ratios and page residency times are identified for every data sharing group and presented in a single easily consumable view.
Health Insights Assessments – Focused Views
Numerous drilldowns are available to move from a high-level enterprise-wide view into focused analysis to help identify actionable insights for specific Db2 members, buffer pools, etc. The following image captures the outcome of two such drilldown steps, initially “Pool by Size” (not shown, indicating these exceptions are occurring in buffer pools belonging to the set of 4K buffers) and then by “Buffer Pool” to isolate the exceptions to specific buffer pools (shown here).
Health Insights Assessments – Time Charts
At any phase of the analytical process “Time Charts” of all assessed metrics can be generated to examine potential high-level relationships between the metrics. In this example, possible time-of-day correlations between the two metrics with exceptions (with the orange and red borders) and overall getpage activity (in the first chart) can be evaluated, and any specific metric can be selected for more detailed analysis.
Extensive Visibility into Buffer Pool and I/O Metrics
Since Db2 relies on having needed data residing in a buffer to avoid I/Os that are synchronous with the unit of work (“random sync read I/Os”), extensive visibility into buffer pool and I/O metrics is crucial for Db2 performance tuning.
Here we see the types of I/Os by buffer pool for the selected data sharing group, with those random sync read I/Os (that introduce delays into response times) appearing in red.
Seamlessly Integrate Statistics and Accounting Data
Context-sensitive drilldowns are especially powerful when working with large quantities of data, enabling you to zero in on the subset of data pertinent to the specific type of analysis currently being performed. As one example, industry Db2 performance experts frequently suggest analyses focused by connection type, since online work (e.g., coming into Db2 from CICS) typically has a very different profile from batch work (e.g., coming in through IMS batch BMPs).
Integrated Visibility into Db2 I/O Statistics by Buffer Pool and Database
Powerful insights into disk I/O and cache performance by Db2 buffer pool and database can be facilitated by integrating data set I/O performance data (from SMF 42 records) with Db2 dataset I/O statistics (IFCID 199) data.
Metrics including disk response time by components (IOSQ, Pend, Disc, Conn) and disk cache hits and misses are presented, by Db2 buffer pool (along the top row) and database (along the bottom). And any of these can be selected for more detailed analysis, leveraging numerous drilldowns.
Visibility into Db2 Elapsed Time Profiles
In Db2 accounting data, combining “class 2” (CPU) and “class 3” (wait) times provides an elapsed time profile of time spent within Db2.
Here we see such a profile for work coming from CICS, showing that database sync I/O time (in yellow), CPU time (in red), and Global Contention for L-Locks (gray) are the primary contributors to elapsed time.
Drilldowns by CICS Transaction ID
For work coming into CICS from Db2, we can take advantage of the fact that the calling transaction ID is included in the correlation name field found in the Db2 accounting data to facilitate numerous types of analyses by CICS transaction. This example presents a view of Db2 elapsed time profiles by CICS transaction.
Integration and Visual Comparison of CICS and Db2 SMF Data
Also capitalizing on the presence of the CICS transaction ID in the Db2 correlation name field, additional integration of the measurement data produced by the two subsystems is provided. In this example, CICS SMF 110.1 transaction data (on the top row) is combined with Db2 SMF 101 accounting data (on the bottom row). This facilitates visual comparisons between the two data sources of activity rates, CPU, response/elapsed times, and activity rates by CICS region/Db2 member.
Monitor Db2 Performance and Proactively Prevent Availability Risks
The volume and complexity of Db2 Statistics data (SMF 100) and Db2 Accounting data (SMF 101) data creates a major challenge for analysts who want to derive value from the rich metrics available there. Easy visibility into key Db2 metrics through SMF records is crucial to proactively prevent availability risks and to effectively manage and optimize performance.
IntelliMagic Vision automatically assesses every Db2 member (and even every buffer pool when applicable) to proactively identify potential availability risks in your environment and direct you to important issues that may warrant your attention.
In addition, the intuitive user interface and dynamic context-sensitive drilldowns available throughout IntelliMagic Vision facilitate types of analysis that are not feasible with static reporting solutions, enabling you to:
- Immediately drilldown on a specific subset of data based on observations from the current view
- Pursue one line of analysis, and if that ends up being unfruitful, quickly pursue another hypothesis with minimal wasted time and effort
- Seamlessly navigate to focus your analysis in a manner that insulates you from the fact you are dealing with massive quantities of underlying SMF data
IntelliMagic Vision offers you the out-of-the-box visibility and intuitive navigation to manage every component of your z Systems infrastructure under a single solution, facilitating collaboration across teams that have historically been isolated by siloed tool sets.