Previous Topic: DB2 Reports

Next Topic: ERXT0331/EZXT0331:  DB2 Report Microsecond Times

ERXT0103/EZXT0103: DB2 Report

This report provides detailed information on DB2 usage.

01/03/yy                                                     DB2 REPORT                                                 PAGE 1 REPORT ID: ERXT0103 ---------------------------------------------------------------------------------------------------------------------------------- AUTH        CONNECT     CONNECT    PLAN        SUBSYS    TOTAL SQL            OPEN           CLOSE              DB2          DB2 ID             DATE        TIME    NAME        ID          ACTIONS           COUNT           COUNT              TCB          SRB ---------------------------------------------------------------------------------------------------------------------------------- CHARLIE       yy/01/14   18:03:47    CBASE11     D230            508             155             155            45.88        0.96 CHARLIE       yy/01/14    14:23:14    CBASE11     D230           382             105             105            26.44        0.52 CICSCAS       yy/01/14    08:24:26    CASDMENU    DB2              2               2               1             0.00        0.00 CICSCAS       yy/01/14    08:24:29    CSSPSECR    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:24:30    CASDIPLV    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:24:32    CBMDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:24:45    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:04    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:04    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:04    CBMDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:15    CBMDISPM    DB2             49              49              49             0.17        0.00 CICSCAS       yy/01/14    08:25:28    CBMDISPM    DB2             48              49              49             0.13        0.00 CICSCAS       yy/01/14    08:25:33    CBMDISPM    DB2             48              37              37             0.05        0.00 CICSCAS       yy/01/14    08:25:34    CBMDISPM    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:34    CBMDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:25:39    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:37:11    CASDMENU    DB2              2               2               1             0.00        0.00 CICSCAS       yy/01/14    08:37:11    CSSPSECR    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:41:47    CSSPSECR    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:41:47    CASDMENU    DB2              2               2               1             0.00        0.00 CICSCAS       yy/01/14    08:41:47    CASDIPLV    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:41:47    CBMDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:41:54    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:42:01    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:42:01    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:42:01    CBMDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:42:43    CBMDISPM    DB2             49              49              49             0.15        0.00 CICSCAS       yy/01/14    08:42:49    CASDMENU    DB2              2               2               1             0.00        0.00 CICSCAS       yy/01/14    08:42:49    CSSPSECR    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:42:57    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:43:05    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:43:05    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:43:05    CSSPSECR    DB2              3               3               3             0.00        0.00 CICSCAS       yy/01/14    08:43:08    CMPDPREP    DB2              4               0               0             0.01        0.00 CICSCAS       yy/01/14    08:43:11    CMRDPREP    DB2              3               0               0             0.00        0.00 CICSCAS       yy/01/14    08:43:13    CMRDUMSP    DB2              3               0               0             0.00        0.00 CICSCAS       yy/01/14    08:43:37    CBMDISPM    DB2             48              49              49             0.13        0.00 CICSCAS       yy/01/14    08:47:01    CBMDISPM    DB2             48              37              37             0.05        0.37 CICSCAS       yy/01/14    08:49:47    CMRDUMSP    DB2              3               1               0             0.00        0.00 CICSCAS       yy/01/14    08:53:10    CASDMENU    DB2              2               1               0             0.00        0.00 CICSCAS       yy/01/14    08:53:10    CSSPSECR    DB2              2               2               2             0.00        0.00 CICSCAS       yy/01/14    08:53:10    CASDIPLV    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:11    CICDPREP    DB2              3               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:21    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:21    CSSPSECR    DB2              3               2               2             0.00        0.00 CICSCAS       yy/01/14    08:53:21    CASDMENU    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:22    CICDPREP    DB2              3               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:22    CASDIPLV    DB2              1               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:22    CICDPREP    DB2              2               0               0             0.00        0.00 CICSCAS       yy/01/14    08:53:22    CICDUISP    DB2              2               3               3             0.02        0.00 CICSCAS       yy/01/14    08:53:35    CICDUISP    DB2              3               4               4             0.02        0.00 CICSCAS       yy/01/14    08:53:42    CICDUISP    DB2              4               0               0             0.01        0.00 CICSCAS       yy/01/14    08:53:43    CICDUIDP    DB2              0               1               1             0.01        0.00