Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Accounting summary load—short report (BACCTSRD)


The following figure shows a sample of the Accounting summary load—short report (BACCTSRD).

1                       BACCTSRD: ACCNTG SUMMARY, SHORT,LOAD                             04/01/15 13:57:40    PAGE     1


      LOCATION: DEHP                                   ACCOUNTING SUMMARY - SHORT              REQUESTED FROM: 03/19/15 22:15:09
     D/S GROUP:          MBR:                                                                              TO: 04/01/15 13:49:53
     SUBSYSTEM: DEHP     REL: 11.1                      ORDER:     Prime AuthID                     DATA FROM: 03/19/15 22:15:09.26
                                                                      Plan Name                            TO: 04/01/15 13:49:53.02

        Prime AuthID          # OCCUR        ROLLBK       SELECT       INSERT       UPDATE       DELETE  ELAPSED(CL1)  ELAPSED(CL2)
           Plan Name          #DISTRS        COMMIT        FETCH         OPEN        CLOSE      PREPARE  CPU    (CL1)  CPU    (CL2)
                              GETPAGE       SYNC RD     SUSPENDS     BUF UPDT     PREFETCH     LOCKOUTS
    ===================  ============  ============ ============ ============ ============ ============  ============  ============
    BMCADM                         29             0         0.00         0.00         0.00         0.00  11:30:01.640  00:27.276999
    BMCMVDB2                        0            28         0.00         0.00         0.00         0.00  00:10.349394  00:04.780746
                                 0.00          0.00          N/P         0.00         0.00            0

    BMCDB2                          2             1         0.00         0.00      2564.00         0.00  4 04:07:23.8  00:08.186124
    ?RRSAF                          0          5101      2564.00      2564.00      2564.00         0.00  00:08.895718  00:03.437424
                             15318.50         25.50          N/P         0.00         0.50            0

      *----------------------------------------------------------------------------------------------------------------------------*
      *                                                                     -------- CLASS 7 ---------  --------- CLASS 8 -------- *
      * PROGRAM NAME       TYPE          #OCCURS      #ALLOCS      AVG SQL   AVG ELAPSED       AVG CPU  AVG SUSP.TIM  AVG SUSP.CNT *
      * DSNA6DB2           Package             1            1     20512.00  00:15.616867  00:06.871454  00:00.302383         55.00 *
      *----------------------------------------------------------------------------------------------------------------------------*

    CSTCXN                         22             0         0.00         0.00         0.00         0.00  1 17:19:05.5  00:00.045142
    BLANK                           0             0         0.00         0.00         0.00         0.00  00:00.008557  00:00.007388
                                 0.00          0.00          N/P         0.00         0.00            0

    DMRQA                           3             0         0.00         0.00         0.00         0.00  00:02.453754  00:02.363391
    BMIINSTL                        0            12         0.00         0.00         0.00         0.00  00:00.084727  00:00.072625
                              2280.33         90.33          N/P       627.33         8.67            0

      *----------------------------------------------------------------------------------------------------------------------------*
      *                                                                     -------- CLASS 7 ---------  --------- CLASS 8 -------- *
      * PROGRAM NAME       TYPE          #OCCURS      #ALLOCS      AVG SQL   AVG ELAPSED       AVG CPU  AVG SUSP.TIM  AVG SUSP.CNT *
      * AINSQLIO           Package             3            3        78.67  00:02.362993  00:00.072363  00:02.285321        224.00 *
      *----------------------------------------------------------------------------------------------------------------------------*

    DMRQA01                         1             1         0.00         0.00         0.00         0.00  00:01.723825  00:00.355502
    DISTSERV                        1             0         0.00         0.00         0.00         1.00  00:00.007131  00:00.005937
                                37.00         12.00          N/P         0.00         1.00            0

      *----------------------------------------------------------------------------------------------------------------------------*
      *                                                                     -------- CLASS 7 ---------  --------- CLASS 8 -------- *
      * PROGRAM NAME       TYPE          #OCCURS      #ALLOCS      AVG SQL   AVG ELAPSED       AVG CPU  AVG SUSP.TIM  AVG SUSP.CNT *
      * SYSLH200           Package             1            1         3.00  00:00.008121  00:00.001637  00:00.043192          2.00 *
      *----------------------------------------------------------------------------------------------------------------------------*

      *----------------------------------------------------------------------------------------------------------------------------*
      * LOCATION         TYPE      METH       #OCCUR        TRANS      ROLLBKS      COMMITS      AVG SQL     AVG ROWS     AVG CONV *
      * ::FFFF:172.24.48 SERVER    DRDA            1            0            0            0         0.00         0.00         0.00 *
      *----------------------------------------------------------------------------------------------------------------------------*

    RCDHLK2                        89             0         0.00         0.00         0.00         0.00  00:00.398576  00:00.388550
    BMIINSTL                        0           189         0.00         0.00         0.00         0.00  00:00.004974  00:00.001902
                                72.38          0.74          N/P        12.00         0.48            0

Related topic


 

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