Skip to Content

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. Commands are listed in chronological order, with the most recent command listed first.

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

Related topic

Viewing Pool Advisor reports

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: 13.1  DSGroup: DSNDHY    DSMember: DHY2
   Date-hour                   Command issued
   --------------------------  ------------------------------------------------
+  2021-06-19-15.55.09.895289   DB2 DHY2 -ALTER BUFFERPOOL(BP16K9) VPSIZE(497)
+  2021-06-19-15.55.09.561965   DB2 DHY2 -ALTER BUFFERPOOL(BP16K0) VPSEQT(10)
+  2021-06-19-15.55.09.374410   DB2 DHY2 -ALTER BUFFERPOOL(BP8K9) VPSIZE(573)
+  2021-06-19-15.55.09.189666   DB2 DHY2 -ALTER BUFFERPOOL(BP8K0) VPSEQT(10)
+  2021-06-19-15.55.09.041848   DB2 DHY2 -ALTER BUFFERPOOL(BP32K9) VPSIZE(125)
+  2021-06-19-15.55.08.891025   DB2 DHY2 -ALTER BUFFERPOOL(BP32K) VPSIZE(312)
+  2021-06-19-15.55.08.783964   DB2 DHY2 -ALTER BUFFERPOOL(BP49) VPSIZE(1698)
+  2021-06-19-15.55.08.571915   DB2 DHY2 -ALTER BUFFERPOOL(BP2) VPSEQT(10)
+  2021-06-19-15.55.08.363148   DB2 DHY2 -ALTER BUFFERPOOL(BP1) VPSEQT(10)
+  2021-06-19-15.55.08.189011   DB2 DHY2 -ALTER BUFFERPOOL(BP0) VPSEQT(10)
+  2021-06-19-15.52.37.712006   OPT DHY2 IN(DHY2) SET BP0(,,,10) NORESET
+  2021-06-19-15.52.31.843789   OPT DHY2 IN(DHY2) SET BP1(,,,10) NORESET
+  2021-06-19-14.26.32.311799   OPT DHY2 IN(DHY2) SET BP49(+49) NORESET
+  2021-06-19-13.33.28.586190   OPT DHY2 IN(DHY2) SET BP35(+2750) NORESET
+  2021-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: 13.1  DSGroup: DSNDHY    DSMember: DHY2
   Date-hour                   Command issued
   --------------------------  ------------------------------------------------
+  2021-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
   ----------------------------------------------------------------------------
+  2021-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
   ----------------------------------------------------------------------------
+  2021-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
   ---------------------------------------------------------------------------------------------------------------
+  2021-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'


 

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

BMC AMI Pool Advisor for Db2 13.1