Sample reports

  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