Skip to Content
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 Pool Advisor for Db2 13.1.

Buffer Pools Status Monitor

The Buffer Pools Status Monitor report, shown below, presents a concise assessment of buffer pool performance for the selected Db2 subsystem.

In one row of statistics per pool, you can quickly see most of the relevant data that indicates if performance is good, bad, or somewhere in between. 

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer       LINE 1 OF 17
Command ====> _______________________________________________ Scroll ===> CSR_
                                                                More:     + >
BMCSftwr.PMDBPM2     --  BUFFER POOLS STATUS MONITOR   --       06/19 14:50:15
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) A - ADVICE   H - History      P - Active page sets
                  D - Details  S - More details L - All page sets
   DB2: DHY2 9.1       Interval start: 2008-06-19-14.40.01  Duration: 00:10:14
                 BPsize          Page  Min   Gpgs  PgRds Advr Appl Sys   Gpgs SGpgs RGpgs XISync WIO   Pgs  Updts  Pgset
   PoolID  Eff   (pgs)  PFx PSt  sets  Res   /Sec  /Sec  Evnt HitR HitR  dlyd dlyd  dlyd  IO/s  /Sec  /Wrt /Wrt   Cmpat  PoolID
   ------  ----  ------ --- ---  ---- ------ ----- ----- ---- ---- ---- ----- ----- ----- ------ ----- ---- -----  -----  ------
+  BP0     100%   10000  N   L     245  999   2019     1    0  100  100    0%  0%    0%      0     1    3   242     89    BP0
+  BP1      42%    1500  N   L    8799   41     43    37    0   85   15   15%  0%   15%      0     1    2     2     96    BP1
+  BP2      98%    2500  N   L    9710  999     16     0    0  100   99    0%  0%    0%      0     1    2     3     92    BP2
+  BP7     100%   20000  N   L     405  999      0     0    0  100  100    0%  0%    0%      0     0    0     0     99    BP7
+  BP25     93%    1500  N   L    6967    1   2286  2342    0   99   -2    1%  0%   24%      0     1    2     6     88    BP25
+  BP31    100%    3790  N   L   26311  999      5     0    0  100  100    0%  0%    0%      0     0    1     1     93    BP31
+  BP32    100%    3850  N   L   25855  999      4     0    0  100  100    0%  0%    0%      0     0    1     1     91    BP32
+  BP33    100%   12000  N   L   22711  999      8     0    0  100  100    0%  0%    0%      0     0    1     1     94    BP33
+  BP34    100%    3850  N   L    1057  999      6     0    0  100  100    0%  0%    0%      0     0    1     2     94    BP34
+  BP35    100%    4000  N   L    1092  999      4     0    0  100  100    0%  0%    0%      0     0    1     1     94    BP35
+  BP49     85%    1649  N   L     415    2    924   910    0   98    2    2%  0%   17%      0     1    1     3     87    BP49
+  BP8K0   100%    1080  N   L      11  999    263     0    0  100  100    0%  0%    0%      0     0    0     0     68    BP8K0
+  BP8K9   100%    1089  N   L       0  999      0     0    0  100  100    0%  0%    0%      0     0    0     0      0    BP8K9

Use the S action code to expand the Buffer Pools Status Monitor report to include additional statistics for each buffer pool.

The following figure is an example of an expanded report. 

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer       LINE 1 OF 17
Command ====> _______________________________________________ Scroll ===> CSR_
                                                                More:     + >
BMCSftwr.PMDBPM2     --  BUFFER POOLS STATUS MONITOR   --       06/19 14:50:15
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) A - ADVICE   H - History      P - Active page sets
                  D - Details  S - More details L - All page sets
   DB2: DHY2 9.1       Interval start: 2008-06-19-14.40.01  Duration: 00:10:14
                 BPsize          Page  Min   Gpgs  PgRds Advr Appl Sys   Gpgs SGpgs RGpgs XISync WIO   Pgs  Updts  Pgset
   PoolID  Eff   (pgs)  PFx PSt  sets  Res   /Sec  /Sec  Evnt HitR HitR  dlyd dlyd  dlyd  IO/s  /Sec  /Wrt /Wrt   Cmpat  PoolID
   ------  ----  ------ --- ---  ---- ------ ----- ----- ---- ---- ---- ----- ----- ----- ------ ----- ---- -----  -----  ------
+  BP0     100%   10000  N   L     245  999   2019     1    0  100  100    0%  0%    0%      0     1    3   242     89    BP0
    --------------------------------------------------------------------------                                                     
    Buffer pool size (pages)   :   2000  Getpages per second  . . . . :   832                                                    
    BP efficiency  . . . . . . :   100%   % Sequential getpages . . . :     0                                                    
    BP system hit ratio  . . . :    100  Read I/Os per second . . . . :     0                                                    
    BP application hit ratio   :    100  Page arrival rate  . . . . . :     0                                                    
    BP min page residency time :    999    (pages read per second))                                                              
    BP page fixed  . . . . . . :     No  Write I/Os per second. . . . :     0                                                    
    BP page steal algorithm. . :    LRU  Pages written per write I/O  :     1                                                    
    DB2 buffer manager events  :      0  Page updates per page write  :     0                                                    
    --------------------------------------------------------------------------                                                     
    Aggregate buffer pool performance profile values:                                                                              
      Object type. . . . :  SYS              Update activity. . :          LOW                                  
      Priority . . . . . :  MED              Data size in pages :          SML                                  
      % Sequential access:  LOW              Page sets assigned to pool:   194                            
      Activity level . . :  LOW              Compatibility rating:          88                              
    --------------------------------------------------------------------------   
    Thresholds:                                                                  
      BP sequential steal threshold             :  10   (1-100)                 
      BP parallel I/O sequential steal threshold:  50   (0-100)

The expanded area presents data in an easier-to-read format. Some of the statistics are the same as those in the main part of the report. The data in the expanded area is grouped by related functions.

From the Buffer Pools Status Monitor report, you can select a buffer pool and hyperlink to one of the Buffer-Pool-Page-Sets-reports.

Related topics

Buffer-Pool-Page-Sets-reports

Buffer Pool reports



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Pool Advisor for Db2 12.1