EXPLAIN_INSTANCE
FieldTypeDescription
EXPLAIN_REQUESTERstringExplain Requester
EXPLAIN_TIMEdatetimeExplain Time
SOURCE_NAMEstringSource Name
SOURCE_SCHEMAstringSource Schema
SOURCE_VERSIONstringSource Version
EXPLAIN_OPTIONstringExplain Option
SNAPSHOT_TAKENstringSnapshot Taken
DB2_VERSIONstringDb2 Version
SQL_TYPEstringSql Type
QUERYOPTintegerQueryopt
BLOCKstringBlock
ISOLATIONstringIsolation
BUFFPAGEintegerBuffpage
AVG_APPLSintegerAvg Appls
SORTHEAPintegerSortheap
LOCKLISTintegerLocklist
MAXLOCKSintegerMaxlocks
LOCKS_AVAILintegerLocks Avail
CPU_SPEEDdoubleCpu Speed
REMARKSstringRemarks
DBHEAPintegerDbheap
COMM_SPEEDdoubleComm Speed
PARALLELISMstringParallelism
DATAJOINERstringDatajoiner
EXECUTABLE_IDstringExecutable Id
EXECUTION_TIMEdatetimeExecution Time