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

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

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                       BSQTRCPW: SQL SUMMARY TRC BY PGM   W/WKL                         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

                      --- WORKLOAD HILITES -----------------------------------------------------------------------------------------
                      SCANS   :   9690   IO REQS :       34  SUSPENDS  :     3158  EXIT CALLS :        6  AMS CALLS     :        0
                      ROWSPROC: 166276   IO AVELA: 0.002969  SUSP AVELA:        0  EXIT AVELAP: 0.000002  AMS AVGELAPSED:      N/P
                      PAGSSCAN:  11163                       DATACAPTUR: NO        CHKCONSTOK :        0  CHKCONSTREJECT:        0

                      --- EXITS ------------------------------------------------------------------
                       VALIDATION CALLS  AVG ELAPSED       EDIT EXIT CALLS  AVG ELAPSED
                       ----------------  -----------       ---------------  -----------
                                      0          N/P                     6     0.000002

                      --- 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
                       ------- -------  -------  ----  ---------  ------ --------  ------   ------- ---- ------ --------- ---------
                            34 00.0030       34  SYNC    00.0030  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     1     0  3152     0     0      0      N/P       0      N/P       0      N/P
                       DRAIN                0     0     0     5     0     0      0      N/P       0      N/P       0      N/P

                      --- PAGE/ROW/LOB/XML LOCKING -------------------------------------------------------------------------
                       SUMMARY: MAX LOCKS HELD:     5025    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
                     ------- ------- ------- ------- -------  ------------  ------  -------      ----------
                          13       1       0       0       0             1       0     N/P                1

                      --- SCAN ACTIVITY -----------------------------------------------------------------------------------------
                       ------ROWS------ --QUALIFIED AT--- ----------ROWS------------  -PAGES-  -------RI--------
                        SCANS   PROCESS  EXAMINE  STAGE 1  STAGE 2  INSERTS  UPDATES  DELETES  SCANNED     SCANS  DELETES
                       ------  -------- -------- -------- -------- -------- -------- -------- --------  -------- --------
                         9690    166276   210311    19074    11584        0        2        0    11163         0        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