Viewing near-term historical data from current trace data sets

To view near-term historical data from current trace data sets

1. On the 

   Apptune

    Main Menu, select SQL Workload and press Enter.The SQL Workload Analysis Menu is displayed.

2. Select Time interval and press Enter.The Select Analysis Interval report is displayed. This report lists time intervals for all Db2s in the current trace data sets. You can select a single interval or a range of intervals.

   Select Analysis Interval report

   ASQEQRTN/I                     VIEW A REPORT                      LINE 1 OF 20
   COMMAND ====> _______________________________________________ SCROLL ===> CSR_
   BMCSftwr.SQMINTVD    --    SELECT ANALYSIS INTERVAL    --       01/28 19:23:48
   SELECT A SINGLE INTERVAL OR A RANGE OF INTERVALS. TYPE "S" BESIDE A SINGLE
   INTERVAL OR BESIDE THE FIRST AND LAST INTERVALS IN THE RANGE, AND PRESS    
   ENTER.  EXIT WHEN FINISHED.                                                
                                                                              
   ACTIONS: F-FILTERING CRITERIA                                               
                                                                              
    +------------------- INTERVAL -----------------+        NUMBER     ACTIVE  
    BEGIN               END                 DURATION  DB2   ENTRIES    FILTER  
    ------------------  ------------------  --------  ----  -------   --------
   + 01/28/11 16:19:59  01/28/11 19:23:48 03:03:49   DEBF        0    DOTDEFF
   + 01/28/11 16:19:59  01/28/11 19:23:48 03:03:49   DEDK      915    DOTDEFF
   + 01/28/11 16:19:59  01/28/11 19:23:48 03:03:49   DEFF      301    DOTDEFF
   + 01/28/11 16:19:59  01/28/11 19:23:48 03:03:49   DEFM        0    DOTDEFF
   + 01/28/11 09:10:59  01/28/11 14:20:59 05:10:00   DEDK     2027    DOTDEFF
   + 01/28/11 09:10:59  01/28/11 14:20:59 05:10:00   DEFF     1447    DOTDEFF
   + 01/28/11 09:10:59  01/28/11 14:20:59 05:10:00   DEFM       61    DOTDEFF
   + 01/28/11 00:00:00  01/28/11 08:54:59 08:54:59   DEBF        0    DOTDEFF
   + 01/28/11 00:00:00  01/28/11 08:54:59 08:54:59   DEFF     5412    DOTDEFF
3. Type S beside a single interval or beside the first and last intervals in the range, and press Enter. Press F3 when you finish selecting intervals.If you want to report on multiple intervals, you should check the filtering criteria for all intervals. If you view data from multiple intervals that used different filters, the data might not be meaningful.

4. Type F over the + (plus sign) beside the interval, and press Enter.The Associated Filter Criteria report is displayed. Use the filtering criteria to select the intervals for your reporting session and to determine which reports are relevant to the data collected. (For example, exception reports are relevant only if exception data was collected.) 

   Associated Filter Criteria report

   ASQEQRTW/I                      View a Report                      LINE 1 OF 8                                            
   Command ====> _______________________________________________ Scroll ===> CSR_                                            
   BMCSftwr.SQMINTVF    --   ASSOCIATED FILTER CRITERIA   --       09/13 23:54:56                                            
      DIY4 - Start:  09/13/16 14:04:59 END:  09/13/16 15:59:59 Entries:     146                                              
                           Active filter name:  !BMCTEST                                                                     
      Actions: C-Collection options E-Exceptions 1-More                                                                      
                                              Coll, Options    Keys              +--------- Exception settings ---+ EffSt Neg
      Program  Plan     Userid   Corrid       Thrd  ABCDE  FG  ABCDEFGHIJKLMNOPQ  Elapsed    CPU     GPS  SIOS ABCD Count SQL
      -------- -------- -------- ------------ ----  -----  --  ----------------- -------- -------- ----- ----- ---- ----- ---
   +  *        DISTSERV *        *            Y, N  YYYYY  YN  YYYYYNYNNNNNNYNNN        0        0     0     0 YYYN  1000 YYN
   +  *        *        *        *            Y, N  YYYYY  YN  YYYYYNYNNNNNNYYYN        0        0     0     0 YYYN  1000 YYN
5. Press F3 until you return to the SQL Workload Analysis menu.

6. Select Data Source, Db2(s) and press Enter.The Data Source panel is displayed. Use this panel to specify the source of records and the Db2 subsystems for reporting.

   Data Source panel

   DOMEQFIS/I                        DATA SOURCE                         17:17:40
   COMMAND ====> ________________________________________________________________
                                                                                
   TYPE THE DATA SOURCE FOR REPORTING BELOW. THEN EXIT.                          
                                                                                
   DATA SOURCE . . . . . . S           ( D =DATA SET            )                
                                       ( A =ARCHIVE DIRECTORY   )                
                                       ( S =DC SUBSYSTEM : DAC1 )                
   DATA SET  . . . . . . . ____________________________________________          
                                                                                
   DB2 SSID LIST . . . . . *___ ____   ( * FOR ALL)                              
                           ____ ____ ____ ____ ____                              
                           ____ ____ ____ ____ ____                              
                           ____ ____ ____ ____ ____                              
                           ____ ____ ____ ____ ____                              
                           ____ ____ ____ ____ ____                              
                           ____ ____ ____ ____ ____
7. In the Data source field, type S.
8. In the Db2 SSID list field, specify the subsystem IDs of the Db2 subsystems that you want to examine. You can specify up to 32 Db2s or you can enter an * (asterisk) in the first field to select all Db2 subsystems in the data set.
9. Press F3 until you return to the SQL Workload Analysis Menu.From this menu, you can continue your reporting session.