This topic provides information about advisors that provide tuning advice that is not included in the Pool Advisor for DB2 documentation.
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.
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.