Explain report fields
The Explain Report Field labels table lists the fields that are on the Explain reports in alphabetic order by field label name. Each field is shown with the DB2 column name, the DB2 table or other source from which it comes, and the section of the Explain report where you can find it.
The field labels are controlled by the hlq.llqSAMP (PSSREPA) layout data set member. The labels shown below are the default labels that are shipped with SQL Explorer. For information about customizing the layout of your reports, see Editing-the-Explain-report-layout.
Report field label | DB2 column name | DB2 table or other source | Report section |
|---|---|---|---|
1STKEY | FIRSTKEYCARDF | SYSINDEXES | INDEX_STATS |
ACC | ACCESSTYPE | PLAN_TABLE | PLAN_TABLE |
ADEG | ACCESS_DEGREE | PLAN_TABLE | PLAN_TABLE |
AFTER | AFTER_JOIN | DSN_PREDICAT_TABLE | PREDICATE |
APG | ACCESS_PGROUP_ID | PLAN_TABLE | PLAN_TABLE |
BIND_EXPLAIN_ONLY | BIND_EXPLAIN_ONLY | PLAN_TABLE | PLAN_TABLE |
BIND_TIME | BIND_TIME | PLAN_TABLE | PLAN_TABLE |
BINDTIME | BINDTIME | SYSPLAN | DBRM |
BINDTIME | BINDTIME | SYSPACKAGE | PACKAGE |
BINDTIME | BINDTIME | SYSPACKLIST | PACKLIST |
BPOOL | BPOOL | SYSINDEXES | INDEX_STATS |
BPOOL | BPOOL | SYSTABLESPACE | TABLE_STATS |
CARD | COLCARDF | SYSCOLUMNS | COLUMNS |
CARD | CARDF | SYSTABLES | TABLE_STATS |
CAT | COST_CATEGORY | DSN_STATEMNT_TABLE | STMT_COST |
CFE | COLUMN_FN_EVAL | PLAN_TABLE | PLAN_TABLE |
CHARSET | CHARSET | SYSDBRM | DBRM |
CHARSET | CHARSET | SYSPACKAGE | PACKAGE |
CHARSET | CHARSET | SYSPACKLIST | PACKLIST |
CHECKFLAG | CHECKFLAG | SYSTABLES | TABLE_STATS |
CHILD | CHILDREN | SYSTABLES | TABLE_STATS |
CLOSERULE | CLOSERULE | SYSTABLESPACE | TABLE_STATS |
CLUSTERED | CLUSTERED | SYSINDEXES | INDEX_STATS |
CLUSTERING | CLUSTERING | SYSINDEXES | INDEX_STATS |
CLUSTERRATIO | CLUSTERRATIOF | SYSINDEXES | INDEX_STATS |
COLLID | COLLID | SYSPACKAGE | PACKAGE |
COLLID | COLLID | SYSPACKLIST | PACKLIST |
COLNO | COLNO | SYSCOLUMNS | COLUMNS |
COLNO | COLNO | SYSKEYS | KEYCOLS |
COLUMN NAME | NAME | SYSCOLUMNS | COLUMNS |
COMMA | COMMA | SYSDBRM | DBRM |
COMMA | COMMA | DBRMLIB member | MEMBER |
COMMA | COMMA | SYSPACKAGE | PACKAGE |
COMP | PCTROWCOMP | SYSTABLES | TABLE_STATS |
COMPRESS | COMPRESS | SYSTABLEPART | TABLE_STATS |
CONTOKEN | CONTOKEN | DBRMLIB member | MEMBER |
CONTOKEN | CONTOKEN | SYSPACKAGE | PACKAGE |
CORR | CORRELATION_NAME | PLAN_TABLE | PLAN_TABLE |
COST*RATE | COMPCOST | DSN_DETCOST_TABLE | PLAN_TABLE |
COST*RATE | COST | DSN_STATEMNT_TABLE | STMT_COST |
CREATOR | CREATOR | SYSDBRM | DBRM |
CREATOR | CREATOR | SYSINDEXES | INDEX_STATS |
CREATOR | CREATOR | DBRMLIB member | MEMBER |
CREATOR | CREATOR | SYSPACKAGE | PACKAGE |
CREATOR | CREATOR | SYSPACKLIST | PACKLIST |
CREATOR | CREATOR | SYSTABLES | TABLE_STATS |
CU | SORTC_UNIQ | PLAN_TABLE | PLAN_TABLE |
DATABASE | DBNAME | SYSTABLES | TABLE_STATS |
DBPROTOCOL | DBPROTOCOL | SYSPLAN | DBRM |
DBPROTOCOL | DBPROTOCOL | SYSPACKAGE | PACKAGE |
DBPROTOCOL | DBPROTOCOL | SYSPACKLIST | PACKLIST |
DEC31 | DEC31 | SYSDBRM | DBRM |
DEC31 | DEC31 | DBRMLIB member | MEMBER |
DEC31 | DEC31 | SYSPACKAGE | PACKAGE |
DEC31 | DEC31 | SYSPACKLIST | PACKLIST |
DEFERPREP | DEFERPREP | SYSPLAN | DBRM |
DEFERPREP | DEFERPREP | SYSPACKAGE | PACKAGE |
DEFERPREP | DEFERPREP | SYSPACKLIST | PACKLIST |
DEFERPREPARE | DEFERPREPARE | SYSPACKAGE | PACKAGE |
DEGREE | DEGREE | SYSPLAN | DBRM |
DEGREE | DEGREE | SYSPACKAGE | PACKAGE |
DEGREE | DEGREE | SYSPACKLIST | PACKLIST |
DYNAMICRULES | DYNAMICRULES | SYSPLAN | DBRM |
DYNAMICRULES | DYNAMICRULES | SYSPACKAGE | PACKAGE |
DYNAMICRULES | DYNAMICRULES | SYSPACKLIST | PACKLIST |
EDPROC | EDPROC | SYSTABLES | TABLE_STATS |
ENCODING_CCSID | ENCODING_CCSID | SYSPLAN | DBRM |
ENCODING_CCSID | ENCODING_CCSID | SYSPACKAGE | PACKAGE |
ENCODING_CCSID | ENCODING_CCSID | SYSPACKLIST | PACKLIST |
EXPLAIN | EXPLAN | SYSPLAN | DBRM |
EXPLAIN | EXPLAIN | SYSPACKAGE | PACKAGE |
EXPLAIN | EXPLAN | SYSPACKLIST | PACKLIST |
EXPLAIN_TIME | EXPLAIN_TIME | PLAN_TABLE | PLAN_TABLE |
EXPREDICATE | EXPREDICATE | SYSPLAN | DBRM |
EXPREDICATE | EXPREDICATE | SYSPACKLIST | PACKLIST |
FARINDREF | FARINDREF | SYSTABLEPART | TABLE_STATS |
FAROFF | FAROFFPOSF | SYSINDEXPART | INDEX_STATS |
FILTER | FILTER_FACTOR | DSN_PREDICAT_TABLE | PREDICATE |
FREEPAGE | FREEPAGE | SYSTABLEPART | TABLE_STATS |
FULLKEY | FULLKEYCARDF | SYSINDEXES | INDEX_STATS |
FUNCTIONTS | FUNCTIONTS | SYSPLAN | DBRM |
FUNCTIONTS | FUNCTIONTS | SYSPACKAGE | PACKAGE |
FUNCTIONTS | FUNCTIONTS | SYSPACKLIST | PACKLIST |
G | SORTN_GROUPBY | PLAN_TABLE | PLAN_TABLE |
G | SORTC_GROUPBY | PLAN_TABLE | PLAN_TABLE |
GME | GROUP_MEMBER | PLAN_TABLE | PLAN_TABLE |
GROUP_MEMBER | GROUP_MEMBER | SYSPLAN | DBRM |
GROUP_MEMBER | GROUP_MEMBER | SYSPACKAGE | PACKAGE |
GROUP_MEMBER | GROUP_MEMBER | SYSPACKLIST | PACKLIST |
HI2KEY | HIGH2KEY | SYSCOLUMNS | COLUMNS |
HOSTLANG | HOSTLANG | SYSDBRM | DBRM |
HOSTLANG | HOSTLANG | SYSPACKAGE | PACKAGE |
IMMEDWRITE | IMMEDWRITE | SYSPLAN | DBRM |
IMMEDWRITE | IMMEDWRITE | SYSPACKAGE | PACKAGE |
IMMEDWRITE | IMMEDWRITE | SYSPACKLIST | PACKLIST |
ISOLATION | ISOLATION | SYSPLAN | DBRM |
ISOLATION | ISOLATION | SYSPACKAGE | PACKAGE |
ISOLATION | ISOLATION | SYSPACKLIST | PACKLIST |
IX | INDEXONLY | PLAN_TABLE | PLAN_TABLE |
IXCREATOR | ACCESSCREATOR | PLAN_TABLE | PLAN_TABLE |
IXNAME | NAME | SYSINDEXES | INDEX_STATS |
IXNAME | ACCESSNAME | PLAN_TABLE | PLAN_TABLE |
J | SORTN_JOIN | PLAN_TABLE | PLAN_TABLE |
J | SORTC_JOIN | PLAN_TABLE | PLAN_TABLE |
JDEG | JOIN_DEGREE | PLAN_TABLE | PLAN_TABLE |
JOIN | JOIN | DSN_PREDICAT_TABLE | PREDICATE |
JPG | JOIN_PGROUP_ID | PLAN_TABLE | PLAN_TABLE |
JTYPE | JOIN_TYPE | PLAN_TABLE | PLAN_TABLE |
KEEPDYNAMIC | KEEPDYNAMIC | SYSPLAN | DBRM |
KEEPDYNAMIC | KEEPDYNAMIC | SYSPACKAGE | PACKAGE |
KEEPDYNAMIC | KEEPDYNAMIC | SYSPACKLIST | PACKLIST |
KEY | KEYFIELD | DSN_PREDICAT_TABLE | PREDICATE |
KEY COLUMN | COLNAME | SYSKEYS | KEYCOLS |
KEYCOLS | KEYCOLS | SYSINDEXES | INDEX_STATS |
LCK | TSLOCKMODE | PLAN_TABLE | PLAN_TABLE |
LEAFDIST | LEAFDIST | SYSINDEXPART | INDEX_STATS |
LEFT-HAND | LEFT_HAND_SIDE | DSN_PREDICAT_TABLE | PREDICATE |
LEN | LENGTH | SYSCOLUMNS | COLUMNS |
LHS_TABNO | LHS_TABNO | DSN_PREDICAT_TABLE | PREDICATE |
LO2KEY | LOW2KEY | SYSCOLUMNS | COLUMNS |
LOCK | LOCKRULE | SYSTABLESPACE | TABLE_STATS |
MERGC | MERGC | PLAN_TABLE | PLAN_TABLE |
MERGE | MERGE_JOIN_COLS | PLAN_TABLE | PLAN_TABLE |
MERGN | MERGN | PLAN_TABLE | PLAN_TABLE |
METH | METHOD | PLAN_TABLE | PLAN_TABLE |
MISMATCH | MISMATCH | None | PREDICATE |
MIX | MIXOPSEQ | PLAN_TABLE | PLAN_TABLE |
MIXED | MIXED | SYSDBRM | DBRM |
MIXED | MIXED | DBRMLIB member | MEMBER |
MIXED | MIXED | SYSPACKAGE | PACKAGE |
MIXED | MIXED | SYSPACKLIST | PACKLIST |
MTCH | MATCHCOLS | PLAN_TABLE | PLAN_TABLE |
NACTIVE | NACTIVEF | SYSTABLESPACE | TABLE_STATS |
NAME | NAME | SYSDBRM | DBRM |
NAME | NAME | DBRMLIB member | MEMBER |
NAME | NAME | SYSPACKAGE | PACKAGE |
NAME | NAME | SYSPACKLIST | PACKLIST |
NEARINDREF | NEARINDREF | SYSTABLEPART | TABLE_STATS |
NEAROFF | NEAROFFPOSF | SYSINDEXPART | INDEX_STATS |
NLEAF | NLEAF | SYSINDEXES | INDEX_STATS |
NLEVELS | NLEVELS | SYSINDEXES | INDEX_STATS |
NO | TABNO | PLAN_TABLE | PLAN_TABLE |
NPAGES | NPAGESF | SYSTABLES | TABLE_STATS |
NU | SORTN_UNIQ | PLAN_TABLE | PLAN_TABLE |
NULLS | NULLS | SYSCOLUMNS | COLUMNS |
O | SORTN_ORDERBY | PLAN_TABLE | PLAN_TABLE |
O | SORTC_ORDERBY | PLAN_TABLE | PLAN_TABLE |
OPER | OPERATIVE | SYSPLAN | DBRM |
OPER | OPERATIVE | SYSPACKAGE | PACKAGE |
OPER | OPERATIVE | SYSPACKLIST | PACKLIST |
OPTHINT | OPTHINT | SYSDBRM | DBRM |
OPTHINT | OPTHINT | SYSPACKAGE | PACKAGE |
OPTHINT | OPTHINT | SYSPACKLIST | PACKLIST |
OPTHINT | OPTHINT | PLAN_TABLE | PLAN_TABLE |
ORDERING | ORDERING | SYSKEYS | KEYCOLS |
OWNER | OWNER | SYSPACKAGE | PACKAGE |
PADDED | PADDED | SYSINDEXES | INDEX_STATS |
PAR | PARALLELISM_MODE | PLAN_TABLE | PLAN_TABLE |
PARENT | PARENTS | SYSTABLESPACE | TABLE_STATS |
PARENT_PLANNO | PARENT_PLANNO | PLAN_TABLE | PLAN_TABLE |
PARENT_QBLOCKNO | PARENT_QBLOCKNO | PLAN_TABLE | PLAN_TABLE |
PARTS | PARTITIONS | SYSTABLESPACE | TABLE_STATS |
PCTFREE | PCTFREE | SYSINDEXPART | INDEX_STATS |
PCTFREE | PCTFREE | SYSTABLEPART | TABLE_STATS |
PCTPAGES | PCTPAGES | SYSTABLES | TABLE_STATS |
PDSNAME | PDSNAME | SYSDBRM | DBRM |
PDSNAME | PDSNAME | DBRMLIB member | MEMBER |
PDSNAME | PDSNAME | SYSPACKAGE | PACKAGE |
PERCACTIVE | PERCACTIVE | SYSTABLEPART | TABLE_STATS |
PERCDROP | PERCDROP | SYSTABLEPART | TABLE_STATS |
PGSIZE | PGSIZE | SYSTABLESPACE | TABLE_STATS |
PL | PLANNO | PLAN_TABLE | PLAN_TABLE |
PLAN | PLNAME | SYSPLAN | DBRM |
PLAN | PLANNAME | SYSPACKLIST | PACKLIST |
PRANGE | PAGE_RANGE | PLAN_TABLE | PLAN_TABLE |
PRE | PREFETCH | PLAN_TABLE | PLAN_TABLE |
PROCMS | PROCMS | DSN_STATEMNT_TABLE | STMT_COST |
PTYPE | PRIMARY_ACCESSTYPE | PLAN_TABLE | PLAN_TABLE |
QB | QBLOCKNO | PLAN_TABLE | PLAN_TABLE |
QTYPE | QBLOCK_TYPE | PLAN_TABLE | PLAN_TABLE |
QUALIFIER | QUALIFIER | SYSPLAN | DBRM |
QUALIFIER | QUALIFIER | SYSPACKAGE | PACKAGE |
QUALIFIER | QUALIFIER | SYSPACKLIST | PACKLIST |
QUERYNO | QUERYNO | PLAN_TABLE | PLAN_TABLE |
QUERYNO | QUERYNO | DSN_PREDICAT_TABLE | PREDICATE |
QUOTE | QUOTE | SYSDBRM | DBRM |
QUOTE | QUOTE | DBRMLIB member | MEMBER |
QUOTE | QUOTE | SYSPACKAGE | PACKAGE |
REASON | REASON | DSN_STATEMNT_TABLE | STMT_COST |
RECLENGTH | RECLENGTH | SYSTABLES | TABLE_STATS |
RELBOUND | RELBOUND | SYSPLAN | DBRM |
RELBOUND | RELBOUND | SYSPACKAGE | PACKAGE |
RELBOUND | RELBOUND | SYSPACKLIST | PACKLIST |
RELEASE | RELEASE | SYSPLAN | DBRM |
RELEASE | RELEASE | SYSPACKAGE | PACKAGE |
RELEASE | RELEASE | SYSPACKLIST | PACKLIST |
REMOTE | REMOTE | SYSPACKAGE | PACKAGE |
REOPT | REOPTVAR | SYSPLAN | DBRM |
REOPT | REOPTVAR | SYSPACKAGE | PACKAGE |
REOPT | REOPTVAR | SYSPACKLIST | PACKLIST |
RIGHT-HAND | RIGHT_HAND_SIDE | DSN_PREDICAT_TABLE | PREDICATE |
S.U.*RATE | PROCSU | DSN_STATEMNT_TABLE | STMT_COST |
SCALE | SCALE | SYSCOLUMNS | COLUMNS |
SCPG | SORTC_PGROUP_ID | PLAN_TABLE | PLAN_TABLE |
SECTNOI | SECTNOI | PLAN_TABLE | PLAN_TABLE |
SEGSIZE | SEGSIZE | SYSTABLESPACE | TABLE_STATS |
SNPG | SORTN_PGROUP_ID | PLAN_TABLE | PLAN_TABLE |
SQLERROR | SQLERROR | SYSPACKAGE | PACKAGE |
SQL-STATEMENT | STMT | SYSSTMT, SYSPACKSTMT, DBRMLIB member | SQLTEXT |
SQL-STATEMENT | STMT | SYSSTMT, SYSPACKSTMT, DBRMLIB member, APPTUNE trace data | STMT_COST |
STATFDBK | REASON | DSN_STAT_FEEDBACK | COLUMNS |
STATFDBK | REASON | DSN_STAT_FEEDBACK | INDEX_STATS |
STATFDBK | REASON | DSN_STAT_FEEDBACK | KEYCOLS |
STATFDBK | REASON | DSN_STAT_FEEDBACK | TABLE_STATS |
STATSTIME | STATSTIME | SYSCOLUMNS | COLUMNS |
STATSTIME | STATSTIME | SYSINDEXES | INDEX_STATS |
STATSTIME | STATSTIME | SYSTABLES | TABLE_STATS |
STG1 | SEARCHARG | DSN_PREDICAT_TABLE | PREDICATE |
STMT_TYPE | STMT_TYPE | DSN_STATEMNT_TABLE | STMT_COST |
STMTNO | STMTNO | SYSSTMT, SYSPACKSTMT, DBRMLIB member | SQLTEXT |
STMTNO | STMTNO | SYSSTMT, SYSPACKSTMT, DBRMLIB member, APPTUNE trace data | STMT_COST |
TABLESPACE | TSNAME | SYSTABLES | TABLE_STATS |
TBCREATOR | CREATOR | PLAN_TABLE | PLAN_TABLE |
TBNAME | TNAME | PLAN_TABLE | PLAN_TABLE |
TBNAME | NAME | SYSTABLES | TABLE_STATS |
TIMESTAMP | TIMESTAMP | SYSDBRM | DBRM |
TIMESTAMP | TIMESTAMP | SYSPACKLIST | PACKLIST |
TIMESTAMP | TIMESTAMP | PLAN_TABLE | PLAN_TABLE |
TSTYPE | TSTYPE | SYSTABLESPACE | TABLE_STATS |
TTYPE | TABLE_TYPE | PLAN_TABLE | PLAN_TABLE |
TYPE | COLTYPE | SYSCOLUMNS | COLUMNS |
TYPE | INDEXTYPE | SYSINDEXES | INDEX_STATS |
TYPE | TYPE | SYSPACKAGE | PACKAGE |
TYPE | TYPE | DSN_PREDICAT_TABLE | PREDICATE |
TYPE | TYPE | SYSTABLESPACE | TABLE_STATS |
UNIQUE | UNIQUERULE | SYSINDEXES | INDEX_STATS |
USED | HINT_USED | PLAN_TABLE | PLAN_TABLE |
VALID | VALID | SYSPLAN | DBRM |
VALID | VALID | SYSPACKAGE | PACKAGE |
VALID | VALID | SYSPACKLIST | PACKLIST |
VALIDATE | VALIDATE | SYSPLAN | DBRM |
VALIDATE | VALIDATE | SYSPACKAGE | PACKAGE |
VALIDATE | VALIDATE | SYSPACKLIST | PACKLIST |
VALPROC | VALPROC | SYSTABLES | TABLE_STATS |
VERS | VERSION | SYSDBRM | DBRM |
VERS | VERSION | DBRMLIB member | MEMBER |
VERS | VERSION | SYSPACKAGE | PACKAGE |
WHEN | WHEN_OPTIMIZE | PLAN_TABLE | PLAN_TABLE |