Using advisors

This topic provides information about advisors that provide tuning advice that is not included in the BMC AMI Pool Advisor for Db2 documentation.

Background advisors

The following individual component advisors monitor the main BMC System Performance for Db2 data groups:

Related topic

Using

  • Thread Environment Advisor
  • DDF Environment Advisor
  • Log Environment
  • Maximum Data Sets Advisor

Executing a rule

If BMC System Performance for Db2 is able to issue a command to implement a recommendation, you can immediately execute it.

The OPERTUNE for DB2 component is used to issue commands to modify ZPARM values.

To execute the command

Click EXEC on the Pending action list.

Important

If a command cannot be executed by System Performance, the word EXEC is not underscored.

The following figure is displayed when a command is executed.

DOMEADVO/I                     Advisor Response                   LINE 1 OF 33
Command ====> _______________________________________________ Scroll ===> CSR_

ADVISOR:PMDZCMD1     -- ------------------------------ --  06/19/<yy> 14:26:32
                                Command Interface

 Command Text . . : OPT DHY2 IN(DHY2) SET BP49(+49) NORESET

 Time Submitted . : 14:26:31
 Time Completed . : 14:26:32

 Command Response :
 ______________________________________________________________________________

 IN(DHY2) SET BP49(+49) NORESET

 BMC31164I DDTL IN(DHY2@DDTL) SET BP49(+49) NORESET

 BMC31164I DDTL DHY2 -ALTER BPOOL(BP49) VPSIZE(1649)

 DSNB522I  *DHY2 VPSIZE FOR BP49 HAS BEEN SET TO 1649

The Command Interface panel displays the text of the command that was executed and any messages that were issued in response to the command. In addition, a message is issued to the SYSTSPRT DD of the DOMPROC whenever System Performance issues a command.

 

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