Limited supportBMC 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.

Command log

The Command Log displays a list of commands that have been issued to Db2 as a result of recommendations from the system advisor.

To display the Command Log use the L action code against a Db2 subsystem.

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer       LINE 1 OF 18
Command ====> _______________________________________________ Scroll ===> HALF
                                                                More:     + >
BMCSftwr.PMDCMLOG    --          COMMAND LOG           --       06/19 15:55:10
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) S - Details  R - Response
  DB2: DHY2   Rel: 9.1  DSGroup: DSNDHY    DSMember: DHY2
   Date-hour                   Command issued
   --------------------------  ------------------------------------------------
+  2008-06-19-15.55.09.895289   DB2 DHY2 -ALTER BUFFERPOOL(BP16K9) VPSIZE(497)
+  2008-06-19-15.55.09.561965   DB2 DHY2 -ALTER BUFFERPOOL(BP16K0) VPSEQT(10)
+  2008-06-19-15.55.09.374410   DB2 DHY2 -ALTER BUFFERPOOL(BP8K9) VPSIZE(573)
+  2008-06-19-15.55.09.189666   DB2 DHY2 -ALTER BUFFERPOOL(BP8K0) VPSEQT(10)
+  2008-06-19-15.55.09.041848   DB2 DHY2 -ALTER BUFFERPOOL(BP32K9) VPSIZE(125)
+  2008-06-19-15.55.08.891025   DB2 DHY2 -ALTER BUFFERPOOL(BP32K) VPSIZE(312)
+  2008-06-19-15.55.08.783964   DB2 DHY2 -ALTER BUFFERPOOL(BP49) VPSIZE(1698)
+  2008-06-19-15.55.08.571915   DB2 DHY2 -ALTER BUFFERPOOL(BP2) VPSEQT(10)
+  2008-06-19-15.55.08.363148   DB2 DHY2 -ALTER BUFFERPOOL(BP1) VPSEQT(10)
+  2008-06-19-15.55.08.189011   DB2 DHY2 -ALTER BUFFERPOOL(BP0) VPSEQT(10)
+  2008-06-19-15.52.37.712006   OPT DHY2 IN(DHY2) SET BP0(,,,10) NORESET
+  2008-06-19-15.52.31.843789   OPT DHY2 IN(DHY2) SET BP1(,,,10) NORESET
+  2008-06-19-14.26.32.311799   OPT DHY2 IN(DHY2) SET BP49(+49) NORESET
+  2008-06-19-13.33.28.586190   OPT DHY2 IN(DHY2) SET BP35(+2750) NORESET
+  2008-06-19-13.33.24.780377   OPT DHY2 IN(DHY2) SET BP34(+2750) NORESET

Use the S (Details) action code to expand the report to show details of the rule that triggered the recommendation. Use the R action code to see the command response. The following figure shows an example of the Command Log report expanded to show details and command responses for all commands.

PMDEQRPW/I       BMC AMI Pool Advisor For Db2 Report Viewer       LINE 1 OF 30
Command ====> _______________________________________________ Scroll ===> HALF
                                                                More:     + >
BMCSftwr.PMDCMLOG    --          COMMAND LOG           --       06/19 15:56:49
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) S - Details  R - Response
  DB2: DHY2   Rel: 9.1  DSGroup: DSNDHY    DSMember: DHY2
   Date-hour                   Command issued
   --------------------------  ------------------------------------------------
+  2008-06-19-15.55.09.895289   DB2 DHY2 -ALTER BUFFERPOOL(BP16K9) VPSIZE(497)
.  Trigger rule:  BR8   Change amount:  1152       Recommendation:  DECREASE
   Rule Description:  Buffer pool size greater than MAX
   ----------------------------------------------------------------------------
+  2008-06-19-15.55.09.561965   DB2 DHY2 -ALTER BUFFERPOOL(BP16K0) VPSEQT(10)
.  Trigger rule:  TS2   Change amount:  10         Recommendation:  SET
   Rule Description:  VPSEQ threshold set too high
   ----------------------------------------------------------------------------
+  2008-06-19-15.55.09.374410   DB2 DHY2 -ALTER BUFFERPOOL(BP8K9) VPSIZE(573)
.  Return code:  0000
   Response:    DSNB522I  *DHY2 VPSIZE FOR BP8K9 HAS BEEN SET TO 573    DSN9022  *DHY2 DSNB1CMD '-ALTER BUFFERPOO
   ---------------------------------------------------------------------------------------------------------------
+  2008-06-19-15.55.09.189666   DB2 DHY2 -ALTER BUFFERPOOL(BP8K0) VPSEQT(10)
.  Return code:  0000
   Response:    DSNB524I  *DHY2 VPSEQT FOR BP8K0 HAS BEEN SET TO 10   DSN9022I*DHY2 DSNB1CMD '-ALTER BUFFERPOOL'

Related topic

Viewing Pool Advisor reports



 

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