Default language.

Accounting summary—long report (BACCTDR)


The following figure shows a sample of the Accounting summary—long report (BACCTDR).

The individual sections and field descriptions of this report are listed under Accounting-report-fields.

Related topic


Warning

Important

The report displays accelerator activity only if there are Db2 threads that are using accelerators.


                      BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    1

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

  ELAPSED TIME DISTRIBUTION                                       CLASS 2 TIME DISTRIBUTION
  -------------|-----------------------+------------------------| ---------------|-----------------------+------------------------|
  APPL    96 % |==============================================  | CPU        3 % |=                                               |
  DB2      4 % |==                                              | SE-CPU     0 % |                                                |
  SUSP     1 % |                                                | SUSP      19 % |=========                                       |
               |                                                | NOTACC    78 % |======================================          |

   AVERAGE      APPL (CLASS 1)  DB2 (CLASS 2)  IFI (CLASS 5)   CLASS 3 WAIT   AVERAGE TIME   AVG EVNT   HIGHLIGHTS
   ------------ -------------- -------------- --------------   -------------  -------------- --------   ---------------------------
   ELAPSED TIME       8.977891       0.398360       0.024612   LOCK           0:00:00.000000     0.00   #OCCURS (THREADS)        76
    NONNESTED         8.977891       0.398360            N/A   LATCH          0:00:00.000000     0.00   #ALLIED (THREADS)        73
    STORED PROC       0.000000       0.000000            N/A   SYNC I/O       0:00:00.007711     1.12   #DBAT   (THREADS)         3
    UDF               0.000000       0.000000            N/A    DATABASE I/O  0:00:00.007682        1   #CPU PARALLELISM          0
    TRIGGER           0.000000       0.000000            N/A    LOG/WRT I/O   0:00:00.000029        0   #I/O PARALLELISM          0
                                                               OTHER READ     0:00:00.000609     0.03
   CP CPU TIME        0.014027       0.010141       0.000611   OTHER WRITE    0:00:00.000000     0.00   #NORMAL TERM             76
    AGENT             0.014027       0.010141            N/A   SER.TASK SWTCH 0:00:00.067699     4.67   #ABNORMAL TERM            0
     NONNESTED        0.014027       0.010141            N/A    UPDATE COMMIT 0:00:00.026473     1.71   #NO PROGRAM DATA         15
     STORED PRC       0.000000       0.000000            N/A    OPEN/CLOSE    0:00:00.015896     0.36   #INCRBIND                 0
     UDF              0.000000       0.000000            N/A    SYSLGRNG REC  0:00:00.000654     0.08   #COMMIT                 427
     TRIGGER          0.000000       0.000000            N/A    EXT/DEL/DEF   0:00:00.002268     0.16   #ROLLBACK                 0
   PAR. TASKS         0.000000       0.000000            N/A    OTHER SERVICE 0:00:00.022408     2.37   #SVPT REQUEST             0
   S/E ELIGIBL        0.000000                                 ARC.LOG(QUIES) 0:00:00.000000     0.00   #SVPT RELEASE             0
                                                               ARC.LOG READ   0:00:00.000000     0.00   #SVPT ROLLBACK            0
   S/E CPU            0.000000       0.000000            N/A   DRAIN LOCK     0:00:00.000000     0.00   MAX SQL CASC LEVL      0.00
    TRIGGERS          0.000000                                 CLAIM RELEASE  0:00:00.000000     0.00   UPDATE/COMMIT          0.26
                                                               PAGELATCH      0:00:00.000000     0.00   SYNC I/O AVG.      0.006894
   SUSPEND TIME       0.000000       0.076019            N/A   NOTIFY MSGS    0:00:00.000000
    AGENT                  N/A       0.076019       0.000611   GLOBAL CONT    0:00:00.000000     0.00
    PAR.TASKS              N/A       0.000000            N/A   ASYNC CF REQ         0.000000     0.00
    STORED PR         0.000000                                 TCP/IP LOB     0:00:00.000000     0.00
   NOT ACCOUNT             N/A       0.312200            N/A   CMT PH1 WRT    0:00:00.000000     0.00
   DB2 ENT/EXIT            N/A      44.105263            N/A   TOTAL CL 3           0.076019        6
   EN/EX-STPROC            N/A       0.000000            N/A
   EN/EX-UDF               N/A       0.000000            N/A
   DCAPT DESCR             N/A            N/A       0.000000
   LOG EXTRACT             N/A            N/A       0.000000


   SQL DML   AVERAGE    TOTAL   SQL DCL           TOTAL      SQL DDL    CREATE   DROP  ALTER      LOCKING          AVERAGE    TOTAL
   -------- -------- --------   ------------   --------      ---------- ------ ------ ------      --------------- -------- --------
   SELECT       1.87      142   LOCK TABLE            0      TABLE           0      0      0      TIMEOUTS            0.00        0
   INSERT       0.46       35   GRANT                 0      TEMP TABLE      0    N/A    N/A      DEADLOCKS           0.00        0
   UPDATE       0.64       49   REVOKE                0      INDEX           0      0      0      ESCAL (SHR)         0.00        0
   DELETE       0.37       28   SET SQLID             0      TABLESPACE      0      0      0      ESCAL (EXCL)        0.00        0
                                SET HOST VAR         15      DATABASE        0      0      0      MAX LOCKS HELD      0.01        1
   DESCRIBE     0.28       21   SET DEGREE            0      STOGROUP        0      0      0      LOCK   REQ         43.30     3291
   DESC TBL     0.00        0   SET RULES             0      SYNONYM         0      0    N/A      UNLOCK REQ          7.83      595
   PREPARE      2.47      188   CONNECT 1             0      VIEW            0      0    N/A      QUERY  REQ          0.00        0
   OPEN         2.08      158   CONNECT 2             0      ALIAS           0      0    N/A      CHANGE REQ          1.24       94
   FETCH        3.78      287   SET CONNECT           0      PACKAGE       N/A      0    N/A      OTHER  REQ          0.00        0
   CLOSE        1.88      143   RELEASE               0      PROCEDURE       0      0      0      LOCK   SUSP         0.00        0
   DML-ALL     13.83     1051   CALL                  0      FUNCTION        0      0      0      LATCH  SUSP         0.01        1
                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    2

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

                                ASSOC.LOCATORS        0      TRIGGER         0      0    N/A      OTHER  SUSP         0.00        0
                                ASSOC.CURSOR          0      DIST TYPE       0      0    N/A
                                HOLD LOCATOR          0      SEQUENCE        0      0      0
                                FREE LOCATOR          0      TRUSTED CT      0      0      0      TOTAL  SUSP         0.01        1
                                DCL-ALL              15      ROLE            0      0
                                SET CURR PATH         0      PERMIT/MSK      0      0      0
                                SET CURR PREC         0      JAR                           0
                                                             TRUSTED CT      0      0      0
                                                             TOTAL           0      0      0
                                                             COMMENT ON                    0
                                                             RENAME TBL                    0
                                                             LABEL ON                      0
                                                             RENAME INDEX                  0
                                                             PREPARE RESTRICTED            0
                                                             MERGE STATEMENT               0
                                                             TRUNCATE TABLE                0
                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    3

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55


   NORMAL TERM       AVERAGE    TOTAL   ABNORMAL TERM         TOTAL  IN DOUBT             TOTAL   DRAIN/CLAIM      AVERAGE    TOTAL
   ---------------- -------- --------   ------------------ --------  ------------------ -------   --------------- -------- --------
   NEW USER             0.00         0  APPL PROGRAM ABEND        0  APPL PROGRAM ABEND        0  DRAIN REQ           0.00        0
   DEALLOCATION         1.00        76  END OF MEMORY             0  END OF MEMORY             0  DRAIN FAIL          0.00        0
   APPL PROGRAM END     0.00         0  RESOLVE IN DOUBT          0  END OF TASK               0  CLAIM REQ          30.28     2301
   RESIGNON             0.00         0  CANCEL FORCE              0  CANCEL FORCE              0  CLAIM FAIL          0.00        0
   DBAT INACTIVE        0.00         0
   RRS COMMIT           0.00         0
   TYPE 2 INACTIVE      0.00         0
   END USER THRESH      0.00         0
   BLK STOR THR         0.00         0
   STALENESS THR        0.00         0

   DATA CAPTURE      AVERAGE    TOTAL    DATA SHARING         AVERAGE    TOTAL   QUERY PARALLELISM             AVERAGE    TOTAL
   ---------------- -------- --------    ------------------  --------  -------   -----------------------       --------- ----------
   IFI CALL             2.21       84    GLOBAL CONT RATE(%)     0.00      N/A   MEMBERS USED                       0.00       N/A
   RECS CAPTURED        0.00        0    FALSE CONT RATE(%)      0.00      N/A   MAXIMUM DEGREE                      N/A         0
   LOG REC READ         0.00        0    L-LOCK XES RATE(%)      0.00      N/A   GROUPS EXECUTED                    0.00         0
   ROWS RETURNED        0.00        0    LOCK REQ   - PLOCKS     0.00      N/P     RAN AS PLANNED                   0.00         0
   RECS RETURNED        0.00        0    UNLOCK REQ - PLOCKS     0.00      N/P     RAN REDUCED                      0.00         0
   DATA DESC RETD       0.00        0    CHANGE REQ - PLOCKS     0.00      N/P     ONE DB2-COORDINATOR = NO         0.00         0
   TABLES RETURNED      0.00        0    LOCK REQ   - XES        0.00      N/P     ONE DB2-ISOLATION LEVEL          0.00         0
   DESCRIBES            0.00        0    UNLOCK REQ - XES        0.00      N/P     SEQUENTIAL-CURSOR                0.00         0
                                         CHANGE REQ - XES        0.00      N/P     SEQUENTIAL-NO ESA SORT           0.00         0
                                         SUSPENDS   - IRLM       0.00      N/P     SEQUENTIAL-NO BUFFER             0.00         0
                                         SUSPENDS   - XES        0.00      N/P     SEQUENTIAL-ENCLAVE SERVICES      0.00         0
                                         SUSPENDS   - FALSE      0.00      N/P    MEMBER SKIPPED (%)
                                         INCOMP LOCK             0.00      N/P    DISABLED BY RLF                   0.00         0
                                         NOTIFY SENT             0.00      N/P    REFORM PARAL-CONFIG               0.00         0
                                         L-LOCK RATE(%)             0      N/P    REFORM PARAL-NO BUF               0.00         0
                                                                                  ONE DB2-DCL TEMP TABLE               0         0

   GLOBAL   CONTENTION  L-LOCKS TOTAL   AV.TIME    AV.EVENT       GLOBAL CONT         L-LOCKS      ELAPSED TIME   EVENTS
   ---------------------------------------------------------------------------------------------------------------------
   L-LOCKS                                00.000000     0.00             L-LOCKS                     00:00.000000         0
   PARENTS                                00.000000     0.00              PARENTS                    00:00.000000         0
   CHILD                                  00.000000     0.00              CHILD                      00:00.000000         0
   OTHER                                  00.000000     0.00              OTHER                      00:00.000000         0

    GLOBAL  CONTENTION  P-LOCKS TOTAL   AV.TIME AV.EVENT          GLOBAL CONT         P-LOCKS      ELAPSED TIME   EVENTS
    ---------------------------------------------------------------------------------------------------------------------
   P-LOCKS                                00.000000     0.00            P-LOCKS                      00:00.000000         0
     PAGESET PARTITION                    00.000000     0.00              PAGESET PARTITION          00:00.000000         0
     PAGE                                 00.000000     0.00              PAGE                       00:00.000000         0
     OTHER                                00.000000     0.00              OTHER                      00:00.000000         0

   STORED PROC      AVERAGE    TOTAL       UDF               AVERAGE      TOTAL        RID LIST            AVERAGE     TOTAL
   --------------- -------- --------       -------------  ----------  ---------        ------------------ --------  --------
   CALL STMT           0.00        0       EXECUTED             0.00          0        SUCCESSFUL             1.11        84
   PROC ABEND          0.00        0       ABENDED              0.00          0        FAIL-STORAGE           0.00         0
   CALL TIMEOUT        0.00        0       TIMED OUT            0.00          0        FAIL-LIMIT             0.00         0
   CALL REJECT         0.00        0       REJECTED             0.00          0
                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    4

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55



   TRIGGERS           AVERAGE    TOTAL     LOGGING              AVERAGE         TOTAL    ROWID            AVERAGE      TOTAL
   ----------------  --------  -------     -------------------  ---------  ----------    -------------  ---------  ---------
  STATEMENT TRIGGER      0.00        0     LOG RECORDS WRITTEN       9.18         698    DIRECT ACCESS       0.00          0
  ROW TRIGGER            0.00        0     TOT BYTES WRITTEN      1610.42      122392    INDEX USED          0.00          0
  SQL ERROR OCCUR        0.00        0     LOG RECORD SIZE                        175    TS SCAN USED        0.00          0


   AVERAGE SU            CLASS 1          CLASS 2  OPTIMIZATION       AVERAGE     TOTAL  MISCELLANEOUS          AVERAGE     TOTAL
   ------------  ---------------  ---------------  ----------------  --------  --------  -------------------  --------- ---------
   CPU                    508.91           367.93  REOPTIMIZATION         0.00        0  MAX STOR LOB VALUES       0.00         0
    AGENT                 508.91           367.93  PREP_STMT_MATCH        1.80      137
     NONNESTED            508.91           367.93  PREP_STMT_NO_MATCH     0.67       51
     STPROC                 0.00             0.00  IMPLCIT_PREPARES       0.00        0
     UDF                    0.00             0.00  PREP_FROM_CACHE        0.00        0
     TRIGGER                0.00             0.00  CACHE_LIMIT_EXCEED     0.00        0
    PAR.TASKS               0.00             0.00  PREP_STMT_PURGED       0.00        0

   SE CPU                   0.00             0.00



                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    5

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

    BP0                        AVERAGE    TOTAL
    ------------------------- -------- --------
    BPOOL HIT RATIO (%)          97.44
    GETPAGES                     36.97     2810
    BUFFER UPDATES                2.88      219
    SYNCHRONOUS WRITE             0.00        0
    SYNCHRONOUS READ              0.87       66
    SEQUENTIAL PREFETCH REQS      0.05        4
    LIST PREFETCH REQS            0.57       43
    DYNAMIC PREFETCH REQS         0.00        0
    PAGES READ ASYNCHR            0.08        6

                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    6

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

    BP8K0                      AVERAGE    TOTAL
    ------------------------- -------- --------
    BPOOL HIT RATIO (%)          96.28
    GETPAGES                      3.18      242
    BUFFER UPDATES                0.09        7
    SYNCHRONOUS WRITE             0.00        0
    SYNCHRONOUS READ              0.09        7
    SEQUENTIAL PREFETCH REQS      0.00        0
    LIST PREFETCH REQS            0.00        0
    DYNAMIC PREFETCH REQS         0.29       22
    PAGES READ ASYNCHR            0.03        2

                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    7

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

    BP16K0                     AVERAGE    TOTAL
    ------------------------- -------- --------
    BPOOL HIT RATIO (%)          100.0
    GETPAGES                      0.72       55
    BUFFER UPDATES                0.00        0
    SYNCHRONOUS WRITE             0.00        0
    SYNCHRONOUS READ              0.00        0
    SEQUENTIAL PREFETCH REQS      0.00        0
    LIST PREFETCH REQS            0.00        0
    DYNAMIC PREFETCH REQS         0.09        7
    PAGES READ ASYNCHR            0.00        0

                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    8

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

    BP32K                      AVERAGE    TOTAL
    ------------------------- -------- --------
    BPOOL HIT RATIO (%)          65.22
    GETPAGES                      0.30       23
    BUFFER UPDATES                0.00        0
    SYNCHRONOUS WRITE             0.00        0
    SYNCHRONOUS READ              0.11        8
    SEQUENTIAL PREFETCH REQS      0.00        0
    LIST PREFETCH REQS            0.00        0
    DYNAMIC PREFETCH REQS         0.00        0
    PAGES READ ASYNCHR            0.00        0

                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    9

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55

    BP TOT                     AVERAGE    TOTAL
    ------------------------- -------- --------
    BPOOL HIT RATIO (%)          97.16
    GETPAGES                     41.18     3130
    BUFFER UPDATES                2.97      226
    SYNCHRONOUS WRITE             0.00        0
    SYNCHRONOUS READ              1.07       81
    SEQUENTIAL PREFETCH REQS      0.05        4
    LIST PREFETCH REQS            0.57       43
    DYNAMIC PREFETCH REQS         0.38       29
    PAGES READ ASYNCHR            0.11        8

                                       /------- AVERAGES PER PACKAGE EXECUTION (SECTION COUNT FOR DB2 V8) -------\ /-- AVERAGE --\
   PACKAGE TOTALS                                CPU AND ELAPSED TIMES                 SUSPEND WAIT TIMES   EVENTS WAIT TIME/EVENT
   --------------------------------    -------------------------------   --------------------------------  ------- ---------------
   PACKAGE SECTION CNT          102    CL7 ELAPSED TIME   00:00.093951   LOCK                00:00.000000        0            N/P
     DBRMS                        0    CL7 CPU TIME       00:00.002428   LATCH               00:00.000000        0            N/P
     STORED PROCEDURES            0    CL7 SE CPU TIME    00:00.000000   SYNCHRONOUS I/O     00:00.001662        0       0.006759
     USER DEFINED FCNS            0                                      OTHER READ I/O      00:00.000150        0       0.023155
     TRIGGERS                     0    CL8 SUSPEND TIME   00:00.016049   OTHER WRITE I/O     00:00.000000        0            N/P
     NATIVE ST PROCS              0    NOT ACCOUNTED      00:00.075473   SERV TASK SWITCH    00:00.014237        1       0.016601
     NON-INLINE UDFS              0                                      ARCH LOG(QUIESCE)   00:00.000000        0            N/P
   TOTAL EXECUTIONS             309    CPU SERVICE UNITS         88.09   ARCHIVE LOG READ    00:00.000000        0            N/P
                                       SE CPU SERV UNITS          0.00   DRAIN LOCK          00:00.000000        0            N/P
   STOR PROCS CALLED              0                                      CLAIM RELEASE       00:00.000000        0            N/P
   UDFS SCHEDULED                 0                                      PAGE LATCH          00:00.000000        0            N/P
                                                                         NOTIFY MESSAGE      00:00.000000        0            N/P
   TOTAL SQL STMTS             1851    SQL STATEMENTS AVG            6   GLOBAL CONTENTION   00:00.000000        0            N/P
   TOTAL DB2 ENT/EXIT          1554    DB2 ENTRY/EXIT AVG            5   TCP/IP LOB          00:00.000000        0            N/P
   TOTAL SUCC AUTH CHK           98    SUCC AUTH CHK AVG             0   ALL CL8 SUSP TYPES  00:00.016049        1       0.014458


                       BACCTDR : ACCNTG SUMMARY, LONG                                   07/15/19 11:54:27    PAGE    10

        SYSTEM: DB2A                                    ACCOUNTING SUMMARY - LONG             INTERVAL FROM: 05/29/19 06:00:31
     SUBSYSTEM: DECD     REL: 12.1                                                                       TO: 06/17/19 07:45:38
     D/S GROUP:          MBR:                  Prime AuthID: CSTCXN                             ACTUAL FROM: 06/07/19 11:24:47.74
      LOCATION: DECD                              Plan Name: NGTTC11                                     TO: 06/07/19 11:43:36.55


   ---- ACCELERATOR ACTIVITY -----------------------------------------------------------------------------------------------------

   THREAD INFORMATION                          COUNTS:       AVERAGE         TOTAL      TIMES:             AVERAGE           TOTAL
   ---------------------------------------  --------------------------------------   ---------------------------------------------
   TOTAL THREADS             76             OCCURRENCES                          3   ELAPSED TIME
   ACCEL THREADS              3             CONNECTS            1.00             3    SVCS TCP/IP   0:00:00.003353  0:00:00.010059
   PCT ACCEL THREADS        3.9%            REQUESTS            0.00             0    ACCUM ACCEL   0:00:00.000000  0:00:00.000000
                                             TIMED OUT          0.00             0   CPU TIME
                                             FAILED             0.00             0    SVCS TCP/IP   0:00:00.001385  0:00:00.004154
                                             SENT                                      ACCUM ACCEL  0:00:00.000000  0:00:00.000000
                                              BYTES             0.00             0    WAIT TIME
                                              MESSAGES          0.00             0     ACCUM ACCEL  0:00:00.000000  0:00:00.000000
                                              BLOCKS            0.00             0
                                              ROWS              0.00             0    DB2 THREAD
                                             RECEIVED                                  CLASS 1
                                              BYTES             0.00             0      ELAPSED                N/A  0:00:08.977891
                                              MESSAGES          0.00             0      CP CPU                 N/A  0:00:00.014027
                                              BLOCKS            0.00             0      SE CPU                 N/A  0:00:00.000000
                                              ROWS              0.00             0     CLASS 2
                                                                                        ELAPSED                N/A  0:00:00.398360
                                                                                        CP CPU                 N/A  0:00:00.010141
                                                                                        SE CPU                 N/A  0:00:00.000000

 

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

BMC AMI Ops Monitor for Db2 13.1