Skip to Content

Default language.

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).

Related topic

SQL-activity-reports


Warning

Important

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

 

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

BMC AMI Ops Monitor for Db2 13.1