Advisor alerts

The ADVISOR button on common BMC System Performance for Db2 and BMC AMI Pool Advisor for Db2 reports is your window on the background advisors.

In common BMC System Performance for Db2 and Pool Advisor these reports, the ADVISOR button warns you if any problem exists across the sysplex.


Related topic

Using advisors

The ADVISOR button can have the following values:

  • ADVISOR (turquoise) indicates that no problems have been detected and no recommendations have been made.
  • NOTES (green) indicates that at least one recommendation has been made, but not necessarily added to the Pending Action List.
  • WARNING (yellow) indicates that a problem exists that requires attention.
  • ALERT (red) indicates a serious problem that requires immediate attention.

You can use the ADVISOR button to drill down to the specific resource that is experiencing problems.

There are two obvious indications that a problem exists:

  • The value for RID pool efficiency is red
  • The red ALERT button is displayed
PMDEQRPN/I       BMC AMI Pool Advisor For Db2 Report Viewer       LINE 1 OF 11
Command ====> _______________________________________________ Scroll ===> CSR_

BMCSftwr.PMDRIDP1    --    RID POOL STATUS MONITOR     --       10/19 14:19:07
---<  HELP  >--------------------< *ALERT* >----------------------< CONFIG >---
   Actions: ( + ) A - ADVICE H - History

   DB2: DHY2  12.1      Interval start: 2021-10-19-14.05.01  Duration: 00:14:01


          RID Pool     RID Pool
         Size (Blks)  HWM (Blks)    Use         Fail    Aborts -    Aborts -
   Eff    (K bytes)    (K bytes)   Count       Count    No Storage  Int. Limit
   ----  -----------  ----------  ---------   --------  ----------  ----------
+   88%          384          25        195         26         26          76
               12288         800

When the ALERT button is displayed, the problematic condition is not necessarily associated with the data on the current report. If an alert condition exists anywhere on the sysplex, the ALERT button is displayed on all reports.

When you click the ALERT button, the Background Advisor DB2 Selection List panel is displayed. This panel lists all active Db2 subsystems on the sysplex.

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*              

The Current status field indicates the highest severity condition that exists on the Db2 subsystem. The values for Current status correspond to the possible values for the ADVISOR button and are coded with the same colors:

  • NORMAL corresponds to ADVISOR (turquoise)
  • NOTES (green)
  • WARNING (yellow)
  • ALERT (red)

Click the Current status value to display the individual advisors associated with a Db2 subsystem.

The Advisor Selection List panel (see the following figure) lists the individual component advisors for the selected Db2 and the Current status for each. The values represent the highest severity condition associated with the corresponding resource. Click the value for Current status to display the analysis advisor for the resource. 

 

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: NORMAL                          


If recommendations are pending, You can click Action List to display the System-advisor-recommendations.

The current storage management mode is also displayed. Click on the mode value for an explanation of the storage management modes. Storage management mode relates only to the Virtual Storage component of BMC AMI Pool Advisor for Db2.

This section contains the following topics:

 

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