Skip to Content
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 image-2024-5-19_8-5-1.png .

Thread SQL trace report by occurrence— event timestamp (BSQTRCT)

The following figure shows a sample of the thread SQL trace report by occurrence— event timestamp.

Warning

Note

This report is based on IFCIDs 3, 53, 55, 58-62, 64-66, 68-75, 84-89, 92, 97, 108-109, 174-175, 177, 183, 237, and 239.

1                       BSQTRCT : SQL SUMMARY TRC BY OCCURRENCE                          08/28/14 09:35:10    PAGE     2

    LOCATION: DGR                                                                                    DATA FROM: 08/26/2014 15:22:29
     D/S GRP: DSNDGR   MBR: DGR1                   SQL SUMMARY TRACE REPORT BY SQL STMT NMBR                TO: 08/26/2014 15:23:00
        SSID: DGR1     VER: 10.1
    PRIMAUTH: RDHJMB2              CONNECT: BATCH                 CORRNAME: PAY4DIVE                         CONNTYPE: TSO
    ORIGAUTH: RDHJMB               PLAN   : DSNBIND               CORRID  : PAY4DIVE                         THRDTYPE: ALLIED
    ENDUSER : RDHJMB2              WSNAME : BATCH                 TRXNAME : PAY4DIVE
    LUWID   : CHSKA000.DGR1.CDA987DC4C8E                          ACE ADDR: 1B81B970

    ACCT THRD START : 08/26/14 15:22:55.460   THRD END : 08/26/14 15:22:55.584   ELAPSED: 0.124181   TERM RSN: NORMAL DEALLOCATION

    EVENT/ NL-PROGRAM   TIMESTAMP ELAPSED TIM    TCB TIME       DETAILS
    ================= =========== =========== =========== ==========================================================================
     AUTOBIND         15:22:55.51 0:00.036081 0:00.001963 STMT#: N/A      OBJECT TYPE: PLAN          SQLSTATE: N/A   SQLCODE:     4
                                                                          BIND ACTION: ADD            REBIND*: N
                                                                     PLAN: TEST1                    QUALIFIER: DGR1SYS
                                                                    OWNER: DGR1SYS                   LOCATION:
                                                                  PACKAGE:                             COLLID:
                                                                ISOLATION: CS        VALIDAT: RUN       CURDATA: NO    EXPLAIN: N
                                                                BIND TYPE: BIND      LOCKOBT: USE      DDFPRTCL: D     DISCONN: E
                                                                    ONERR: 00        LOCKREL: COMMIT   SQLRULES: D     RTREOPT: N
                                                                 ENCODING: EBCDIC      CCSID: 01F4     IMMEDWRT: NO    KEEPDYN: N
                                                                DYNRULSOP: RUN       AUTHCSZ:   1024     DEGREE:   1   DEFERRP: N
                                                           OPTHINT:

1                       BSQTRCT : SQL SUMMARY TRC BY OCCURRENCE                          08/28/14 09:35:10    PAGE     3

    LOCATION: DGR                                                                                    DATA FROM: 08/26/2014 15:22:29
     D/S GRP: DSNDGR   MBR: DGR1                   SQL SUMMARY TRACE REPORT BY SQL STMT NMBR                TO: 08/26/2014 15:23:00
        SSID: DGR1     VER: 10.1
    PRIMAUTH: RDHJMB2              CONNECT: BATCH                 CORRNAME: PAY4DIVE                         CONNTYPE: TSO
    ORIGAUTH: RDHJMB               PLAN   : DSNBIND               CORRID  : PAY4DIVE                         THRDTYPE: ALLIED
    ENDUSER : RDHJMB2              WSNAME : BATCH                 TRXNAME : PAY4DIVE
    LUWID   : CHSKA000.DGR1.CDA987DC6AFF                          ACE ADDR: 1B81B970

    ACCT THRD START : 08/26/14 15:22:55.585   THRD END : 08/26/14 15:22:55.604   ELAPSED: 0.019318   TERM RSN: NORMAL DEALLOCATION

    EVENT/ NL-PROGRAM   TIMESTAMP ELAPSED TIM    TCB TIME       DETAILS
    ================= =========== =========== =========== ==========================================================================
     AUTOBIND         15:22:55.59 0:00.009263 0:00.001042 STMT#: N/A      OBJECT TYPE: PLAN          SQLSTATE: N/A   SQLCODE:     4
                                                                          BIND ACTION: REBIND         REBIND*: N
                                                                     PLAN: TEST1                    QUALIFIER: DGR1SYS
                                                                    OWNER: DGR1SYS                   LOCATION:
                                                                  PACKAGE:                             COLLID:
                                                                ISOLATION: CS        VALIDAT: RUN       CURDATA: NO    EXPLAIN: N
                                                                BIND TYPE: REBIND    LOCKOBT: USE      DDFPRTCL: D     DISCONN:
                                                                    ONERR: 00        LOCKREL: COMMIT   SQLRULES:       RTREOPT: N
                                                                 ENCODING: EBCDIC      CCSID: 01F4     IMMEDWRT: NO    KEEPDYN: N
                                                                DYNRULSOP: RUN       AUTHCSZ:   1024     DEGREE:   1   DEFERRP: N
                                                           OPTHINT:

Related topic

SQL-activity-reports

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 12.2