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 .

SQL long trace report (BSQLLT)

The following figure shows a sample of the SQL long trace report (BSQLLT).

Warning

Note

This report is based on IFCIDs 6-12, 15-20, 22, 44, 45, 53, 55, 58-66, 68-75, 86-89, 95, 96, and 125.

1                       BSQLLT  : SQL LONG TRACE                                         12/12/14 09:44:40    PAGE     1

   GROUP :                                                  SQL LONG TRACE                           DB2 SUBSYSTEM: DEEF 10.1
   MEMBER:                                                                                                LOCATION: DEEF
       CREATE THREAD END TIME:      N/P             N/P
       CONNECT   : DEEF       CORRELATION: 010.COMCMA01       PRIMAUTH: SYSOPR      ORIGAUTH: SYSOPR    PLAN NAME:
                              REQUESTER  :                    LUWID   : DEEF.DEEFLU01.CB6953386578            ACE: 3D4E71A0
   START TIME    EVENT
   ------------  ----------------------  -------------------------------------------------------------------------------------------
 + 12:22:10.739  BGN ASYNC WRITE I/O     DBID/OBID: 0105     0066       WRITE TYPE: W     NBR OF PAGES TO WRITE :        1
 +                                       DBID/OBID: PMDDB4K .TSPG1                        POOL                  :         25
 + 12:22:10.746  END WRITE I/O                                           RC:        0     ELAPSED               :   0.006052
 + 12:22:10.750  BGN ASYNC WRITE I/O     DBID/OBID: 0105     0066       WRITE TYPE: W     NBR OF PAGES TO WRITE :        1
 +                                       DBID/OBID: PMDDB4K .TSPG1                        POOL                  :         25
 + 12:22:10.755  END WRITE I/O                                           RC:        0     ELAPSED               :   0.005396
1                       BSQLLT  : SQL LONG TRACE                                         12/12/14 09:44:40    PAGE     2

   GROUP :                                                  SQL LONG TRACE                           DB2 SUBSYSTEM: DEEF 10.1
   MEMBER:                                                                                                LOCATION: DEEF
       CREATE THREAD END TIME:      N/P             N/P
       CONNECT   : DEEF       CORRELATION: 010.LPFRAP01       PRIMAUTH: SYSOPR      ORIGAUTH: SYSOPR    PLAN NAME:
                              REQUESTER  :                    LUWID   : DEEF.DEEFLU01.CB695338E473            ACE: 3A30B160
   START TIME    EVENT
   ------------  ----------------------  -------------------------------------------------------------------------------------------
 + 14:11:42.259  BGN READ I/O            DBID/OBID: 010E     001B        READ TYPE: D     1ST PAGE READ         : 00046F
 +                                       DBID/OBID: DEEFD04 .DMRQACCX                     ELAPSED               :   0.028687
 + 14:11:42.288  END READ I/O            DBID/OBID: 010E     001B                         NBR OF PAGES READ     :        0
 +                                       DBID/OBID: DEEFD04 .DMRQACCX                     RETURN CODE           :          0
1                       BSQLLT  : SQL LONG TRACE                                         12/12/14 09:44:40    PAGE   662

   GROUP : DSNDGR                                           SQL LONG TRACE                           DB2 SUBSYSTEM: DGR1 10.1
   MEMBER: DGR1                                                                                           LOCATION: DGR
       CREATE THREAD END TIME:      N/P             N/P
       CONNECT   : DGR1       CORRELATION: 003.RTIMR 05       PRIMAUTH: SYSOPR      ORIGAUTH: SYSOPR    PLAN NAME:
                              REQUESTER  :                    LUWID   : DSNDGR.DGR1LU.CBCA325A28F5            ACE: 3BF7E450
   START TIME    EVENT
   ------------  ----------------------  -------------------------------------------------------------------------------------------
 + 16:20:53.056  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:20:54.057  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:20:54.058  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:06.267  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:06.267  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:07.269  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:07.269  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:08.270  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:08.270  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:09.270  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:09.270  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:10.271  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:10.272  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:11.272  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:11.274  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO
 + 16:21:12.275  LOCK SUSPEND            IRLM FUNC: LOCK              STATE: X            REASON  : INTER-SYSTEM COMM
                                         LOCK FLAG: Y N         P-LOCK FLAG: L-LOCK
 +                                       RESOURCE :28C3    .D6D4    .FF  .D4C9E36D00      DURATION: MANUAL
 + 16:21:12.276  LOCK RESUME             REASON   : NORMAL
                             SUSPEND REASON(S): N      Y N     , N      Y N     , N      Y N     , N      Y N     , N      Y N
                             GLOBAL CONTENTION: N      Y N      , N      ENTER STO

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