SQL Activity Report Header
This is an example of the SQL Activity report header.
SUMMARIZED BY PROGRAM
PRIMAUTH: SUDB101 PLANNAME: DISTSERV THREAD TOTAL: 1 START AET: N/P STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- ---------------------------------------------------------------
SYSSTAT 1 0.124457 PACKAGE: MOPDBB0.NULLID.SYSSTAT.X'5359534C564C3031'
0.124457 ACQUIRE(USE) REOPT(N) RELEASE(COMMIT) ISO(CS) DYNAMICRULES(RUN)
PREPARE(NODEFER) KEEPDYNAMIC(NO) PROTOCOL(DRDA) OPTHINT(N/P)
STMTTYPE COUNT AET/OCCUR TCB/OCCUR
CALL 1 0.124457
PACKAGE_TOUR_OFFER 1 0.078445 PACKAGE: MOPDBB0.OTR.PACKAGE_TOUR_OFFER.X'1984ABC311D26448'
0.078445 V1
ACQUIRE(USE) REOPT(N) RELEASE(COMMIT) ISO(UR) DYNAMICRULES(RUN)
PREPARE(NODEFER) KEEPDYNAMIC(NO) PROTOCOL(DRDA) OPTHINT(N/P)
STMTTYPE COUNT AET/OCCUR TCB/OCCUR
CALL 12 0.006525
NESTED CLASS 1 CP TIME : 0.011011 NESTED CLASS 2 CP TIME: 0.002011
NESTED CLASS 1 SE TIME : 0.011011 NESTED CLASS 2 SE TIME: 0.002011
NESTED CLASS 1 EL TIME : 0.051111 NESTED CLASS 2 EL TIME: 0.030044
SELECT 5 0.000028