Prevent Availability Risks and Optimize Db2 Performance

The volume and complexity of Db2 Statistics data and Db2 Accounting data creates a major challenge for analysts who want to derive value from the rich metrics available.

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.

Key Features

Automated alerts and intuitive drill downs ensure that when performance or availability issues occur, the root cause is quickly identified and resolved before end-users are impacted or resources wasted.
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.

Key Features

Built-in AI-based health and performance insights and recommendations guide you towards sub-optimal areas impacting performance and availability and provide an intuitive and easy way to resolve and optimize your Db2 environment.
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.

Key Features

Integrating data, such as from CICS, IFCID 199, or other SMF sources provides insights Db2 data alone cannot. Utilize built-in report customization and data integrations to take full control of your data and provide answers to any of your questions.
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.

Key Features

AI-based anomaly detection alerts you to significant changes based on your specific baselines so issues that cannot be detected due to normal performance constraints are immediately found.
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.

        
    

Best Practice Db2 Compliance Ratings

        
    

Db2 Health Insights Focused Views

        
    

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.

        
    

Health Insights Assessments – Time Charts

        
    

Buffer Pool and I/O Metrics Extensive Visibility

        
    

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).

In this example a drilldown seamlessly integrates connection type (from Accounting data) with sync read I/Os (from Statistics data) to create this time of day profile.

        
    

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.

        
    

Combine Different Db2 Accounting Data Profiles

        
    

Drilldown by Correlation Name for Work Coming into CICS from Db2

        
    

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.

        
    

Visual Comparisons Between CICS and Db2 Data

        
    

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.

Speak to an Expert Today

Whether you’re in the early stages of product research, evaluating competitive solutions, or trying to solve a problem, we’re happy to help you get the information you need to move forward with your IT initiatives.

Explore Db2 Resources

Analysis and Monitoring of Db2 & CICS SMF Performance Data

Learn how to add predictive and prescriptive value to your CICS & Db2 monitoring process with new analytics capabilities.

Learn More

Introduction to Modern Db2 for z/OS Performance Monitoring

Getting visibility into key Db2 for z/OS areas is crucial to proactively prevent performance issues from occurring and quickly resolve issues that are already in effect.

Learn More

AIOps for Smarter CICS and Db2 SMF Performance Analysis

Discover the benefits of modernizing how you understand and leverage SMF data for CICS and Db2 Performance analysis.

Learn More

Areas Supported by IntelliMagic Vision for z/OS

Systems, Processors & MLC

Systems, Processors & MLC

Continual visibility into how the z/OS systems infrastructure is handling your workloads helps you improve performance and protect availability.
Learn More
Db2, CICS, WebSphere, TCP/IP & MQ

Db2, CICS, WebSphere, TCP/IP & MQ

Unprecedented visibility into the extensive metrics provided by critical z/OS subsystems to enhance availability and analyze performance.
Learn More
Disk, Tape & Virtual Tape

Disk, Tape & Virtual Tape

Industry-leading visibility and expertise to analyze and proactively identify potential I/O issues in your disk and virtual tape and replication architectures.
Learn More

Flexible Deployment and Monitoring

In the Cloud

Cloud based deployment can be accessed from everywhere in the world and is easy to share with colleagues

Services and Support

Take advantage of IntelliMagic's experienced performance experts for standalone custom services or daily monitoring

On Premise

Install the software on premise and use it offline for total control of your installation

Start a Free Trial, Schedule a Demo, or Request Pricing or Product Info