Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 
.
.
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.
>W1 =BFRPL=============DEEO=====*========ddmmmyyyy==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.
>W1 =BFRPL====BFRPLXD==DEEO=====*========ddmmmyyyy==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.
>W1 =BFRPLHD===========DLY6=====*========ddmmmyyyy==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.08
- 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*