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

Understanding Physical Sequential Datasets

Oftentimes it is sufficient to analyze I/O performance without needing to understand the datasets. The SMF 42 records are useful to obtain a deeper understanding of the datasets and the applications that are using the storage.

Read more
Video

Troubleshoot High CPU and zIIP Utilization in WebSphere Application Server

A common problem performance analysts encounter is high CPU utilization on a server or application without the ability to identify the root cause of the problem quickly and easily.

Watch video
Video

Monitor WebSphere Data Volumes

This video introduces the topic of transaction reporting based on the SMF 120 subtype 9 record, specifically in terms of data volume per request/response.

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