Viewing table space index space scans

Use the following procedure to view table space and index space scans.

On STRAC, on the EXPAND line, navigate to the SCANS option and press Enter.A summary of all scans by table space and index space is displayed.

BMC SOFTWARE -------------- SUMMARY TRACE ENTRY    -----------PERFORMANCE MGMT
SERV ==> STRAC            INPUT   12:10:17 INTVL=> 3 LOG=> N TGT==> JXODEEO
PARM ==> CB000001,SEQ=3,SCAN,SORT=DA                 ROW 1 OF 46 SCROLL=> CSR
EXPAND: MON(WKLD), DETAIL, CURRENT
        ACCOUNTING: ENV, ELAP, SQLCNTS, BPOOL, LOCKS, PRLL, PKG, RTN, ACC, DDF
        SUMMARIES: SQL, SCANS, IO/LOCK, SORTS

- - - - - - - - - - - DATABASE SUMMARY (DETAIL TRACE ONLY) - - - - - - - - - -

                        ------ INDX ----- ------ DATA ----- ------ WORK+ ----
DATABASE PAGESET OBID #SCAN #PAGE #ROWS #SCAN #PAGE #ROWS #SCAN #PAGE #ROWS
-------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
DSNDB01 DBD01      ALL     5    18     9      2     2     0      0     0     0
DSNDB01 SYSLGRNX   ALL     1    10     6      1     2     0      0     0     0
DSNDB06 SYSALTER   ALL     2     8     0      0     0     0      0     0     0
DSNDB06 SYSGPAUT   ALL     5     8     2      2     2     2      0     0     0
DSNDB06 SYSROLES   ALL     1     5     0      0     0     0      0     0     0
DSNDB06 SYSSEQ     ALL     1     5     1      0     0     0      0     0     0
DSNDB06 SYSSEQ2    ALL     1     5     0      0     0     0      0     0     0
DSNDB06 SYSSTATS   ALL    11    22     0      0     0     0      0     0     0
DSNDB06 SYSTSAUX   ALL     1     5     0      0     0     0      0     0     0
DSNDB06 SYSTSCOL   ALL    13    25    26     12     1    13      0     0     0
DSNDB06 SYSTSCPY   ALL     1    12     3      1     1     0      0     0     0
DSNDB06 SYSTSCTL   ALL     1     5     0      0     0     0      0     0     0
DSNDB06 SYSTSDBA   ALL     6    10     6      1     0     1      0     0     0
DSNDB06 SYSTSDBU   ALL     4     6     2      2     2     2      0     0     0
DSNDB06 SYSTSDEP   ALL     5    10     0      0     0     0      0     0     0
DSNDB06 SYSTSDQD   ALL     2     7     0      0     0     0      0     0     0
DSNDB06 SYSTSDQY   ALL    11    22     0      0     0     0      0     0     0
DSNDB06 SYSTSIXS   ALL    15    36     0      0     0     0      0     0     0
DSNDB06 SYSTSPDO   ALL     8    22     0      0     0     0      0     0     0

This data is available only if you requested SCANS on the trace request. You can review the number of rows and pages accessed per page set, and also see which indexes were used.

Viewing table space index space scans

On this page