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.