Displaying a rule
A rule describes a condition in Db2. When that condition is met,
Pool Advisor
triggers a recommendation.
When you click on RULE on the Pending Action List panel, the Rule Details panel displays the rule associated with the selected recommendation.
DOMEADVO/I Advisor Response LINE 1 OF 29
Command ====> _______________________________________________ Scroll ===> CSR_
ADVISOR:PMDZRULE -- ------------------------------ -- 06/19/17 14:23:31
Rule Details
Rule Identifier: BR3 Rule Version: 5.3 DB2: DHY2
To control by individual buffer pool: Click here
Rule Description:
A significant I/O rate, sequential access is medium,
virtual pool residency time is less than 30 seconds, and the
system hit ratio is less than 70%.
The action taken by this rule increases the size of the buffer pool by
10% (default), to a maximum of 125% (default) of the original buffer
pool size. These default increment and maximum values can be overridden
by modifying the SIZE_bpid_INC and SIZE_bpid_MAX values in the variable
repository.
Execution Mode: Manual Click here to set automatic mode.
Rule Ignored: No Click here to ignore this rule.
Times Triggered: 1 Click here to reset this counter.
Command ====> _______________________________________________ Scroll ===> CSR_
ADVISOR:PMDZRULE -- ------------------------------ -- 06/19/17 14:23:31
Rule Details
Rule Identifier: BR3 Rule Version: 5.3 DB2: DHY2
To control by individual buffer pool: Click here
Rule Description:
A significant I/O rate, sequential access is medium,
virtual pool residency time is less than 30 seconds, and the
system hit ratio is less than 70%.
The action taken by this rule increases the size of the buffer pool by
10% (default), to a maximum of 125% (default) of the original buffer
pool size. These default increment and maximum values can be overridden
by modifying the SIZE_bpid_INC and SIZE_bpid_MAX values in the variable
repository.
Execution Mode: Manual Click here to set automatic mode.
Rule Ignored: No Click here to ignore this rule.
Times Triggered: 1 Click here to reset this counter.
From the Rule Details panel, perform one of the following actions:
- If you want to apply the rule to individual buffer pools, click next to the To control by individual buffer pool field. The following figure shows an example of the Apply rules by buffer pool panel.
- If you feel comfortable letting the product automatically issue the command that is associated with this rule whenever the rule is triggered, you can change the execution mode to Automatic on this panel.
- If you do not want a recommendation to be triggered when the condition that is associated with this rule exists, you can choose to ignore the rule whenever the condition that is associated with the rule is detected.
- To be notified whenever the condition exists, leave the execution mode set to Manual and do not choose to ignore the rule.
The following figure shows Apply rules by buffer pool panel.
DOMEADVO/I Advisor Response LINE 1 OF 52
Command ====> _______________________________________________ Scroll ===> CSR_
ADVISOR:PMDZBRUL -- ------------------------------ -- 10/28/17 16:50:42
Apply rules by buffer pool
Rule Identifier: BR3 Rule Version: 5.3 DB2: DEDO
Rule Description: System hit ratio less than 70%
Click on the Buffer ID value to create an individual rule or delete an
existing individual rule. See product manual for details.
Buffer Times Times Buffer Times Times
ID Aut Ign Ack Trig Exec ID Aut Ign Ack Trig Exec
------- --- --- --- ------- ------- ------- --- --- --- ------- -------
BP0 N N N BP1 N N N
BP2 N N N BP3 N N N
BP4 N N N BP5 N N N
BP6 N N N BP7 N N N
BP8 N N N BP9 N N N
BP10 N N N BP11 N N N
BP12 N N N BP13 N N N
BP14 N N N BP15 N N N
Command ====> _______________________________________________ Scroll ===> CSR_
ADVISOR:PMDZBRUL -- ------------------------------ -- 10/28/17 16:50:42
Apply rules by buffer pool
Rule Identifier: BR3 Rule Version: 5.3 DB2: DEDO
Rule Description: System hit ratio less than 70%
Click on the Buffer ID value to create an individual rule or delete an
existing individual rule. See product manual for details.
Buffer Times Times Buffer Times Times
ID Aut Ign Ack Trig Exec ID Aut Ign Ack Trig Exec
------- --- --- --- ------- ------- ------- --- --- --- ------- -------
BP0 N N N BP1 N N N
BP2 N N N BP3 N N N
BP4 N N N BP5 N N N
BP6 N N N BP7 N N N
BP8 N N N BP9 N N N
BP10 N N N BP11 N N N
BP12 N N N BP13 N N N
BP14 N N N BP15 N N N
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*