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:
- 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.
The following figure is displayed when a command is executed.
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.