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— with workloads (BSQTRCTW)

The following figure shows a sample of the thread SQL trace report by occurrence— event timestamp— with workloads (BSQTRCTW).

Warning

Note

This report is based on IFCIDs 3, 6-12, 17-20, 22, 44, 45, 53, 55, 58-62, 64-66, 68-75, 84-89, 92, 95-97, 108, 109, 125, 174, 175, 177, 183, 188, 213-216, 218, 221, 226, 227, 233, 237, 239, 247, 305, and 324.

1                       BSQTRCTW: SQL SUMMARY TRC BY OCCUR W/WKL                         12/12/14 10:05:46    PAGE 12725

    LOCATION: DGR                                                                                    DATA FROM: 05/28/2013 14:03:07
     D/S GRP: DSNDGR   MBR: DGR1                   SQL SUMMARY TRACE REPORT BY SQL STMT NMBR                TO: 08/15/2013 16:26:42
        SSID: DGR1     VER: 10.1
    PRIMAUTH: SYSOPR               CONNECT: DGR1                  CORRNAME: 021.OPNL                         CONNTYPE:
    ORIGAUTH: SYSOPR               PLAN   :                       CORRID  : 021.OPNLGR00                     THRDTYPE: ALLIED
    ENDUSER :                      WSNAME :                       TRXNAME :
    LUWID   : USBMCN01.DGR1LU.CBD143E6CC63                        ACE ADDR: 257DD470

    ACCT THRD START :      N/P          N/P   THRD END :      N/P          N/P   ELAPSED: 0.000000   TERM RSN:                  N/P

    EVENT/ NL-PROGRAM   TIMESTAMP ELAPSED TIM    TCB TIME       DETAILS
    ================= =========== =========== =========== ==========================================================================
     SUSPEND/LOCK     16:26:04.91 0:00.000059 0:00.000012 STMT#: N/A   SUSPEND REASON: 09            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     READ I/O         16:26:04.91 0:00.000212 0:00.000040 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0087  PART:    0   PAGE#: 00000087  TSTYPE: N

     SUSPEND/LOCK     16:26:04.91 0:00.000062 0:00.000020 STMT#: N/A   SUSPEND REASON: 08            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     READ I/O         16:26:04.91 0:00.000209 0:00.000032 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0086  PART:    0   PAGE#: 00000002  TSTYPE: N

     READ I/O         16:26:04.91 0:00.000194 0:00.000030 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0086  PART:    0   PAGE#: 0000010A  TSTYPE: N

     READ I/O         16:26:04.91 0:00.005799 0:00.000028 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0086  PART:    0   PAGE#: 00000120  TSTYPE: N

     READ I/O         16:26:04.92 0:00.009901 0:00.000034 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0086  PART:    0   PAGE#: 0000009E  TSTYPE: N

     SUSPEND/LOCK     16:26:04.93 0:00.003834 0:00.000021 STMT#: N/A   SUSPEND REASON: 08            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     SUSPEND/LOCK     16:26:04.93 0:00.000046 0:00.000021 STMT#: N/A   SUSPEND REASON: 08            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     SUSPEND/LOCK     16:26:04.93 0:00.008225 0:00.000024 STMT#: N/A   SUSPEND REASON: 08            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     SUSPEND/LOCK     16:26:04.94 0:00.018347 0:00.000027 STMT#: N/A   SUSPEND REASON: 08            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     SUSPEND/LOCK     16:26:04.96 0:00.000102 0:00.000035 STMT#: N/A   SUSPEND REASON: 09            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     SUSPEND/LOCK     16:26:04.96 0:00.000093 0:00.000016 STMT#: N/A   SUSPEND REASON: 09            RSN CODE: N/A   RETCODE: N/A
                                                                       RESUME  REASON: NORMAL

     READ I/O         16:26:04.96 0:00.000199 0:00.000033 STMT#: N/A  READ TYPE: R      BPID:   0    RSN CODE: N/A   RETCODE:     0
                                                                DBID: 0001  PSID: 0086  PART:    0   PAGE#: 00000120  TSTYPE: N

1                       BSQTRCTW: SQL SUMMARY TRC BY OCCUR W/WKL                         12/12/14 10:05:46    PAGE 12726

    LOCATION: DGR                                                                                    DATA FROM: 05/28/2013 14:03:07
     D/S GRP: DSNDGR   MBR: DGR1                   SQL SUMMARY TRACE REPORT BY SQL STMT NMBR                TO: 08/15/2013 16:26:42
        SSID: DGR1     VER: 10.1
    PRIMAUTH: SYSOPR               CONNECT: DGR1                  CORRNAME: 021.OPNL                         CONNTYPE:
    ORIGAUTH: SYSOPR               PLAN   :                       CORRID  : 021.OPNLGR00                     THRDTYPE: ALLIED
    ENDUSER :                      WSNAME :                       TRXNAME :
    LUWID   : USBMCN01.DGR1LU.CBD143E6CC63                        ACE ADDR: 257DD470

    ACCT THRD START :      N/P          N/P   THRD END :      N/P          N/P   ELAPSED: 0.000000   TERM RSN:                  N/P

    EVENT/ NL-PROGRAM   TIMESTAMP ELAPSED TIM    TCB TIME       DETAILS
    ================= =========== =========== =========== ==========================================================================
                      --- PAGE/ROW/LOB/XML LOCKING ---------------------------------------------------------------------------
                         SUMMARY: MAX LOCKS HELD:        1    SHARED ESCALATIONS:        0     EXCLUSIVE ESCALATIONS:        0

                           TOTAL    PAGE    ROWE     LOB     XML     MAX LOCKS  # LOCK  HIGHEST      LOCK AVOID
                           LOCKS   LOCKS   LOCKS   LOCKS   LOCKS  HELD PER THD   ESCAL     LOCK      SUCCESSFUL
                         ------- ------- ------- ------- -------  ------------  ------  -------      ----------
                               1       0       1       0       0             1       0     IX                 0

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