DB2 Bufferpool questions

Document ID : KB000072634
Last Modified Date : 15/03/2018
Show Technical Document Details
Introduction:
index bufferpool measurement
Question:
I increased the user data and index bufferpool last week.
How can I tell what improvement percentage we got after the increase in bufferpool from Insight?
 
Environment:
Z/OS DB2
Answer:
Every Field is important in its own way and provides an Insight into Buffer Pool Performance.
What is very good in CA Sysview for DB2 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 i would suggest you review are "Hit Ratio" "Sync RD I/O" and "Getpgs" but do review the Field level Help on all columns