Changing the status of rules
Use this procedure to change the status of rules.
Pool Advisor keeps track of the following rules:
- Rules for which the execution mode has been set to Automatic
- Rules rules that are ignored
You can change these settings at any time from the Advisor Rules and Attributes panel. You can view rule definitions from the Rule Details panel.
To change the status of rules
Click on the ADVISOR button from any report.
PMDEROUT/I BACKGROUND ADVISOR DB2 SELECTION LIST LINE 1 OF 2
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
BMCSftwr.PMDROUT ------------------------------------- 06/07 14:29:08
THE OVERALL STATUS OF THE BACKGROUND ADVISORS FOR EACH MONITORED DB2
SUBSYSTEM IS SHOWN BELOW. CLICK ON THE VALUE FOR "CURRENT STATUS"
TO DISPLAY THE INDIVIDUAL ADVISORS FOR THAT DB2 SUBSYSTEM.
DB2 SUBSYSTEM: DLX1 - 12.1 - CURRENT STATUS: NORMAL
DB2 SUBSYSTEM: DLY7 - 12.1 - CURRENT STATUS: *ALERT*Click on the value for Current status.
DOMEADVO/I ADVISOR RESPONSE LINE 1 OF 34
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
ADVISOR:PMDZSUPR -- ------------------------------ -- 06/07/21 14:35:22
Advisor Selection List
The current virtual storage management mode is DECREASE
The current real storage management mode is DECREASE
Click here to change rule settings.
The current status of individual component advisors for the selected DB2
subsystem is shown below. Click on the value for "Current status" to display
the expert advice for a specific component.
Advisor: BUFFER POOL Current status: NORMAL
Advisor: DYNA STMT CACHE Current status: NORMAL
Advisor: EDM POOL Current status: NORMAL
Advisor: RID POOL Current status: NORMAL
Advisor: SORT POOL Current status: NORMAL
Advisor: VIRTUAL STORAGE Current status: NORMAL
Advisor: REAL STORAGE Current status: ALERT
Advisor: GROUP BUFFER POOL Current status: ALERT
Advisor: THREAD ENVIRONMENT Current status: NORMAL
Advisor: DDF ENVIRONMENT Current status: NORMAL
Advisor: LOG ENVIRONMENT Current status: NORMAL
Advisor: MAXIMUM DATA SETS Current status: NORMALLink from Click here to change rule settings.
DOMEADVO/I ADVISOR RESPONSE LINE 1 OF 76
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
ADVISOR:PMDZARUL -- ------------------------------ -- 06/09/21 11:23:21
Advisor Rules and Attributes
DB2 subsystem ID . . . . : DLY7
Total number of rules . : 62
Current rule set version : 6.7
Set ALL rules to: AUTOMATIC MANUAL IGNORE REINSTATE
ID Advisor Ver Aut Ign Ack Description
--- ------- --- --- --- --- --------------------------------------
ER1 EDM 6.5 Y N N EDM pool efficiency less than 70%
ER2 EDM 6.5 Y N N EDM pool efficiency less than 90%
ER3 EDM 6.5 Y N N EDM pool load failures
ER4 EDM 6.5 Y N N EDM pool low utilization
ER5 EDM 5.3 Y N N EDM pool size less than MIN
ER6 EDM 5.3 Y N N EDM pool size greater than MAX
RR1 RID 6.5 Y N N RID pool failure rate > 30%
RR2 RID 6.5 Y N N RID pool failure rate > 10%
RR3 RID 6.3 Y N N RID pool rule 3 currently unused
RR4 RID 6.5 Y N N RID pool low utilization
RR5 RID 6.3 Y N N RID pool size less than MIN
RR6 RID 6.3 Y N N RID pool size greater than MAX
SR1 SRT 6.5 Y N N SRT pool efficiency less than 70%
SR2 SRT 6.5 Y N N SRT pool efficiency less than 90%
SR3 SRT 5.3 Y N N SORT pool size less than MIN
SR4 SRT 5.3 Y N N SORT pool size greater than MAX
BR1 BPM 6.5 Y N N DM event greater than 0
BR2 BPM 6.5 Y N N System hit ratio less than 90%
BR3 BPM 6.5 Y N N System hit ratio less than 70%
BR4 BPM 6.5 Y N N Application hit ratio less than 9
BR5 BPM 6.5 Y N N VP residency time very high
BR6 BPM 6.5 Y N N BP residency time more than 300 s
BR7 BPM 5.3 Y N N Buffer pool size less than MIN
BR8 BPM 5.3 Y N N Buffer pool size greater than MAX
BR9 BPM 6.7 N N N Buffer pool I/O intensity greater
TS1 BPM 5.3 Y N N VPSEQ threshold set too low
TS2 BPM 5.3 Y N N VPSEQ threshold set too high
TW1 BPM 6.2 Y N N DWQT set too low
TW2 BPM 6.4 Y N N DWQT set too high
GB1 GBP 5.3 N N Ignore Group BPool advisor status
DR1 DSN 5.3 Y N N Open data sets above 85% of MAX
DR2 DSN 5.3 Y N N Open data set limit less than MIN
DR3 DSN 5.3 Y N N Open data set limit > MAX
DR4 DSN 5.3 Y N N Data sets in extents
FR1 DDF 5.3 Y N N Remote threads queued > 5%
FR2 DDF 5.3 Y N N MAXDBAT less than MIN
FR3 DDF 5.3 Y N N MAXDBAT greater than MAX
HR1 TRD 5.3 Y N N Create thread request queued > 5%
HR2 TRD 5.3 Y N N Foreground threads > 80% of MAX
HR3 TRD 5.3 Y N N Background threads > 80% of MAX
HR4 TRD 5.3 Y N N CTHREAD less than MIN
HR5 TRD 5.3 Y N N CTHREAD greater than MAX
HR6 TRD 5.3 Y N N IDFORE less than MIN
HR7 TRD 5.3 Y N N IDFORE greater than MAX
HR8 TRD 5.3 Y N N IDBACK less than MIN
HR9 TRD 5.3 Y N N IDBACK greater than MAX
LR1 LOG 5.3 Y N N Avg MIN per CHKPT < MIN minutes
LR3 LOG 5.3 Y N N Reduce LOGLOAD when CHKPT > MAX
LR4 LOG 5.3 Y N N LOGLOAD less than MIN
LR5 LOG 5.3 Y N N LOGLOAD greater than MAX
LR6 LOG 5.3 Y N N Log space low
LR7 LOG 5.3 Y N N Log efficiency low
LR8 LOG 5.3 Y N N Archive Pending > 1
LR9 LOG 6.1 Y N N CHKTIME less than MIN
LR10 LOG 6.1 Y N N CHKTIME greater than MAX
LR11 LOG 6.1 Y N N CHKTIME is too high
IR1 DBD 6.5 Y N N DBD cache efficiency less than 70
IR2 DBD 6.5 Y N N DBD cache efficiency less than 90
IR3 DBD 6.5 Y N N DBD cache load failures
IR4 DBD 6.5 Y N N DBD cache low utilization
IR5 DBD 5.3 Y N N DBD cache size less than MIN
IR6 DBD 5.3 Y N N DBD cache size greater than MAXThe Advisor Rules and Attributes panel lists all rules with their current settings. The first time this panel is displayed, the execution mode for all rules is manual and none are ignored (the default settings).
The following information is displayed at the top of the panel:
- Subsystem ID of the Db2 subsystem to which the rules apply
- Number of rules that apply to that Db2
- Most recent product version in which changes or additions to the rule set were made
The following information is listed for each rule:
- Rule ID
- Advisor to which the rule applies
- Last product version in which changes or additions to the rule were made
- Execution mode (Y = auto, N = manual)
- Ignore status (Y = rule is ignored, N = rule is not ignored)
- Acknowledgement status (Y = rule has been acknowledged, N = rule has not been acknowledged, P = acknowledgement pending)
- Description of the condition that triggers the rule
You can change the execution mode or ignore the status of an individual rule by clicking on the Aut or Ign value for that rule. These values toggle between Y and N each time you click on them.
You can change the status of all rules simultaneously in the following ways:- Click AUTOMATIC to change the execution mode of all rules to Automatic. In Automatic mode, the commands associated with the rules are executed whenever a recommendation is triggered. No intervention is necessary.
- Click MANUAL to change the execution mode of all rules to Manual. In Manual mode, no commands are executed automatically. You must execute the command from the Pending Action List (see Pending-Action-List) when a warning or alert is issued.
- Click IGNORE if you want to ignore all rules. No warnings or alerts are displayed and no actions is taken.
- Click REINSTATE to reinstate all ignored rules. Warnings and alerts are displayed in the normal manner.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*