Columns available for filtering SQL statements in statement caches

Put your short description here; used for first paragraph and abstract.
AVG_STAT_ELAP
The average elapsed time that is used for the statement.
AVG_STAT_CPU
The average CPU time that is used for the statement.
BIND_CDATA
The value of the CURRENTDATA BIND option that is in effect for the statement.
BIND_CHOLD
The value of the WITH HOLD attribute of the PREPARE for the statement.
BIND_DEGRE
The value of the CURRENT DEGREE special register that is in effect for the statement.
BIND_DYNRL
The value of the DYNAMICRULES BIND option that is in effect for the statement.
BIND_ISO
The value of the ISOLATION BIND option that is in effect for the statement.
BIND_QUALIFIER
The BIND qualifier. For unqualified table names, this qualifier is the object qualifier.
BIND_SQLRL
The value of the CURRENT RULES special register that is in effect for the statement.
CACHED_TS
The timestamp when the statement was stored in the dynamic statement cache.
COLLID
The collection ID. Because DSN_STATEMENT_CACHE_TABLE is used to explain cached statements, the value of this column is DSNDYNAMICSQLCACHE.
COPIES
The number of copies of the statement that are owned by all threads in the system.
CURSQLID
The CURRENT SQLID that did the initial PREPARE of the statement.
EXPLAIN_TS
The timestamp for when the dynamic statement cache was populated.
GROUP_MEMBER
The member name of the DB2® that executed EXPLAIN. The column is blank if the DB2 subsystem was not in a data sharing environment when EXPLAIN was executed.
INV_DROPALT
This column indicates if the statement has been invalidated by a DROP or ALTER statement.
INV_LRU
This column indicates if the statement has been removed from the cache by LRU.
INV_REVOKE
This column indicates if the statement has been invalidated by a REVOKE statement.
INV_RUNSTATS
This column indicates if the statement has been invalidated by RUNSTATS.
LINES
The precompiler line number from the initial PREPARE of the statement.
PRIMAUTH
The primary authorization ID that did the initial PREPARE of the statement.
PROGRAM_NAME
The name of the package or DBRM that performed the initial PREPARE for the statement.
STAT_CPU
The accumulated CPU time that is used for the statement.
STAT_ELAP
The accumulated elapsed time that is used for the statement.
STAT_EROW
The number of rows that are examined for the statement.
STAT_INDX
The number of index scans that are performed for the statement.
STAT_PGRP
The number of parallel groups that are created for the statement.
STAT_PROW
The number of rows that are processed for the statement.
STAT_RIDLIMT
The number of times that a RID list was not used because the number of RIDs would have exceeded DB2 limits.
STAT_RIDSTOR
The number of times a RID list was not used because not enough storage is available to hold the list of RIDs.
STAT_RSCN
The number of table space scans that are performed for the statement.
STAT_SYNR
The number of synchronous buffer reads that are performed for the statement.
STAT_WRIT
The number of buffer write operations that are performed for the statement.
STAT_SORT
The number of sorts that are performed for the statement.
STAT_SUS_GLCK
The accumulated wait time for global locks for the statement.
STAT_SUS_LOCK
The accumulated wait time for lock and latch requests for the statement.
STAT_SUS_OTHR
The accumulated wait time for read activity that is done by another thread.
STAT_SUS_OTHW
The accumulated wait time for write activity done by another thread.
STAT_SUS_SWIT
The accumulated wait time for synchronous execution unit switch for the statement.
STAT_SUS_SYNIO
The accumulated wait time for synchronous I/O operations for the statement.
STMT_ID
The ID of the statement in the dynamic statement cache.
STMT_TEXT
The text of the SQL statement.
STMT_TOKEN
An identification string.
STAT_TS
Timestamp of the statistics, which is the timestamp when IFCID 318 is started.
USERS
The number of current users of the statement. This number indicates the users that have prepared or run the statement during their current unit of work.

Feedback