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

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

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, 237, 239, 247, 305, and 324.


 1                       BSQTRCSW: SQL SUMMARY TRC BY STMT  W/WKL                         08/28/14 09:35:10    PAGE     2

    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: RDHJMB2              CONNECT: BATCH                 CORRNAME: Y4PRDIVE                         CONNTYPE: TSO
    ORIGAUTH: RDHJMB               PLAN   : DSNBIND               CORRID  : Y4PRDIVE                         THRDTYPE: ALLIED
    ENDUSER : RDHJMB2              WSNAME : BATCH                 TRXNAME : Y4PRDIVE
    LUWID   : CHSKA000.DGR1.CDA987DC4C8E                          ACE ADDR: 1B81B970

    ACCT THRD START : 08/26/14 15:22:55.460   THRD END : 08/26/14 15:22:55.584   ELAPSED: 0.124181   TERM RSN: NORMAL DEALLOCATION

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

                      --- WORKLOAD HILITES -----------------------------------------------------------------------------------------
                      SCANS   :      9   IO REQS :        3  SUSPENDS  :       79  EXIT CALLS :        0  AMS CALLS     :        0
                      ROWSPROC:      3   IO AVELA: 0.004336  SUSP AVELA:        0  EXIT AVELAP:      N/P  AMS AVGELAPSED:      N/P
                      PAGSSCAN:     16                       DATACAPTUR: NO        CHKCONSTOK :        0  CHKCONSTREJECT:        0

                      --- I/O ACTIVITY --------------------------------------------------------------------------------------------
                       --IO REQUESTS--  --------READ REQUESTS (WITH OR WITHOUT I/O)------  -------------WRITE REQUESTS-------------
                         TOTAL AVGELAP    TOTAL  TYPE  AVGIOELAP     %IO PAGES/IO   %NOIO     TOTAL TYPE  CAST% AVGIOELAP PAGES/WRT
                       ------- -------  -------  ----  ---------  ------ --------  ------   ------- ---- ------ --------- ---------
                             3 00.0043        3  SYNC    00.0043  100.00     1.00    0.00         0 ASYN    N/P       N/P       N/P

                      --- LOCK SUSPENSION ACTIVITY --------------------------------------------------------------------------
                                     --------- SUSPEND REASON ----------  NORMAL RESUME    TIMEOUT RESUME   DEADLCK RESUME
                       TYPE             LOCAL LATCH IRLMQ GROUP NOTIF OTHER  COUNT AVGELAPS   COUNT AVGELAPS   COUNT AVGELAPS
                       -----------      ----- ----- ----- ----- ----- -----  ----- --------   ----- --------   ----- --------
                       NORMAL LOCK          0     0     0    79     0    20      0      N/P       0      N/P       0      N/P
                       DRAIN                0     0     0     0     0     0      0      N/P       0      N/P       0      N/P

                      --- PAGE/ROW/LOB/XML LOCKING -------------------------------------------------------------------------
                       SUMMARY: MAX LOCKS HELD:        5    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
                     ------- ------- ------- ------- -------  ------------  ------  -------      ----------
                           5       0       0       0       0             0       0     IX                 0

                      --- SCAN ACTIVITY -----------------------------------------------------------------------------------------
                       ------ROWS------ --QUALIFIED AT--- ----------ROWS------------  -PAGES-  -------RI--------
                        SCANS   PROCESS  EXAMINE  STAGE 1  STAGE 2  INSERTS  UPDATES  DELETES  SCANNED     SCANS  DELETES
                       ------  -------- -------- -------- -------- -------- -------- -------- --------  -------- --------
                            9         3        3        0        0        4        1        0       16         4        0


          N/A

                                                   SQL EVENT                  COUNT   AVG ELAPSED   AVG CPU TIME
                                                   ----------------------  --------  ------------   ------------
                                                   AUTOBIND                       1  00:00.036081   00:00.001963

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