Troubleshoot Db2 Buffer Pool Performance Issues

Effective exploitation of Buffer Pools is essential to achieving optimal Db2 performance, and so there is great value in having the capability to quickly visualize, drill down, and monitor Db2 buffer pool data.

This video demonstrates the value of having great visibility and context sensitive drilldowns into the rich set of buffer pool and sync I/O metrics available in the SMF 100 Db2 statistics records for both local and group buffer pools.

Examples demonstrated in the video include Prefetch activity (by type), Getpage activity, Sync reads, and Group Buffer Pool reads due to buffer cross invalidations.

Related

Whitepaper

Reporting on Tailored Fit Pricing Enterprise Consumption

Discover ways to track your MSU consumption, and how to identify and investigate situations where your actual consumption is out of line with the expected consumption.

Download
Video

Health Insights and Change Detection

To help enhance the value you can derive from that SMF data, IntelliMagic Vision provides two complementary types of automated anomaly detection: health insights and change detection.

Watch video
Video

CICS Max Tasks: Automated Change Detection Use Case 7

Change Detection and Health Assessments (based on pre-defined best practice conditions) play complementary roles, but there can be scenarios where they both flag issues. This use case with CICS Max Tasks is one such example.

Watch video

Go to Resources

Contact Us

Experience firsthand the deepest visibility into your z/OS systems, processors, network, disk and tape environments. 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.

Supported Areas in IntelliMagic Vision for z/OS Systems

Monthly License Charges (MLC)

Tune your processor configuration to increase the MIPS you get out of your mainframe hardware.

Learn More

Coupling Facility

Configure Coupling Facilities for optimal availability and proactively identify hidden health and performance risks

Learn More

Db2

See Buffer Pool imbalances and proactively identify upcoming risks to your Db2 health and performance

Learn More

CICS Transactions

Save time looking for problems and profile CICS transaction data and see transaction response time

Learn More

zEDC Cards

Ensure sufficient capacity and consistent performance for IBM zEDC availability.

Learn More

TCP/IP

Monitor the health of your TCP/IP and analyze traffic from different perspectives.

Learn More

Show all

Other Supported Environments

z/OS Disk and Replication

Early warning system that automatically identifies I/O issues in the making in your disk storage system and replication architecture.
Learn More

z/OS Virtual Tape

Performance and availability management for Virtual and Physical Tape, with specific support for IBM TS7700 and Oracle VSM tape solutions.
Learn More

SAN Storage and Fabric

IntelliMagic Vision collects performance and configuration information on the VMware, fabric and storage systems to provide a complete and end-to-end picture.
Learn More