How to compare APPTUNE intervals side by side?

When you select several intervals to report, the data you will see in the reports corresponds to the accumulation of all selected intervals. To segregate by interval and compare side by side use Zoom V-INTVL. See below how to do it:

1.- In the SQL WORKLOAD ANALYSIS MENU, Choose option 5. TIME INTERVAL and Select the intervals you want to compare

2.- Come back to the SQL WORKLOAD ANALYSIS MENU, Choose option 1. WORKLOAD ANALYSIS.

3.- At any report, use zoom V-INTVL. It will take you to the INTERVAL ANALYSIS report, in the context you are navigating (DB2, PLAN, Program, etc.).

For example, I select all intervals covering day 9th:

 BMCSftwr.SQMCACTR    --    PROGRAM ANALYSIS (DATA)     --       09/12 04:47:56
 SOURCE : DBCA-ACTIVE   INTVL : 09/09 00:00 - 09/09 23:59          MORE:     + >  
 -------------------------------------------------------------------------------
    Zooms:   G-APPGRP 9-CLNTCT C-CONNID D-DB2    E-ERROR  V-INTVL  J-REQLOC     
    Y-ACCEL  Q-CATSQL I-CLNTID 8-CONNTY B-DSGRP  X-EXCPTN O-OBJECT S-STMT       
    M-ACCMTX N-CLNTAP W-CLNTWS L-CORR   T-DETL   K-IMPQUL P-PLAN   U-USER       
    Expands: A-AVHILO F-FULL   H-HDR    Z-ZIIP   1-MORE   2-ACCEL               
    DB2: DJJ1 DSGRP:           PLAN:                                            
                   SWITCH SQL    +----- TOTAL IN-SQL TIME -----+          +- SYN
    PROGRAM   TYPE  COUNT CALLS  ELAPSED       % CPU           % GETPAGES TOTAL
    --------  ---- ------ ------ --------------- --------------- -------- ------
 +  CRIN2PK   PKGE      3 135015 13:09.99547  27 04:56.48221  39 22352112   2397

To see it segregated by interval, I use the V-INTVL zoom:

 BMCSftwr.SQMCACTV    --    INTERVAL ANALYSIS (DATA)    --       09/12 04:48:51
 SOURCE : DBCA-ACTIVE   INTVL : 09/09 00:00 - 09/09 23:59          MORE:       >  
 -------------------------------------------------------------------------------
    Zooms:   G-APPGRP I-CLNTID 8-CONNTY B-DSGRP  X-EXCPTN P-PLAN   S-STMT       
    Y-ACCEL  N-CLNTAP W-CLNTWS L-CORR   T-DETL   K-IMPQUL R-PROG   U-USER       
    M-ACCMTX 9-CLNTCT C-CONNID D-DB2    E-ERROR  O-OBJECT J-REQLOC              
    Expands: A-AVHILO Z-ZIIP   1-MORE   2-ACCEL                                 
    DB2: DJJ1 DSGRP:           PLAN:            PROG: CRIN2PK                   
                               SQL    +----- TOTAL IN-SQL TIME -----+          +
    WORKLOAD INTERVAL          CALLS  ELAPSED       % CPU           % GETPAGES T
    -------------------------- ------ --------------- --------------- -------- -
 +  09/09/19 10:00:00-11:59:59  94764 08:48.83097  67 03:20.77231  68 15126208  
 +  09/09/19 08:00:00-09:59:59  40251 04:21.16451  33 01:35.70990  32  7225904  

Program CRIN2PK was executed only in two intervals and I can see the accounting metrics for each of these intervals.

This procedure works exactly the same if you select manually a range of intervals or if the enhanced interval selection dialog (PTF BQU1104 applied) has combined overlapping intervals for you (DB2 field shows "****").