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 summary report by PGM/PKG and statement number (BSQTRCS)

The following figure shows a sample of the thread SQL trace summary report by PGM/PKG and statement number (BSQTRCS).

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                       BSQTRCS : SQL SUMMARY TRC BY STMT                                08/28/14 09:35:10    PAGE     5

    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: RDGHJMB2             CONNECT: BATCH                 CORRNAME: PAY4DIVE                         CONNTYPE: TSO
    ORIGAUTH: RDHJMB               PLAN   : DSNTEP2               CORRID  : PAY4DIVE                         THRDTYPE: ALLIED
    ENDUSER : RDGHJMB2             WSNAME : BATCH                 TRXNAME : PAY4DIVE
    LUWID   : CHSKA000.DGR1.CDA987DC806D                          ACE ADDR: 1B81B970

    ACCT THRD START : 08/26/14 15:22:55.673   THRD END : 08/26/14 15:23:00.407   ELAPSED: 4.734596   TERM RSN: NORMAL DEALLOCATION

    PACKAGE/PGM             TOT ELAPSED  TOT TCBTIME
     STMT NMBR       COUNT  AVG ELAPSED  AVG TCBTIME                               DETAILS
    ============= ======== ============ ============ ===============================================================================
     N/A


     DSNTEP2             1 00:01.816816  00.528263 PKG:  PKG0DSNDGR      . DSNTX1            . DSNTEP2           . 199E82CF194C3976
                           00:01.816816  00.528263

          1456           1          N/P          N/P DESC/COMMIT/ROLLBK/ERR (IFCID 53) NMBR RC NZ:        0

          1898           5 00:01.047308 00:00.216765 PREPARE  NMBR RC NZ:        0    CURSOR: C1
                           00:00.209462 00:00.043353

          1959           5          N/P          N/P DESC/COMMIT/ROLLBK/ERR (IFCID 53) NMBR RC NZ:        0

          1986           2 00:00.008322 00:00.000640 UPDATE   NMBR RC NZ:        0    ISOLATION RR:       0 CS:       2           2
                           00:00.004161 00:00.000320          REOPTIMIZD:        0              RS:       0                       2

          2029           3 00:00.000043 00:00.000042 OPEN     NMBR RC NZ:        0      SENSITIVE:       0   INSENSITIVE:       0
                           00:00.000014 00:00.000014                         ISOLATION RR:       0   CS:       3   RR-XL:       0
                                                                                       RS:       0   UR:       0   RS-XL:       0

          2064         118 00:00.753111 00:00.308296 FETCH    NMBR RC NZ:        3    SENSITIVE  :       0   INSENSITIVE:       0
                           00:00.006382 00:00.002613

          2140           1          N/P          N/P DESC/COMMIT/ROLLBK/ERR (IFCID 53) NMBR RC NZ:        0

          2375           3 00:00.000060 00:00.000060 CLOSE    NMBR RC NZ:        0       IMPLICIT:       0      EXPLICIT:       3
                           00:00.000020 00:00.000020

          5607           2          N/P          N/P DESC/COMMIT/ROLLBK/ERR (IFCID 53) NMBR RC NZ:        0

          5609           2          N/P          N/P DESC/COMMIT/ROLLBK/ERR (IFCID 53) NMBR RC NZ:        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