Skip to Content

Group Analysis (DATA) report example

Use the following SYSIN statements to generate the Group Analysis (DATA) report, listing the top ten groups that are defined to the SYSTEM-owned application profile named COMPANY.

APPPROF(COMPANY.SYSTEM) -
REPORT(NAME(SQMCACTG) -
       OUTLIM(10))

Related topic

Batch-reports-description-and-examples

Group Analysis (DATA) report (SQMCACTG)

BROWSE    AFDQA.CM00IC1R.REPORT.SQMCACTG.G0051V00                                                         Line 00000000
 Command ===>                                                                                                       Scrol
*********************************************************** Top of Data *************************************************
                       SQMCACTG: GROUP ANALYSIS (DATA)                                  09/05/16 06:43:43    PAGE     1  
                                  INTERVAL: 09/05/16 06:43:43  TO  09/05/16 06:43:43                                     
                                                                                                                        
   ZOOMS:   N-CLNTAP W-CLNTWS L-CORR  T-DETL   K-IMPQUL P-PLAN   S-STMT                                                  
   Y-ACCEL  9-CLNTCT C-CONNID D-DB2   E-ERROR  V-INTVL  R-PROG   U-USER                                                  
   M-ACCMTX I-CLNTID 8-CONNTY B-DSGRP X-EXCPTN O-OBJECT J-REQLOC                                                         
   EXPANDS: A-AVHILO          Z-ZIIP  1-MORE   2-ACCEL                                                                   
   DB2: DIYA DSGRP:           PLAN:            PROG:                                                                     
                    SQL    +----- TOTAL IN-SQL TIME -----+          +- SYNCIOS -+         ROLL-   %ELAPSED               
                                                                                                                        
   APPL. GROUP      CALLS  ELAPSED       % CPU           % GETPAGES TOTAL  GP/SIO COMMITS  BACKS  I/O LOCK ERRORS XCPTNS
   ---------------- ------ --------------- --------------- -------- ------ ------ ------- ------ ---- ---- ------ ------
+  ALL              42341K 42:52.42325  92 3:38:48.296  99 58878239 294615  199.8   45114 64536K  2.4 25.9    610    426
                AVERAGES:  00:00.00006     00:00.00031            1      0                                               
                   HIGHS:  01:04.34676     00:45.04579       632969   8214                                               
                    LOWS:  00:00.00000     00:00.00000            0      0                                               
              +----------------------------------------------------------------------------------------------+           
    ZIIP: 3:28:26.875 AVG: 00:00.00030 NON-ZIIP: 10:21.42094 AVG: 00:00.00001                                            
   IN-DB2 TIMES   ELAPSED: 1 07:40:36  CP: 13:18:40.98 ZIIP: 3:29:24.537                                                 
   %GETPAGES FROM BUFFER  :        10.5                                                                                  
   TOTAL WAIT TIME        : 37:30.26731  LOCK WAIT TIME: 21:13.06034                                                     
   PARALLEL FAILURES      :           8  SYNCIO WAIT   : 01:55.58613                                                     
   RID LIST FAILURES      :           0  ASYNCIO WAIT  : 13:42.70310      ASYNCIOS:     1586K                            
   PREPARE COUNTS  -CACHED:     3133951  UNCACHED      :         591  PCT UNCACHED:         0                            
   PREPARE CPU TIME-CACHED: 3:28:36.536  UNCACHED      : 00:01.39954  PCT UNCACHED:         0                            
   PREPARE CPU AVG -CACHED: 00:00.00399  UNCACHED      : 00:00.00237  PCT UNCACHED:        37                            
   ROWS FETCHED           :    52955391  INSERTED      :       16861                                                     
   ROWS UPDATED           :       28761  DELETED       :        5637  ERRORS REPORTED:    532                            
   LAST EXECUTION TIME    : 2016-09-05-06.43.27.551537      APPTUNE REDUCTION ENTRIES:  40636                            
   +-------------------------------------------------------------------------------------------------------------------+
            NO ACCELERATOR USAGE OR MODELING DATA AVAILABLE.                                                             
