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

Blog

Profiling zHyperLink Performance and Usage

In this blog, we demonstrate how to profile zHyperLink performance and usage by reviewing one mainframe site’s recent production implementation of zHyperLink for reads, for Db2.

Read more
Cheryl Watson's Tuning Letter

Real World Experiences with z16 Upgrades

In this reprint from Cheryl Watson’s Tuning Letter, Todd Havekost provides detailed information and insights from his analysis of seven upgrades from both z14 and z15 CPCs to z16s.

Read more
Blog

Mainframe Cost Savings Part 3: Address Space Opportunities

This final blog in the mainframe cost reduction series will cover potential CPU reduction opportunities that produce benefits applicable to a specific address space or application.

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