A sample report is shown here:
File View Navigate Help -------------------------------------------------------------------------------- F06: DB2 SQL Statement Attributes (1623/CICS23A) Row 00001 of 00324 Command ===> __________________________________________________ Scroll ===> CSR SQL Statement Id 00001 Subsystem name DSN1 Attach type SASS Plan name PFSAMPA Plan BIND time Nov-28-04 14:11:17 DBRM name PSSAMPA DBRM token 17859595 050DCBBC DBRM date/time Nov-25-04 14:50:15 Package ID PFSAMPA Location CABNETDB24 Collectn name PFSAMPX1 Pkg BIND time no data SQL function SELECT Static/dynamic Static Precmplr stmt# 816 DBRM section# 1 CSECT/module PFSAMPA in PFSAMPA Offset of call 000007FA Sample count 324 SQL req count 342 SQL CPU time 0.91 Service time 1.72 SQL Statement: SELECT NEXTLIM INTO : H FROM MRATE WHERE CURATE = : H SQL Statement Id 00002 Subsystem name DSN1 Attach type SASS Plan name PFSAMPA Plan BIND time Nov-28-04 14:11:17 DBRM name PFSAMPC DBRM token 17859595 06957A24 DBRM date/time Nov-25-04 14:49:42 Package ID PFSAMPC Location CABNETDB24 Collectn name PFSAMPX1 Pkg BIND time no data SQL function SELECT Static/dynamic Static Precmplr stmt# 1316 DBRM section# 6
[ Top of Page | Previous Page | Next Page | Contents | Index ]