Analyzing buffer pools
Use the following procedure to analyze buffer pools for the target DB2.
To analyze buffer pools for the target DB2
From EZDB2, hyperlink on Buffer Pools to see a list of all defined pools with allocated space, utilization, and getpage rates.
05JUL2016 11:44:54 ------ MAINVIEW WINDOW INTERFACE (V6.1.01) ----------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =BFRPL=============DEEO=====*========05JUL2016==11:44:54====MVDB2====D===39
Pool DB2 Vpool Vpool SPool Getpg Interval Session Previous %
Name Target Size Alloc Size /sec Getpages Getpages Getpages Ac
BP0 DEEO 2000 2000 0 0.0 12 962 950
BP1 DEEO 1000 0 0.0 0 0 0
BP2 DEEO 1000 0 0.0 0 0 0
BP3 DEEO 1000 0 0.0 0 0 0
BP4 DEEO 1000 0 0.0 0 0 0
BP5 DEEO 1000 0 0.0 0 0 0
BP6 DEEO 1000 0 0.0 0 0 0
BP7 DEEO 1000 0 0.0 0 0 0
BP8 DEEO 1000 0 0.0 0 0 0
BP9 DEEO 1000 0 0.0 0 0 0
BP10 DEEO 1000 0 0.0 0 0 0
BP11 DEEO 1000 0 0.0 0 0 0
BP12 DEEO 1000 0 0.0 0 0 0Hyperlink on Pool Name to see all status and statistics for one pool.Both interval and session counts are shown.
05JUL2016 11:46:50 ------ MAINVIEW WINDOW INTERFACE (V6.1.01) ----------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =BFRPL====BFRPLXD==DEEO=====*========05JUL2016==11:44:54====MVDB2====D====1
Buffer Pool Statistics Detail.....
Pool Name......................... BP0
VP Size........................... 2000
Simulated Pool Size............... 0
Virtual Pool Sequential Threshold. 80
Deferred Write Threshold.......... 30
Vertical Write Threshold.......... 5
Vertical Write Threshold (Buffers) 0
Parallel Sequential Threshold..... 50
Assisting Parallel Threshold...... 0
Page Steal Algorithm.............. LRU
Page Fix Attribute Y/N............ N
Autosize Attribute Y/N............ N
Minimum Pool Size................. 0
Maximum Pool Size................. 0
Frame size........................ 4K
Interval Session
Virtual Pool Allocation...........
Buffers Allocated............... 2000
Current Active Buffers.......... 16- Scroll down with F8 to see all of the data.
- Press F3 to return to BFRPL.
- Locate current and session ratios for one pool:
- Hyperlink on Getpg/sec.A list of current hit ratios per pool is displayed, BFRPLH.
Hyperlink on Pool Name.A list of current and session ratios for one pool is displayed.
29OCT2019 05:23:38 ------ MAINVIEW WINDOW INTERFACE (V6.3.00) ----------------
COMMAND ===> SCROLL ===> PAGE
CURR WIN ===> 1 ALT WIN ===>
>W1 =BFRPLHD===========DLY6=====*========29OCT2019==05:23:38====MVDB2====D====1
Buffer Pool Hit Ratios........
Pool Name..................... BP0
Interval Session
Hit Ratios....................
VPOOL Hit Ratio % with P/F... 81.58 42.37
VPOOL Hit Ratio % without P/F 81.58 69.42
GBP Hit Ratio %.............. 12.50 7.68
Activity per Second...........
Getpages..................... 0.07 0.34
Page Updates................. 0.01 0.02
Sync I/O..................... 0.01 0.09
Prefetch I/O................. 0.00 0.00
Write I/O.................... 0.00 0.00
Data Set Opens............... 0.00 0.00
zHyperlink Read I/O.......... 0.00 0.00
Read I/O DASD Cache Hits.... 0.01 0.0810MAR2011 17:07:12 --------MainView WINDOW INTERFACE (V6.0.00) ---------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
W1 =BFRPL====BFRPLHD==DB2HC====*========10MAR2011==17:04:18====MVDB2====D====1
Buffer Pool Hit Ratios........
Pool Name..................... BP0
Interval Session
Hit Ratios....................
VPOOL Hit Ratio % with P/F... 17.51 18.55
VPOOL Hit Ratio % without P/F 92.64 81.70
GBP Hit Ratio %.............. 0.00 18.92
Activity per Second...........
Getpages..................... 143.20 4.87
Page Updates................. 29.78 0.61
Sync I/O..................... 0.40 0.06
Prefetch I/O................. 15.51 0.51
Write I/O.................... 0.80 0.02
Data Set Opens............... 0.00 0.00
- Press F3 to return to EZDB2.Group buffer pools are discussed later in the data sharing section.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*