|
|
|
Type E in the LC field on the DB2 Statements panel and press Enter. The Explain panel displays.
CA MAT ---------------------- DB2 Explain Data ----------- Row 1 to 22 of 68 COMMAND ===> SCROLL ===> HALF Profile: PROFT9 DB2 SSID: DIA3 DB2 Rel: 9.1.0 PLAN_TABLE QMF | PLAN_TABLE Selected Row: 001 OF 002 COLUMN HEADING | EXPLAIN Data... Scroll --> for next PLANTABLE row ________________ ________ ____________________________________________________ >------------------------------------------------------------------------------ CA MAT ........ EXPDBRM | D91PROG CA MAT ........ EXPSTM# | 769 | QUERYNO ........ QUERY_NO | 1296126539 QBLOCKNO ....... QRY_BLK | 3 QBLOCK_TYPE .... EXPQTYPE | NCOSUB | GROUP_MEMBER ... EXPGPMEM | DIA3 | APPLNAME ....... PLANNAME | D91PRG VERSION ........ VERSION | **N/A** PROGNAME ....... PROGRAM | D91PROG: (CA MAT Monitoring) COLLID ......... COL_LID | D91PROGZ_BIG_PACKAGE_LITTLE_PACKAGE_PACKAGE_LONGE | WHEN_OPTIMIZE .. EXPWOPT | **N/A** LAST_BIND_TIME . EXPBNTIM | 2009-02-04-07.46.20.199913 | PLANNO ......... QBLKSTEP | 1 METHOD ......... METH ... | 0: (First Table Accessed) | TNAME .......... TABLNAME | DB2DATA TABNO .......... ........ | 3 CREATOR ........ CREATOR | RDWM91
| ACCESSTYPE ..... TYPE ... | R: (TableSpace Scan) ACCESSCREATOR .. ........ | **N/A** ACCESSNAME ..... INDEX .. | **N/A** | MATCHCOLS ...... MCOL ... | 0 INDEXONLY ...... I ...... | NO MIXOPSEQ ....... MULT_IDX | 0 | SORTN_UNIQ ..... S_N_U .. | NO SORTN_JOIN ..... S_N_J .. | NO SORTN_ORDERBY .. S_N_O .. | NO SORTN_GROUPBY .. S_N_G .. | NO | SORTC_UNIQ ..... S_C_U .. | NO SORTC_JOIN ..... S_C_J .. | NO SORTC_ORDERBY .. S_C_O .. | NO SORTC_GROUPBY .. S_C_G .. | NO | TSLOCKMODE ..... LCK_MOD | IS: (Intent Share LOCK) | PREFETCH ....... P_F .... | S: (Sequential PREFETCH can be used) COLUMN_FN_EVAL . COLFNEVL | **N/A**: (Evaluation Time Unknown) | ACCESS_DEGREE .. EXPACDGR | NULL value ACCESS_PGROUP_ID EXPACPGP | NULL value JOIN_DEGREE .... EXPJODGR | NULL value JOIN_PGROUP_ID . EXPJOPGP | NULL value SORTC_PGROUP_ID EXPSTCPG | NULL value SORTN_PGROUP_ID EXPSTNPG | NULL value PARALLELISM_MODE EXPPMODE | NULL value | JOIN_TYPE ...... EXPJTYPE | **N/A**: (Inner JOIN or No JOIN) MERGE_JOIN_COLS EXPMRGJC | NULL value | CORRELATION_NAME EXPCORNM | A PAGE_RANGE ..... EXPPRNGE | **N/A** | OPTHINT ........ EXPOPTHN | **N/A** HINT_USED ...... EXPHINTU | **N/A** PRIMARY_ACCESS.. EXPPRMAC | **N/A** | TIMESTAMP ...... TIMSTAMP | 2009020411125462 | REMARKS ........ ........ | **N/A** ********************************* End of Table ********************************
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |