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
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*