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 (BSQTRCP)

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

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

1                       BSQTRCP : SQL SUMMARY TRC BY PGM                                 08/28/14 09:35:10    PAGE     5

    LOCATION: CHSKA000DP4G                                                                           DATA FROM: 08/26/2014 15:22:29
     D/S GRP: DSNDGR   MBR: DGR1                   SQL SUMMARY TRACE REPORT BY PGM/PKG                      TO: 08/26/2014 15:23:00
        SSID: DGR1     VER: 10.1
    PRIMAUTH: RDHJMB2              CONNECT: BATCH                 CORRNAME: PAY4DIVE                         CONNTYPE: TSO
    ORIGAUTH: RDHJMB               PLAN   : DSNTEP2               CORRID  : PAY4DIVE                         THRDTYPE: ALLIED
    ENDUSER : RDHJMB2              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
     NAME            COUNT  AVG ELAPSED  AVG TCBTIME                               DETAILS
    ============= ======== ============ ============ ===============================================================================
     N/A


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

                                                   SQL STATEMENT/EVENT        COUNT   AVG ELAPSED   AVG CPU TIME
                                                   ----------------------  --------  ------------   ------------
                                                   FETCH                        118  00:00.006382   00:00.002613
                                                   UPDATE                         2  00:00.004161   00:00.000320
                                                   PREPARE                        5  00:00.209462   00:00.043353
                                                   OPEN                           3  00:00.000014   00:00.000014
                                                   CLOSE                          3  00:00.000020   00:00.000020
                                                   DESC/COMMIT/ROLLBK/ERR        11           N/A            N/A  (IFCID 53)

1                       BSQTRCP : SQL SUMMARY TRC BY PGM                                 08/28/14 09:35:10    PAGE     6

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

    ACCT THRD START : 08/26/14 15:22:32.617   THRD END : 08/26/14 15:22:32.832   ELAPSED: 0.215273   TERM RSN: NORMAL DEALLOCATION

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


     DSNTIAUL            1 00:00.187169  00.005887 PKG:  CHSKA000DGR1    . DSNTX1            . DSNTIAUL          . 19421FA7017AB9F8
                           00:00.187168  00.005887

                                                   SQL STATEMENT/EVENT        COUNT   AVG ELAPSED   AVG CPU TIME
                                                   ----------------------  --------  ------------   ------------
                                                   FETCH                          1  00:00.166630   00:00.002235
                                                   PREPARE                        1  00:00.020061   00:00.003184
                                                   OPEN                           1  00:00.000013   00:00.000013
                                                   CLOSE                          1  00:00.000019   00:00.000018
                                                   DESC/COMMIT/ROLLBK/ERR         1           N/A            N/A  (IFCID 53)

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