Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Accounting summary package—short report (BACCTSRP)


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

1                       BACCTSRP: ACCNTG SUMMARY, SHORT/PKG                              04/01/15 13:51:56    PAGE     1


      LOCATION: DEHP                              ACCOUNTING SUMMARY - SHORT/PACKAGE           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)  GETPAGE   SYNC RD   SUSPENDS
           Plan Name      #DISTRS  COMMIT   FETCH    OPEN   CLOSE PREPARE  CPU    (CL1)  CPU    (CL2)  BUF UPDT  PREFETCH  LOCKOUTS
    -------------------  --------  ------ ------- ------- ------- -------  ------------  ------------  --------  --------  --------
    BMCADM                     29       0    0.00    0.00    0.00    0.00  11:30:01.640  00:27.276999      0.00      0.00       N/P
    BMCMVDB2                    0      28    0.00    0.00    0.00    0.00  00:10.349394  00:04.780746      0.00      0.00         0

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

      *---------------------------------------------------------------------------------------------------------------------------*
      * PROGRAM NAME        TYPE        #OCCURS   #ALLOCS    AVG SQL  AVG CL7 ELAPS   AVG CL7 CPU  AVG CL8 SUSP.TIM  AVG CL8 SUSP *
      * 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      0.00      0.00       N/P
    BLANK                       0       0    0.00    0.00    0.00    0.00  00:00.008557  00:00.007388      0.00      0.00         0

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

      *---------------------------------------------------------------------------------------------------------------------------*
      * PROGRAM NAME        TYPE        #OCCURS   #ALLOCS    AVG SQL  AVG CL7 ELAPS   AVG CL7 CPU  AVG CL8 SUSP.TIM  AVG CL8 SUSP *
      * 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     37.00     12.00       N/P
    DISTSERV                    1       0    0.00    0.00    0.00    1.00  00:00.007131  00:00.005937      0.00      1.00         0

      *---------------------------------------------------------------------------------------------------------------------------*
      * PROGRAM NAME        TYPE        #OCCURS   #ALLOCS    AVG SQL  AVG CL7 ELAPS   AVG CL7 CPU  AVG CL8 SUSP.TIM  AVG CL8 SUSP *
      * SYSLH200            Package           1         1       3.00   00:00.008121  00:00.001637      00:00.043192          2.00 *
      *---------------------------------------------------------------------------------------------------------------------------*

      *------------------------------------------------------------------------------------------------------*
      *  LOCATION          TYPE       METH   #OCCUR    TRANS   ROLLBK   COMMIT   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     72.38      0.74       N/P
    BMIINSTL                    0     189    0.00    0.00    0.00    0.00  00:00.004974  00:00.001902     12.00      0.48         0

      *---------------------------------------------------------------------------------------------------------------------------*
      * PROGRAM NAME        TYPE        #OCCURS   #ALLOCS    AVG SQL  AVG CL7 ELAPS   AVG CL7 CPU  AVG CL8 SUSP.TIM  AVG CL8 SUSP *
      * AINSQLIO            Package           6         6      72.33   00:05.761126  00:00.027078      00:00.057857         15.33 *
      *---------------------------------------------------------------------------------------------------------------------------*

    RCDHLK2                     5       4    0.00    0.00    0.00    0.00  00:13.729477  00:00.005898      2.00      0.80       N/P
    DAA111QA                    0       5    0.00    0.00    0.00    0.00  00:00.056234  00:00.001036      0.00      0.00         0

    RCDHLK2                   747       0    0.00    0.00    0.00    0.00  00:00.036218  00:00.036209    683.59      6.22       N/P
    DSNBIND                     0    1481    0.00    0.00    0.00    0.00  00:00.019520  00:00.019512    234.81      4.06         0

Related topic

 

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