Viewing the Exception Advisor reports online

Before you begin

To view the Exception Advisor online reports

1. Access the Exception Advisor.
   1. On the SQL Performance for DB2 main menu, select A (Performance Advisors) and press Enter.

   2. On the Performance Advisors panel, select B (Exception Advisor) and press Enter.The Exception Advisor panel is displayed.

      DOMCPNL3 I                  EXCEPTION ADVISOR                      10:58:20
      COMMAND ====> _____________________________________________________________
                                                                                
      CURRENT DATA COLLECTOR : DOB2    STATUS : ACTIVE   DATA COLLECTION : READY
                                                                                
      CHANGE SETTINGS BELOW TO LOCATE ADVISOR RUN TABLE.  THEN PRESS ENTER.      
                                                                                
      DB2 SUBSYSTEM WHERE PERFORMANCE ADVISOR DATABASE RESIDES: DEFF             
                                                                (BLANK FOR LIST)
                                                                                
      NAME OF EXCEPTION ADVISOR RUN TABLE--SPECIFY SYNONYM, TABLE, VIEW, ALIAS,  
        CREATOR.TABLE, CREATOR.VIEW, OR CREATOR.ALIAS:                           
                                                                                
      BMCSFTWR.XADVISOR_RUNS____________________________________________________
      (BLANK FOR TABLE BMCSFTWR.XADVISOR_RUNS)

2. Use the Exception Advisor panel to specify the location of your Exception Advisor Run Table.This table records information about recent executions of the Exception Advisor. In order to view the Exception Advisor reports, you must specify a name that identifies the table, along with the name of the Db2 where the table resides. The Db2 that you specify must be accessible from the DOMPLEX to which the current Data Collector belongs.

   The Current Data Collector field shows the subsystem ID of the currently selected Data Collector. If no Data Collector is selected, this field is blank.

   The Status field shows the status of the currently selected Data Collector. Possible values are:

   • ACTIVE
   • DOWN
   • STOPPING

   • INVALID

     If no Current Data Collector subsystem is selected, this field is blank.

     Note

     A status of INVALID indicates one of the following:

     • A Data Collector has been defined using an SSID that already exists on the z/OS system (a Db2 SSID, for example). In this case, define a new Data Collector using a valid SSID and delete the invalid Data Collector.
     • The selected Data Collector is for a level of the product prior to the level currently being used. You must migrate the Data Collector to the current level before you can use it.

   1. In the Db2 subsystem where Performance Advisor Database resides field, specify the subsystem name, or leave the field blank and press Enter to select the list of Db2 subsystems known to the current Data Collector.
   2. In the Name of Exception Advisor Run Table field, specify the fully-qualified name of a table, view, or alias, or the synonym that defines the Exception Advisor Run Table where the Exception Advisor recorded its results. This is the exception.runtab value from your Exception Advisor batch job.

   3. Press Enter to view the EXCEPTION ADVISOR-EXCEPTIONS panel.

      BMCSftwr.PAXARPT2    --  EXCEPTION ADVISOR-EXCEPTIONS  --       02/06 11:49:18
         For +: R-Rules   S-SQL Text V-Hostvars O-Objects 1-More                     
         For .: A-Advice  H-History                                                  
                                                                                    
         Exception Advisor runtime: yyyy-09-08-21.03.36.311202 level: Detail         
                                                                                    
         Timestamp                  SSID Plan     Program  Stmt  Type      Reason    
         ========================== ==== ======== ======== ===== ========= ==========
      +  yyyy-08-29-21.00.49.328718 DHZ6 AFDPGM   @PGM05O    269 OPEN      CPU TIME  
      .    +------------------------------------------------------------------------+
           ( CPU TIME                      =    0.647173 Threshold: >      1.000000 )
      .    ( SYNCIO WAIT PERCENTAGE        =   43.751999 Threshold: >     30.000000 )
      .    ( GETPAGE COUNT                 = 7656.000000 Threshold:        0.000000 )
      .    ( GETPAGES PER SYNCIO           =    1.004000 Threshold: <      2.000000 )
      .    ( GLOBAL CONTENTION             =    0.000000 Threshold: >     30.000000 )
      .    ( CHILD L-LOCK WAIT             =    0.000000 Threshold: >     30.000000 )
      .    ( OTHER L-LOCK WAIT             =    0.000000 Threshold: >     30.000000 )
      .    ( PAGE P-LOCK WAIT              =    0.000000 Threshold: >     30.000000 )
           +------------------------------------------------------------------------+
      +  yyyy-08-29-21.00.49.328718 DHZ6 AFDPGM   @PGM05O    269 OPEN      ELAPSED TM
      .    +------------------------------------------------------------------------+
           ( ELAPSED TM                    =    8.777678 Threshold: >      1.000000 )
      .    ( SYNCIO WAIT PERCENTAGE        =   43.751999 Threshold: >     30.000000 )
      .    ( GETPAGE COUNT                 = 7656.000000 Threshold:        0.000000 )
      .    ( GETPAGES PER SYNCIO           =    1.004000 Threshold: <      2.000000 )
      .    ( GLOBAL CONTENTION             =    0.000000 Threshold: >     30.000000 )
      .    ( CHILD L-LOCK WAIT             =    0.000000 Threshold: >     30.000000 )
      .    ( OTHER L-LOCK WAIT             =    0.000000 Threshold: >     30.000000 )
      .    ( PAGE P-LOCK WAIT              =    0.000000 Threshold: >     30.000000 )

3. On the EXCEPTION ADVISOR-EXCEPTIONS panel you can view more information about the exceptions.On exception lines that start with a + (plus sign), you can execute the following commands by typing over the + with the appropriate letter and pressing Enter:

   • O-See the objects associated with the exception.
   • R-See the rules for the exception.
   • S-See the SQL text for the exception.
   • V-See the host variables associated with the exception.
   • 1-See more information on the exception.

   On exception detail lines that start with a . (period), you can execute the following commands by overwriting the . (period) with the appropriate letter and pressing Enter:

   • A-See advice related to this threshold.
   • H-See exception history related to this threshold.