Information
Limited support BMC 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 
.
.
Summary SQL report by PGM/PKG (BSQSUMP)
The following figure shows a sample of the summary SQL report by PGM/PKG (BSQSUMP).
1
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 12
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB2
PLAN NAME DMRSEL01 THREAD COUNT: 1
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
DMRCAT4 1 00:00.712820 00.006340 PKG: DGR . DMRQA . DMRCAT4 . 196C9FA40073F045
00:00.712820 00.006340
ACQUIRE: U REOPT: NOREOP RELEASE: C DYNAMICRULES: RUN
PREPARE: N ISO: CS PROTOCOL: D KEEPDYNAMIC: N
IMMEDWRT: NO OPTHINT:
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
FETCH 6 00:00.117883 00:00.000464
OPEN 3 00:00.000072 00:00.000066
CLOSE 3 00:00.000141 00:00.000067
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 13
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB3
PLAN NAME BLANK THREAD COUNT: N/P
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
N/A
EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
SIGNON 4 00:00.009411 00:00.001278
N/A
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 14
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB3
PLAN NAME DGRRRS01 THREAD COUNT: 1
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
N/A
EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
CREATE THREAD 1 00:00.000384 00:00.000381
ROLLBACK 1 00:00.000272 00:00.000120
TERMINATE 1 00:00.328342 00:00.000482
DFHRRS02
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
DESC/COMMIT/ROLLBK/ERR 5 N/A N/A (IFCID 53)
DGRRRS01 1 00:00.029301 00.004458 PKG: DGR . DGRRRS0 . DGRRRS01 . 196CEE740CA11731
00:00.029301 00.004457
ACQUIRE: U REOPT: NOREOP RELEASE: C DYNAMICRULES: RUN
PREPARE: N ISO: CS PROTOCOL: D KEEPDYNAMIC: N
IMMEDWRT: NO OPTHINT:
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
DESC/COMMIT/ROLLBK/ERR 2 N/A N/A (IFCID 53)
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 12
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB2
PLAN NAME DMRSEL01 THREAD COUNT: 1
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
DMRCAT4 1 00:00.712820 00.006340 PKG: DGR . DMRQA . DMRCAT4 . 196C9FA40073F045
00:00.712820 00.006340
ACQUIRE: U REOPT: NOREOP RELEASE: C DYNAMICRULES: RUN
PREPARE: N ISO: CS PROTOCOL: D KEEPDYNAMIC: N
IMMEDWRT: NO OPTHINT:
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
FETCH 6 00:00.117883 00:00.000464
OPEN 3 00:00.000072 00:00.000066
CLOSE 3 00:00.000141 00:00.000067
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 13
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB3
PLAN NAME BLANK THREAD COUNT: N/P
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
N/A
EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
SIGNON 4 00:00.009411 00:00.001278
N/A
1 BSQSUMP : SQL SUMMARY RPT BY PGM 11/04/14 12:40:32 PAGE 14
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GRP: DSNDGR MBR: DGR1 SQL SUMMARY REPORT BY PGM/PKG TO: 08/15/2013 16:26:42
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB3
PLAN NAME DGRRRS01 THREAD COUNT: 1
PACKAGE/PGM TOT ELAPSED TOT TCBTIME
NAME COUNT AVG ELAPSED AVG TCBTIME DETAILS
============= ======== ============ ============ ===============================================================================
N/A
EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
CREATE THREAD 1 00:00.000384 00:00.000381
ROLLBACK 1 00:00.000272 00:00.000120
TERMINATE 1 00:00.328342 00:00.000482
DFHRRS02
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
DESC/COMMIT/ROLLBK/ERR 5 N/A N/A (IFCID 53)
DGRRRS01 1 00:00.029301 00.004458 PKG: DGR . DGRRRS0 . DGRRRS01 . 196CEE740CA11731
00:00.029301 00.004457
ACQUIRE: U REOPT: NOREOP RELEASE: C DYNAMICRULES: RUN
PREPARE: N ISO: CS PROTOCOL: D KEEPDYNAMIC: N
IMMEDWRT: NO OPTHINT:
SQL STATEMENT/EVENT COUNT AVG ELAPSED AVG CPU TIME
---------------------- -------- ------------ ------------
DESC/COMMIT/ROLLBK/ERR 2 N/A N/A (IFCID 53)
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*