Db2 bufferpool monitoring inquiry using Sysview for Db2
search cancel

Db2 bufferpool monitoring inquiry using Sysview for Db2

book

Article ID: 72634

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Increased the user data and index bufferpool last week.

How to tell what improvement percentage obtained after the increase in bufferpool within
Sysview Performance Management Option for Db2 for z/OS (IDB2)?
 

Resolution

Every Field is important in its own way and provides an insight into Buffer Pool Performance.

What is very good within IDB2 is the Field Level Help.

If you put your cursor on a column and hit PFK1 (help) not only do you get very detailed field information you will get tuning hints and tips.
The first three columns suggest for review are "Hit Ratio", "Sync RD I/O" and "Getpgs" but do review the Field level Help on all columns.