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 Pool Page Sets reports

The  Buffer Pool Active Page Sets report provides detailed statistics about the active page sets in the selected buffer pool.

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer        LINE 1 OF 8
Command ====> _______________________________________________ Scroll ===> CSR_
                                                                More:       >
BMCSftwr.PMDBPPS     --  BUFFER POOL ACTIVE PAGE SETS  --       06/19 14:58:06
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) A - ADVICE  H - History  D - Pageset details  P - Partitions
                  S - Object details
   DB2: DHY2 9.1       Interval start: 2008-06-19-14.40.01  Duration: 00:15:00                           /Performance Profile Vars/
   Buffer pool: BP1               /- Getpages --/                                                   Int  ( IDX MED LOW LOW LOW SML)
                            Num    per  % of  %   Sync   Totl  Seql Rand  Gpgs  SGpgs RGpgs XISync  DB2
   DBname   PSname   PT Obj parts  sec  pool Seq  RIO/s  GPHt  GPHt GPHt  dlyd  dlyd  dlyd   IO/s   RWI    Typ Pri Seq Act Upd Siz
   -------- -------- -- --- ----- ----- ---- ---- ----- ----- ----- ----- ------ ----- ----- ------  ---    --- --- --- --- --- ---
+  PMDDB4K  TSPSC2   T    1     1    26   57    0     0  100%  N/P%  100%    0%    0%    0%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB4K  IXPG1    I    1     1     8   18    0     2   80%  N/P%   80%   20%    0%   20%      0   N     IDX MED LOW LOW LOW SML
+  PMDDB4K  IXPG2A   I    1     1     4    9    0     0   95%  N/P%   95%    5%    0%    5%      0   N     IDX MED LOW LOW LOW SML
+  PMDDB4K  TSPG1    T    1     1     4    9    0     4    7%  N/P%    7%   93%    0%   93%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB2AA PMDTSA1  T    1   100     1    1    0     1    0%  N/P%    0%  100%    0%  100%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB4K  IXPSC2   I    1     1     1    3    0     0   75%  N/P%   75%   25%    0%   25%      0   N     IDX MED LOW LOW LOW MED
+  PMDDB4K  IXPSC3   I    1     1     1    2    0     0   76%  N/P%   76%   24%    0%   24%      0   N     IDX MED LOW LOW LOW MED
+  PMDDB4K  IXPSC5   I    1     1     0    1    0     0   69%  N/P%   69%   31%    0%   31%      0   N     IDX MED LOW LOW LOW MED

The Buffer Pool All Page Sets report provides detailed statistics about all page sets in the selected buffer pool.

 

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer     LINE 1 OF 8799
Command ====> _______________________________________________ Scroll ===> CSR_
                                                                More:     + >
BMCSftwr.PMDBPPSA    --   BUFFER POOL ALL PAGE SETS    --       06/19 15:00:53
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) A - ADVICE  H - History  D - Pageset details  P - Partitions
                  S - Object details
   DB2: DHY2 9.1       Interval start: 2008-06-19-14.40.01  Duration: 00:15:00                           /Performance Profile Vars/
   Buffer pool: BP1               /- Getpages --/                                                   Int  ( IDX MED LOW LOW LOW SML)
                            Num    per  % of  %   Sync   Totl  Seql Rand  Gpgs  SGpgs RGpgs XISync  DB2
   DBname   PSname   PT Obj parts  sec  pool Seq  RIO/s  GPHt  GPHt GPHt  dlyd  dlyd  dlyd   IO/s   RWI    Typ Pri Seq Act Upd Siz
   -------- -------- -- --- ----- ----- ---- ---- ----- ----- ----- ----- ----- ----- ----- ------  ---    --- --- --- --- --- ---
+  PMDDB4K  TSPSC2   T    1     1    26   57    0     0  100%  N/P%  100%    0%    0%    0%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB4K  IXPG1    I    1     1     8   18    0     2   80%  N/P%   80%   20%    0%   20%      0   N     IDX MED LOW LOW LOW SML
+  PMDDB4K  IXPG2A   I    1     1     4    9    0     0   95%  N/P%   95%    5%    0%    5%      0   N     IDX MED LOW LOW LOW SML
+  PMDDB4K  TSPG1    T    1     1     4    9    0     4    7%  N/P%    7%   93%    0%   93%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB2AA PMDTSA1  T    1   100     1    1    0     1    0%  N/P%    0%  100%    0%  100%      0   N     TBL MED LOW LOW LOW MED
+  PMDDB4K  IXPSC2   I    1     1     1    3    0     0   75%  N/P%   75%   25%    0%   25%      0   N     IDX MED LOW LOW LOW MED
+  PMDDB4K  IXPSC3   I    1     1     1    2    0     0   76%  N/P%   76%   24%    0%   24%      0   N     IDX MED LOW LOW LOW MED
+  DBGROWTH TSGROWTH T    0     1     0    0    0     0  N/P%  N/P%  N/P%    0%    0%    0%      0          .   .   .   .   .   .
+  DBGROWTH TSGROWXX T    2     1     0    0    0     0  N/P%  N/P%  N/P%    0%    0%    0%      0          .   .   .   .   .   .
+  DBV1     IXV1R10R I    1     1     0    0    0     0  N/P%  N/P%  N/P%    0%    0%    0%      0          .   .   .   .   .   .
+  DBV1     IXV1R12R I    1     1     0    0    0     0  N/P%  N/P%  N/P%    0%    0%    0%      0          .   .   .   .   .   .
+  DBV1     IXV1R15R I    1     1     0    0    0     0  N/P%  N/P%  N/P%    0%    0%    0%      0          .   .   .   .   .   .

The product displays the buffer pool performance profile values above the characteristics for each page set. You can easily compare the values and identify the page sets that should be moved to a buffer pool with more compatible characteristics.

From the Buffer Pool Page Sets reports, you can select a page set and hyperlink to the Buffer Pool Page Set Objects report. 

Related topic

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