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

Cheryl Watson's Tuning Letter

Benefits of Analysis Across SMF Data Types

No matter which z/OS subsystem you are primarily responsible for, this article will help you blur the boundaries between the SMF ‘silos’ for each product.

Read more
Webinar

A Performance Analyst’s Guide to Mainframe zERT Analysis | IntelliMagic zAcademy

This webinar recording will show real use-cases to introduce you to some of the ways to identify security risks and issues within network traffic.

Watch Webinar
Blog

Mainframe Cost Savings Part 2: 4HRA, zIIP Overflow, XCF, and Db2 Memory

This blog covers several CPU reduction areas, including, moving work outside the monthly peak R4HA interval, reducing zIIP overflow, reducing XCF volumes, and leveraging Db2 memory to reduce I/Os.

Read more

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