+  IBM DB2 PROGRAMS  2702K 03:35.07889   8 02:00.07982   1   633379  19813   32.0     329      4  2.7  0.1     28     14
                AVERAGES:  00:00.00008     00:00.00004            0      0                                               
                   HIGHS:  00:18.20885     00:01.06658        38485    144                                               
                    LOWS:  00:00.00000     00:00.00000            0      0                                               
              +----------------------------------------------------------------------------------------------+           
    ZIIP: 00:01.67911 AVG: 00:00.00000 NON-ZIIP: 01:58.40070 AVG: 00:00.00004                                            
   IN-DB2 TIMES   ELAPSED: 04:52.25758 CP: 02:07.99967 ZIIP: 00:01.71996                                                 
   %GETPAGES FROM BUFFER  :        16.0                                                                                  
   TOTAL WAIT TIME        : 00:31.10160  LOCK WAIT TIME: 00:00.28783                                                     
   PARALLEL FAILURES      :           0  SYNCIO WAIT   : 00:06.85344                                                     
   RID LIST FAILURES      :           0  ASYNCIO WAIT  : 00:01.26185      ASYNCIOS:      2611                            
   PREPARE COUNTS  -CACHED:       74947  UNCACHED      :         334  PCT UNCACHED:         0                            
   PREPARE CPU TIME-CACHED: 01:53.99046  UNCACHED      : 00:00.83987  PCT UNCACHED:         1                            
   PREPARE CPU AVG -CACHED: 00:00.00152  UNCACHED      : 00:00.00251  PCT UNCACHED:        62                            
   ROWS FETCHED           :     2690773  INSERTED      :        2604                                                     
   ROWS UPDATED           :          78  DELETED       :         324  ERRORS REPORTED:     28                            
   LAST EXECUTION TIME    : 2016-09-05-06.42.16.297421      APPTUNE REDUCTION ENTRIES:   1395                            
   +-------------------------------------------------------------------------------------------------------------------+
            NO ACCELERATOR USAGE OR MODELING DATA AVAILABLE.                                                             
                       SQMCACTG: GROUP ANALYSIS (DATA)                                  09/05/16 06:43:43    PAGE     2  
                                  INTERVAL: 09/05/16 06:43:43  TO  09/05/16 06:43:43                                     
                                                                                                                        
   ZOOMS:   N-CLNTAP W-CLNTWS L-CORR  T-DETL   K-IMPQUL P-PLAN   S-STMT                                                  
   Y-ACCEL  9-CLNTCT C-CONNID D-DB2   E-ERROR  V-INTVL  R-PROG   U-USER                                                  
   M-ACCMTX I-CLNTID 8-CONNTY B-DSGRP X-EXCPTN O-OBJECT J-REQLOC                                                         
   EXPANDS: A-AVHILO          Z-ZIIP  1-MORE   2-ACCEL                                                                   
   DB2: DIY5 DSGRP:           PLAN:            PROG:                                                                     
                    SQL    +----- TOTAL IN-SQL TIME -----+          +- SYNCIOS -+         ROLL-   %ELAPSED               
   APPL. GROUP      CALLS  ELAPSED       % CPU           % GETPAGES TOTAL  GP/SIO COMMITS  BACKS  I/O LOCK ERRORS XCPTNS
   ---------------- ------ --------------- --------------- -------- ------ ------ ------- ------ ---- ---- ------ ------
   ---------------- ------ --------------- --------------- -------- ------ ------ ------- ------ ---- ---- ------ ------
+  IBM DB2 PROGRAMS     50 00:02.55892 100 00:00.02983 100      369    108    3.4      10      0  2.7  7.1      0      0
                AVERAGES:  00:00.05118     00:00.00060            7      2                                               
                   HIGHS:  00:02.12703     00:00.00594           57     38                                               
                    LOWS:  00:00.00000     00:00.00000            0      0                                               
              +----------------------------------------------------------------------------------------------+


 

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

BMC AMI Apptune for Db2 13.1