DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007 Licensed Material - Program Property of IBM IBM DATABASE 2 Explain Table Format Tool ******************** EXPLAIN INSTANCE ******************** DB2_VERSION: 09.05.0 SOURCE_NAME: SYSSH200 SOURCE_SCHEMA: NULLID SOURCE_VERSION: EXPLAIN_TIME: 2008-05-22-13.31.14.213280 EXPLAIN_REQUESTER: USERNAME Database Context: ---------------- Parallelism: None CPU Speed: 2.401083e-07 Comm Speed: 0 Buffer Pool size: 173358 Sort Heap size: 54 Database Heap size: 1706 Lock List size: 24931 Maximum Lock List: 98 Average Applications: 1 Locks Available: 1563672 Package Context: --------------- SQL Type: Dynamic Optimization Level: 5 Blocking: Block All Cursors Isolation Level: Cursor Stability ---------------- STATEMENT 1 SECTION 65 ---------------- QUERYNO: 1 QUERYTAG: Statement Type: Insert Updatable: Not Applicable Deletable: Not Applicable Query Degree: 1 Original Statement: ------------------ INSERT INTO sche_util.import_view_1 SELECT * FROM sche_util.staging_table_1 Optimized Statement: ------------------- $WITH CONTEXT$($TRIGGER$(SCHE_UTIL.TRIG_IMPORT_VIEW_1), $TRIGGER$(SCHE_PROD.TRIG_TARGET_TABLE_I), $CONSTRAINT$(SCHE_PROD.TARGET_TABLE_1.SQL080522015526340), $CONSTRAINT$(SCHE_PROD.TARGET_TABLE_1.SQL080522015526330), $CONSTRAINT$(SCHE_PROD.TARGET_TABLE_1.SQL080522015526320), $CONSTRAINT$(SCHE_PROD.TARGET_TABLE_1.SQL080522015526310), $CONSTRAINT$(SCHE_PROD.TARGET_TABLE_1.SQL080522015526300)) SQL Text Not Available At This Time. Access Plan: ----------- Total Cost: 3.44921e+08 Query Degree: 1 Rows RETURN ( 1) Cost I/O | 345508 FILTER ( 2) 3.44921e+08 3.39735e+07 /----------------------------------------+---------------------------------------\ 8.6377e+06 0.333333 TBSCAN TBSCAN ( 3) ( 4) 196156 39.9081 113681 3.92 | +----------+--+-----------+ 8.6377e+06 0.0384 0.00147456 1 TABLE: SCHE_UTIL TBSCAN TBSCAN TABFNC: SYSIBM STAGING_TABLE_1 ( 5) ( 111) GENROW 19.9533 19.9541 1.96 1.96 | | 0.0384 0.0384 TEMP TEMP ( 6) ( 6) 19.9457 19.9457 1.96 1.96 | 0.0384 INSERT ( 7) 19.943 1.96 /---+---\ 0.0384 8.6377e+06 FILTER TABLE: SCHE_PROD ( 8) TARGET_TABLE_1 7.30984 0.96 /----------------------------------------------+---------------------------------------------\ 0.96 0.037037 NLJOIN NLJOIN ( 10) ( 17) 0.0125293 7.5996 0 1 /--------+--------\ /-------------------------------------------------------------+-------------------------------------------------------------\ 1 1 1 0.037037 NLJOIN TBSCAN FETCH NLJOIN ( 11) ( 16) ( 18) ( 20) 0.0125005 2.8813e-05 7.57328 0.0261106 0 0 1 0 /----+----\ | /----+----\ /--------------------------------------------------------------------+--------------------------------------------------------------------\ 1 1 1 1 1 0.111111 0.333333 TBSCAN TBSCAN TABFNC: SYSIBM IXSCAN TABLE: GLOBALSYS NLJOIN FILTER ( 12) ( 13) GENROW ( 19) PASSWORDS ( 21) ( 82) 2.8813e-05 0.0114416 0.00971958 0.0174879 0.00862269 0 0 0 0 0 | | | /-----------------------------------------------+----------------------------------------------\ +-----------------+-------------------------+------------------------------------------+ 1 1 1 0.333333 0.333333 1 0.96 0.0384 TABFNC: SYSIBM TEMP INDEX: SYSIBM NLJOIN FILTER TBSCAN TBSCAN NLJOIN GENROW ( 14) SQL080208110659050 ( 22) ( 53) ( 83) ( 84) ( 85) 0.00327868 0.0088652 0.00862269 2.8813e-05 0.000135661 0.0069438 0 0 0 0 0 0 | /-------------------+------------------\ +-----------------+----------------+---------------------------------+ | | /---------------------------------+--------------------------------\ 1 1 0.333333 1 0.96 0.0384 1 1 0.96 0.04 TBSCAN TBSCAN FILTER TBSCAN TBSCAN NLJOIN TABFNC: SYSIBM TABFNC: SYSIBM NLJOIN FILTER ( 15) ( 23) ( 24) ( 54) ( 55) ( 56) GENROW GENROW ( 86) ( 92) 2.8813e-05 2.8813e-05 0.00862269 2.8813e-05 0.000135661 0.0069438 0.00154634 0.00539746 0 0 0 0 0 0 0 0 | | +-----------------+-----------+---------------------------+ | | /-----------------------------+-----------------------------\ /---------------+---------------\ | 1 1 1 0.96 0.0384 1 1 0.96 0.04 0.96 1 1 TABFNC: SYSIBM TABFNC: SYSIBM TBSCAN TBSCAN NLJOIN TABFNC: SYSIBM TABFNC: SYSIBM NLJOIN FILTER TBSCAN NLJOIN NLJOIN GENROW GENROW ( 25) ( 26) ( 27) GENROW GENROW ( 57) ( 63) ( 87) ( 88) ( 93) 2.8813e-05 0.000135661 0.0069438 0.00154634 0.00539746 0.000135661 0.0010903 0.00477268 0 0 0 0 0 0 0 0 | | /----------------------+----------------------\ /--------+--------\ | | /----+----\ /--------------------------+--------------------------\ 1 1 0.96 0.04 0.96 1 1 1 0.0384 1 0.0384 1 TABFNC: SYSIBM TABFNC: SYSIBM NLJOIN FILTER TBSCAN NLJOIN NLJOIN TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER GENROW GENROW ( 28) ( 34) ( 58) ( 59) ( 64) GENROW ( 89) ( 90) ( 94) ( 95) 0.00154634 0.00539746 0.000135661 0.0010903 0.00477268 0.000424848 0.000447658 0.000322273 0.00423261 0 0 0 0 0 0 0 0 0 /--------+-------\ | | /----+----\ /--------------------------+--------------------------\ | | | | 0.96 1 1 1 0.0384 1 0.0384 1 1 0.96 1 0.333333 TBSCAN NLJOIN NLJOIN TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN ( 29) ( 30) ( 35) GENROW ( 60) ( 61) ( 65) ( 66) GENROW ( 91) GENROW ( 96) 0.000135661 0.0010903 0.00477268 0.000424848 0.000447658 0.000322273 0.00423261 0.000135661 0.00419699 0 0 0 0 0 0 0 0 0 | /----+----\ /-------------+------------\ | | | | | +----------------------------------++----------------+---------------+ 1 0.0384 1 0.0384 1 1 0.96 1 0.333333 1 0.0384 0.96 0 1 TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM NLJOIN TBSCAN TBSCAN TABFNC: SYSIBM GENROW ( 31) ( 32) ( 36) ( 37) GENROW ( 62) GENROW ( 67) GENROW ( 97) ( 109) ( 110) GENROW 0.000424848 0.000447658 0.000322273 0.00423261 0.000135661 0.00419699 0.0029455 0.000135661 2.16097e-05 0 0 0 0 0 0 0 0 0 | | | | | +----------------------------------++----------------+---------------+ /------------------+-----------------\ | | 1 0.96 1 0.333333 1 0.0384 0.96 0 1 0.96 0.04 1 0 TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM NLJOIN TBSCAN TBSCAN TABFNC: SYSIBM NLJOIN FILTER TABFNC: SYSIBM TABFNC: SYSIBM GENROW ( 33) GENROW ( 38) GENROW ( 68) ( 80) ( 81) GENROW ( 98) ( 104) GENROW TFCALL 0.000135661 0.00419699 0.0029455 0.000135661 2.16097e-05 0.00133299 0.00161251 0 0 0 0 0 0 0 | +----------------------------------++----------------+---------------+ /------------------+-----------------\ | | /--------+-------\ | 1 0.0384 0.96 0 1 0.96 0.04 1 0 0.96 1 1 TABFNC: SYSIBM NLJOIN TBSCAN TBSCAN TABFNC: SYSIBM NLJOIN FILTER TABFNC: SYSIBM TABFNC: SYSIBM TBSCAN NLJOIN NLJOIN GENROW ( 39) ( 51) ( 52) GENROW ( 69) ( 75) GENROW TFCALL ( 99) ( 100) ( 105) 0.0029455 0.000135661 2.16097e-05 0.00133299 0.00161251 0.000135661 0.000881053 0.000987731 0 0 0 0 0 0 0 0 /------------------+-----------------\ | | /--------+-------\ | | /----+----\ /----+----\ 0.96 0.04 1 0 0.96 1 1 1 2.23517e-10 1 0.0384 1 NLJOIN FILTER TABFNC: SYSIBM TABFNC: SYSIBM TBSCAN NLJOIN NLJOIN TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER ( 40) ( 46) GENROW TFCALL ( 70) ( 71) ( 76) GENROW ( 101) ( 102) ( 106) ( 107) 0.00133299 0.00161251 0.000135661 0.000881053 0.000987731 0.000219699 0.000447658 0.000322273 0.000447658 0 0 0 0 0 0 0 0 0 /--------+-------\ | | /----+----\ /----+----\ | | | | 0.96 1 1 1 2.23517e-10 1 0.0384 1 1 0.96 1 0.96 TBSCAN NLJOIN NLJOIN TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN ( 41) ( 42) ( 47) GENROW ( 72) ( 73) ( 77) ( 78) GENROW ( 103) GENROW ( 108) 0.000135661 0.000881053 0.000987731 0.000219699 0.000447658 0.000322273 0.000447658 0.000135661 0.000135661 0 0 0 0 0 0 0 0 0 | /----+----\ /----+----\ | | | | | | 1 2.23517e-10 1 0.0384 1 1 0.96 1 0.96 1 1 TABFNC: SYSIBM TBSCAN FILTER TBSCAN FILTER TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TABFNC: SYSIBM GENROW ( 43) ( 44) ( 48) ( 49) GENROW ( 74) GENROW ( 79) GENROW GENROW 0.000219699 0.000447658 0.000322273 0.000447658 0.000135661 0.000135661 0 0 0 0 0 0 | | | | | | 1 0.96 1 0.96 1 1 TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TBSCAN TABFNC: SYSIBM TABFNC: SYSIBM GENROW ( 45) GENROW ( 50) GENROW GENROW 0.000135661 0.000135661 0 0 | | 1 1 TABFNC: SYSIBM TABFNC: SYSIBM GENROW GENROW Extended Diagnostic Information: -------------------------------- Diagnostic Identifier: 1 Diagnostic Details: EXP0080W The current usage of the statement or the statement containing update, delete or insert or constructs like sampling limits MQT matching. Plan Details: ------------- 1) RETURN: (Return Result) Cumulative Total Cost: 3.44921e+08 Cumulative CPU Cost: 4.84182e+12 Cumulative I/O Cost: 3.39735e+07 Cumulative Re-Total Cost: 3.44729e+08 Cumulative Re-CPU Cost: 4.84111e+12 Cumulative Re-I/O Cost: 3.38598e+07 Cumulative First Row Cost: 531.737 Estimated Bufferpool Buffers: 3.39735e+07 Arguments: --------- BLDLEVEL: (Build level) DB2 v9.5.0.0 : s071001 HEAPUSE : (Maximum Statement Heap Usage) 1168 Pages STMTHEAP: (Statement heap size) 6402 Input Streams: ------------- 161) From Operator #2 Estimated number of rows: 345508 Number of columns: 0 Subquery predicate ID: Not Applicable 2) FILTER: (Filter) Cumulative Total Cost: 3.44921e+08 Cumulative CPU Cost: 4.84182e+12 Cumulative I/O Cost: 3.39735e+07 Cumulative Re-Total Cost: 3.44729e+08 Cumulative Re-CPU Cost: 4.84111e+12 Cumulative Re-I/O Cost: 3.38598e+07 Cumulative First Row Cost: 531.737 Estimated Bufferpool Buffers: 3.39735e+07 Predicates: ---------- 3) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Equal (=) Subquery Input Required: Yes Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 2) From Operator #3 Estimated number of rows: 8.6377e+06 Number of columns: 10 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.$C9+Q2.B_DOK+Q2.R_TS_DOK+Q2.COLNAME2 +Q2.COLNAME1+Q2.DT_STRING +Q2.SOMECHARCODE1+Q2.R_TS_AJOUR+Q2.SOMECHARCODES +Q2.V_ID 160) From Operator #4 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 3 Output Streams: -------------- 161) To Operator #1 Estimated number of rows: 345508 Number of columns: 0 Subquery predicate ID: Not Applicable 3) TBSCAN: (Table Scan) Cumulative Total Cost: 196156 Cumulative CPU Cost: 1.55762e+10 Cumulative I/O Cost: 113681 Cumulative Re-Total Cost: 3571.4 Cumulative Re-CPU Cost: 1.48741e+10 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 12.6426 Estimated Bufferpool Buffers: 113681 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) SEQUENTIAL ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 1) From Object SCHE_UTIL.STAGING_TABLE_1 Estimated number of rows: 8.6377e+06 Number of columns: 10 Subquery predicate ID: Not Applicable Column Names: ------------ +Q1.$RID$+Q1.B_DOK+Q1.R_TS_DOK+Q1.COLNAME2 +Q1.COLNAME1+Q1.DT_STRING +Q1.SOMECHARCODE1+Q1.R_TS_AJOUR+Q1.SOMECHARCODES +Q1.V_ID Output Streams: -------------- 2) To Operator #2 Estimated number of rows: 8.6377e+06 Number of columns: 10 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.$C9+Q2.B_DOK+Q2.R_TS_DOK+Q2.COLNAME2 +Q2.COLNAME1+Q2.DT_STRING +Q2.SOMECHARCODE1+Q2.R_TS_AJOUR+Q2.SOMECHARCODES +Q2.V_ID 4) TBSCAN: (Table Scan) Cumulative Total Cost: 39.9081 Cumulative CPU Cost: 553666 Cumulative I/O Cost: 3.92 Cumulative Re-Total Cost: 0.000649493 Cumulative Re-CPU Cost: 2705 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 39.9081 Estimated Bufferpool Buffers: 3.92 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 4) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 3) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 3 157) From Operator #5 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 4 159) From Operator #111 Estimated number of rows: 0.00147456 Number of columns: 0 Subquery predicate ID: 4 Output Streams: -------------- 160) To Operator #2 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 3 5) TBSCAN: (Table Scan) Cumulative Total Cost: 19.9533 Cumulative CPU Cost: 273806 Cumulative I/O Cost: 1.96 Cumulative Re-Total Cost: 12.6426 Cumulative Re-CPU Cost: 52528.3 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 19.9533 Estimated Bufferpool Buffers: 1 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) 1 PREFETCH: (Type of Prefetch) NONE SCANDIR : (Scan Direction) FORWARD Input Streams: ------------- 156) From Operator #6 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 Output Streams: -------------- 157) To Operator #4 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 4 6) TEMP : (Create Temporary Table) Cumulative Total Cost: 19.9457 Cumulative CPU Cost: 242054 Cumulative I/O Cost: 1.96 Cumulative Re-Total Cost: 12.642 Cumulative Re-CPU Cost: 50103.7 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 19.9457 Estimated Bufferpool Buffers: 1 Arguments: --------- CSETEMP : (Temp over common sub-expression flag) TRUE SLOWMAT : (Slow Materialization flag) TRUE TEMPSIZE: (Temporary Table Page Size) 4096 Input Streams: ------------- 155) From Operator #7 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 Output Streams: -------------- 156) To Operator #5 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 158) To Operator #111 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 7) INSERT: (Insert) Cumulative Total Cost: 19.943 Cumulative CPU Cost: 230563 Cumulative I/O Cost: 1.96 Cumulative Re-Total Cost: 12.6393 Cumulative Re-CPU Cost: 38612.6 Cumulative Re-I/O Cost: 1 Cumulative First Row Cost: 19.943 Estimated Bufferpool Buffers: 4 Input Streams: ------------- 153) From Operator #8 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 Output Streams: -------------- 154) To Object SCHE_PROD.TARGET_TABLE_1 Estimated number of rows: 8.6377e+06 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q153.UPDATE_TS+Q153.INSERT_TS +Q153.V_PID+Q153.TS_DOK+Q153.SOMETSCOL +Q153.TS_AJOUR+Q153.B_DOK+Q153.R_TS_DOK +Q153.COLNAME2+Q153.COLNAME1 +Q153.DT_STRING+Q153.SOMECHARCODE1 +Q153.R_TS_AJOUR+Q153.SOMECHARCODES+Q153.V_ID 155) To Operator #6 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 8) FILTER: (Filter) Cumulative Total Cost: 7.30984 Cumulative CPU Cost: 217563 Cumulative I/O Cost: 0.96 Cumulative Re-Total Cost: 0.0061498 Cumulative Re-CPU Cost: 25612.6 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 7.30984 Estimated Bufferpool Buffers: 3 Predicates: ---------- 5) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Equal (=) Subquery Input Required: Yes Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 13) From Operator #10 Estimated number of rows: 0.96 Number of columns: 16 Subquery predicate ID: 4 Column Names: ------------ +Q10.$C15+Q10.$C14+Q10.$C13+Q10.$C12+Q10.$C11 +Q10.$C10+Q10.$C9+Q10.$C8+Q10.$C7+Q10.$C6 +Q10.$C5+Q10.$C4+Q10.$C3+Q10.$C2+Q10.$C1 +Q10.$C0 152) From Operator #17 Estimated number of rows: 0.037037 Number of columns: 0 Subquery predicate ID: 5 Output Streams: -------------- 153) To Operator #7 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 10) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0125293 Cumulative CPU Cost: 52182 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00467131 Cumulative Re-CPU Cost: 19455 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0115917 Estimated Bufferpool Buffers: 1 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 10) From Operator #11 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 4 Column Names: ------------ +Q6.$C0+Q8.$C0 12) From Operator #16 Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 4 Output Streams: -------------- 13) To Operator #8 Estimated number of rows: 0.96 Number of columns: 16 Subquery predicate ID: 4 Column Names: ------------ +Q10.$C15+Q10.$C14+Q10.$C13+Q10.$C12+Q10.$C11 +Q10.$C10+Q10.$C9+Q10.$C8+Q10.$C7+Q10.$C6 +Q10.$C5+Q10.$C4+Q10.$C3+Q10.$C2+Q10.$C1 +Q10.$C0 11) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0125005 Cumulative CPU Cost: 52062 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00464249 Cumulative Re-CPU Cost: 19335 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0115701 Estimated Bufferpool Buffers: 1 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 5) From Operator #12 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q6.$C0 9) From Operator #13 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 Output Streams: -------------- 10) To Operator #10 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 4 Column Names: ------------ +Q6.$C0+Q8.$C0 12) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 4) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 4 Output Streams: -------------- 5) To Operator #11 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q6.$C0 13) TBSCAN: (Table Scan) Cumulative Total Cost: 0.0114416 Cumulative CPU Cost: 47652 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00439998 Cumulative Re-CPU Cost: 18325 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0114416 Estimated Bufferpool Buffers: 1 Arguments: --------- JN INPUT: (Join input leg) INNER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE SCANDIR : (Scan Direction) FORWARD Input Streams: ------------- 8) From Operator #14 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 Output Streams: -------------- 9) To Operator #11 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 14) TEMP : (Create Temporary Table) Cumulative Total Cost: 0.00327868 Cumulative CPU Cost: 13655 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00327868 Cumulative Re-CPU Cost: 13655 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00327868 Estimated Bufferpool Buffers: 1 Arguments: --------- CSETEMP : (Temp over common sub-expression flag) FALSE SLOWMAT : (Slow Materialization flag) FALSE TEMPSIZE: (Temporary Table Page Size) 4096 Input Streams: ------------- 7) From Operator #15 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 Output Streams: -------------- 8) To Operator #13 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 15) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 6) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 4 Output Streams: -------------- 7) To Operator #14 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 4 Column Names: ------------ +Q8.$C0 16) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 11) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 4 Output Streams: -------------- 12) To Operator #10 Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 4 17) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 7.5996 Cumulative CPU Cost: 164935 Cumulative I/O Cost: 1 Cumulative Re-Total Cost: 0.00609971 Cumulative Re-CPU Cost: 25404 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 7.5996 Estimated Bufferpool Buffers: 2 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 17) From Operator #18 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q12.PW 151) From Operator #20 Estimated number of rows: 0.037037 Number of columns: 7 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q59.RETURN +Q104.RETURN+Q149.RETURN Output Streams: -------------- 152) To Operator #8 Estimated number of rows: 0.037037 Number of columns: 0 Subquery predicate ID: 5 18) FETCH : (Fetch) Cumulative Total Cost: 7.57328 Cumulative CPU Cost: 55300 Cumulative I/O Cost: 1 Cumulative Re-Total Cost: 0.0016421 Cumulative Re-CPU Cost: 6839 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 7.57306 Estimated Bufferpool Buffers: 2 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 15) From Operator #19 Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 16) From Object GLOBALSYS.PASSWORDS Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q11.PW Output Streams: -------------- 17) To Operator #17 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q12.PW 19) IXSCAN: (Index Scan) Cumulative Total Cost: 0.00971958 Cumulative CPU Cost: 40480 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0012051 Cumulative Re-CPU Cost: 5019 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00971958 Estimated Bufferpool Buffers: 1 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE Predicates: ---------- 6) Start Key Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 1 Predicate Text: -------------- (Q11.PURPOSE = 'MYENCRYPT') 6) Stop Key Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 1 Predicate Text: -------------- (Q11.PURPOSE = 'MYENCRYPT') Input Streams: ------------- 14) From Object SYSIBM.SQL080208110659050 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 5 Column Names: ------------ +Q11.$RID$+Q11.PURPOSE Output Streams: -------------- 15) To Operator #18 Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 20) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0261106 Cumulative CPU Cost: 108745 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00424391 Cumulative Re-CPU Cost: 17675 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0261106 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 107) From Operator #21 Estimated number of rows: 0.111111 Number of columns: 6 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q104.RETURN +Q149.RETURN 150) From Operator #82 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q59.RETURN Output Streams: -------------- 151) To Operator #17 Estimated number of rows: 0.037037 Number of columns: 7 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q59.RETURN +Q104.RETURN+Q149.RETURN 21) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0174879 Cumulative CPU Cost: 72833.3 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00291011 Cumulative Re-CPU Cost: 12120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0174879 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 63) From Operator #22 Estimated number of rows: 0.333333 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q149.RETURN 106) From Operator #53 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q104.RETURN Output Streams: -------------- 107) To Operator #20 Estimated number of rows: 0.111111 Number of columns: 6 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q104.RETURN +Q149.RETURN 22) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0088652 Cumulative CPU Cost: 36921.7 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00157631 Cumulative Re-CPU Cost: 6565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0088652 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 19) From Operator #23 Estimated number of rows: 1 Number of columns: 4 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0 62) From Operator #24 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q149.RETURN Output Streams: -------------- 63) To Operator #21 Estimated number of rows: 0.333333 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0+Q149.RETURN 23) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 18) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 Output Streams: -------------- 19) To Operator #22 Estimated number of rows: 1 Number of columns: 4 Subquery predicate ID: 5 Column Names: ------------ +Q14.$C3+Q14.$C2+Q14.$C1+Q14.$C0 24) FILTER: (Filter) Cumulative Total Cost: 0.00862269 Cumulative CPU Cost: 35911.7 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0013338 Cumulative Re-CPU Cost: 5555 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00862269 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 86) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 21) From Operator #25 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q147.STATE+Q147.RETURN+Q147.RETURN_STATUS +Q147.CALLVAL+Q147.RETVAL 23) From Operator #26 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 86 61) From Operator #27 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 62) To Operator #22 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q149.RETURN 25) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 20) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 Output Streams: -------------- 21) To Operator #24 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q147.STATE+Q147.RETURN+Q147.RETURN_STATUS +Q147.CALLVAL+Q147.RETVAL 26) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 22) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 23) To Operator #24 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 86 27) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0069438 Cumulative CPU Cost: 28919.5 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00363161 Cumulative Re-CPU Cost: 15124.9 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0069438 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 89) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 32) From Operator #28 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 86 Column Names: ------------ +Q114.$C1+Q114.$C0+Q144.$C0 60) From Operator #34 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q142.$C1+Q142.$C0 Output Streams: -------------- 61) To Operator #24 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 86 28) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00154634 Cumulative CPU Cost: 6440.18 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00154634 Cumulative Re-CPU Cost: 6440.18 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00142115 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 25) From Operator #29 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q144.$C0 31) From Operator #30 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q114.$C1+Q114.$C0 Output Streams: -------------- 32) To Operator #27 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 86 Column Names: ------------ +Q114.$C1+Q114.$C0+Q144.$C0 29) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 24) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 25) To Operator #28 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q144.$C0 30) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0010903 Cumulative CPU Cost: 4540.89 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0010903 Cumulative Re-CPU Cost: 4540.89 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001079 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 27) From Operator #31 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q113.$C0 30) From Operator #32 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q110.$C0 Output Streams: -------------- 31) To Operator #28 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q114.$C1+Q114.$C0 31) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000424848 Cumulative CPU Cost: 1769.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000424848 Cumulative Re-CPU Cost: 1769.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000417644 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 94) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_FUNC$() IS NULL Input Streams: ------------- 26) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 27) To Operator #30 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q113.$C0 32) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 90) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 29) From Operator #33 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 30) To Operator #30 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q110.$C0 33) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 28) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 29) To Operator #32 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 86 34) FILTER: (Filter) Cumulative Total Cost: 0.00539746 Cumulative CPU Cost: 22479.3 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00208527 Cumulative Re-CPU Cost: 8684.71 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00539746 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 89) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 59) From Operator #35 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q142.$C1+Q142.$C0 Output Streams: -------------- 60) To Operator #27 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q142.$C1+Q142.$C0 35) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00477268 Cumulative CPU Cost: 19877.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00146049 Cumulative Re-CPU Cost: 6082.62 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00476137 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 34) From Operator #36 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q141.$C0 58) From Operator #37 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q139.$C0 Output Streams: -------------- 59) To Operator #34 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 86 Column Names: ------------ +Q142.$C1+Q142.$C0 36) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 120) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 33) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 34) To Operator #35 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q141.$C0 37) FILTER: (Filter) Cumulative Total Cost: 0.00423261 Cumulative CPU Cost: 17627.9 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000920415 Cumulative Re-CPU Cost: 3833.33 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00423261 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 96) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 57) From Operator #38 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 86 Output Streams: -------------- 58) To Operator #35 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 86 Column Names: ------------ +Q139.$C0 38) TBSCAN: (Table Scan) Cumulative Total Cost: 0.00419699 Cumulative CPU Cost: 17479.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000884799 Cumulative Re-CPU Cost: 3685 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00418979 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 97) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 35) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 86 52) From Operator #39 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 97 54) From Operator #51 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 56) From Operator #52 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 57) To Operator #37 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 86 39) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0029455 Cumulative CPU Cost: 12267.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0029455 Cumulative Re-CPU Cost: 12267.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0029455 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 98) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 44) From Operator #40 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 97 Column Names: ------------ +Q122.$C1+Q122.$C0+Q130.$C0 51) From Operator #46 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q128.$C1+Q128.$C0 Output Streams: -------------- 52) To Operator #38 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 97 40) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00133299 Cumulative CPU Cost: 5551.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00133299 Cumulative Re-CPU Cost: 5551.6 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001216 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 37) From Operator #41 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q130.$C0 43) From Operator #42 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q122.$C1+Q122.$C0 Output Streams: -------------- 44) To Operator #39 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 97 Column Names: ------------ +Q122.$C1+Q122.$C0+Q130.$C0 41) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 36) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 37) To Operator #40 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q130.$C0 42) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000881053 Cumulative CPU Cost: 3669.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000881053 Cumulative Re-CPU Cost: 3669.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00087385 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 39) From Operator #43 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q121.$C0 42) From Operator #44 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q118.$C0 Output Streams: -------------- 43) To Operator #40 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q122.$C1+Q122.$C0 43) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000219699 Cumulative CPU Cost: 915 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000219699 Cumulative Re-CPU Cost: 915 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000212496 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 102) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (Q147.$C3 = 1) Input Streams: ------------- 38) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 39) To Operator #42 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q121.$C0 44) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 99) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 41) From Operator #45 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 42) To Operator #42 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q118.$C0 45) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 40) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 41) To Operator #44 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 46) FILTER: (Filter) Cumulative Total Cost: 0.00161251 Cumulative CPU Cost: 6715.78 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00161251 Cumulative Re-CPU Cost: 6715.78 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00161251 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 98) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 50) From Operator #47 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q128.$C1+Q128.$C0 Output Streams: -------------- 51) To Operator #39 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q128.$C1+Q128.$C0 47) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000987731 Cumulative CPU Cost: 4113.69 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000987731 Cumulative Re-CPU Cost: 4113.69 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000976424 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 46) From Operator #48 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q127.$C0 49) From Operator #49 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q125.$C0 Output Streams: -------------- 50) To Operator #46 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 97 Column Names: ------------ +Q128.$C1+Q128.$C0 48) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 109) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 45) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 46) To Operator #47 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q127.$C0 49) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 105) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 48) From Operator #50 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 49) To Operator #47 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 97 Column Names: ------------ +Q125.$C0 50) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 47) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 48) To Operator #49 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 51) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 53) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 54) To Operator #38 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 97 52) TBSCAN: (Table Scan) Cumulative Total Cost: 2.16097e-05 Cumulative CPU Cost: 90 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.16097e-05 Cumulative Re-CPU Cost: 90 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 55) From Object SYSIBM.TFCALL Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 97 Output Streams: -------------- 56) To Operator #38 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 97 53) FILTER: (Filter) Cumulative Total Cost: 0.00862269 Cumulative CPU Cost: 35911.7 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0013338 Cumulative Re-CPU Cost: 5555 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00862269 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 47) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 65) From Operator #54 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q102.STATE+Q102.RETURN+Q102.RETURN_STATUS +Q102.CALLVAL+Q102.RETVAL 67) From Operator #55 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 47 105) From Operator #56 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 106) To Operator #21 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q104.RETURN 54) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 64) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 Output Streams: -------------- 65) To Operator #53 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q102.STATE+Q102.RETURN+Q102.RETURN_STATUS +Q102.CALLVAL+Q102.RETVAL 55) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 66) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 67) To Operator #53 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 47 56) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0069438 Cumulative CPU Cost: 28919.5 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00363161 Cumulative Re-CPU Cost: 15124.9 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0069438 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 50) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 76) From Operator #57 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 47 Column Names: ------------ +Q69.$C1+Q69.$C0+Q99.$C0 104) From Operator #63 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q97.$C1+Q97.$C0 Output Streams: -------------- 105) To Operator #53 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 47 57) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00154634 Cumulative CPU Cost: 6440.18 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00154634 Cumulative Re-CPU Cost: 6440.18 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00142115 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 69) From Operator #58 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q99.$C0 75) From Operator #59 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q69.$C1+Q69.$C0 Output Streams: -------------- 76) To Operator #56 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 47 Column Names: ------------ +Q69.$C1+Q69.$C0+Q99.$C0 58) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 68) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 69) To Operator #57 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q99.$C0 59) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0010903 Cumulative CPU Cost: 4540.89 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0010903 Cumulative Re-CPU Cost: 4540.89 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001079 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 71) From Operator #60 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q68.$C0 74) From Operator #61 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q65.$C0 Output Streams: -------------- 75) To Operator #57 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q69.$C1+Q69.$C0 60) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000424848 Cumulative CPU Cost: 1769.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000424848 Cumulative Re-CPU Cost: 1769.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000417644 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 55) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_FUNC$() IS NULL Input Streams: ------------- 70) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 71) To Operator #59 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q68.$C0 61) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 51) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 73) From Operator #62 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 74) To Operator #59 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q65.$C0 62) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 72) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 73) To Operator #61 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 47 63) FILTER: (Filter) Cumulative Total Cost: 0.00539746 Cumulative CPU Cost: 22479.3 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00208527 Cumulative Re-CPU Cost: 8684.71 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00539746 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 50) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 103) From Operator #64 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q97.$C1+Q97.$C0 Output Streams: -------------- 104) To Operator #56 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q97.$C1+Q97.$C0 64) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00477268 Cumulative CPU Cost: 19877.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00146049 Cumulative Re-CPU Cost: 6082.62 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00476137 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 78) From Operator #65 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q96.$C0 102) From Operator #66 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q94.$C0 Output Streams: -------------- 103) To Operator #63 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 47 Column Names: ------------ +Q97.$C1+Q97.$C0 65) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 81) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 77) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 78) To Operator #64 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q96.$C0 66) FILTER: (Filter) Cumulative Total Cost: 0.00423261 Cumulative CPU Cost: 17627.9 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000920415 Cumulative Re-CPU Cost: 3833.33 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00423261 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 57) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 101) From Operator #67 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 47 Output Streams: -------------- 102) To Operator #64 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 47 Column Names: ------------ +Q94.$C0 67) TBSCAN: (Table Scan) Cumulative Total Cost: 0.00419699 Cumulative CPU Cost: 17479.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000884799 Cumulative Re-CPU Cost: 3685 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00418979 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 58) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 79) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 47 96) From Operator #68 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 58 98) From Operator #80 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 100) From Operator #81 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 101) To Operator #66 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 47 68) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0029455 Cumulative CPU Cost: 12267.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0029455 Cumulative Re-CPU Cost: 12267.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0029455 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 59) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 88) From Operator #69 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 58 Column Names: ------------ +Q77.$C1+Q77.$C0+Q85.$C0 95) From Operator #75 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q83.$C1+Q83.$C0 Output Streams: -------------- 96) To Operator #67 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 58 69) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00133299 Cumulative CPU Cost: 5551.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00133299 Cumulative Re-CPU Cost: 5551.6 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001216 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 81) From Operator #70 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q85.$C0 87) From Operator #71 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q77.$C1+Q77.$C0 Output Streams: -------------- 88) To Operator #68 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 58 Column Names: ------------ +Q77.$C1+Q77.$C0+Q85.$C0 70) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 80) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 81) To Operator #69 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q85.$C0 71) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000881053 Cumulative CPU Cost: 3669.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000881053 Cumulative Re-CPU Cost: 3669.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00087385 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 83) From Operator #72 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q76.$C0 86) From Operator #73 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q73.$C0 Output Streams: -------------- 87) To Operator #69 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q77.$C1+Q77.$C0 72) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000219699 Cumulative CPU Cost: 915 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000219699 Cumulative Re-CPU Cost: 915 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000212496 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 63) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (Q102.$C3 = 1) Input Streams: ------------- 82) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 83) To Operator #71 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q76.$C0 73) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 60) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 85) From Operator #74 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 86) To Operator #71 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q73.$C0 74) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 84) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 85) To Operator #73 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 75) FILTER: (Filter) Cumulative Total Cost: 0.00161251 Cumulative CPU Cost: 6715.78 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00161251 Cumulative Re-CPU Cost: 6715.78 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00161251 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 59) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 94) From Operator #76 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q83.$C1+Q83.$C0 Output Streams: -------------- 95) To Operator #68 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q83.$C1+Q83.$C0 76) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000987731 Cumulative CPU Cost: 4113.69 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000987731 Cumulative Re-CPU Cost: 4113.69 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000976424 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 90) From Operator #77 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q82.$C0 93) From Operator #78 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q80.$C0 Output Streams: -------------- 94) To Operator #75 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 58 Column Names: ------------ +Q83.$C1+Q83.$C0 77) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 70) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 89) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 90) To Operator #76 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q82.$C0 78) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 66) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 92) From Operator #79 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 93) To Operator #76 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 58 Column Names: ------------ +Q80.$C0 79) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 91) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 92) To Operator #78 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 80) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 97) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 98) To Operator #67 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 58 81) TBSCAN: (Table Scan) Cumulative Total Cost: 2.16097e-05 Cumulative CPU Cost: 90 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.16097e-05 Cumulative Re-CPU Cost: 90 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 99) From Object SYSIBM.TFCALL Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 58 Output Streams: -------------- 100) To Operator #67 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 58 82) FILTER: (Filter) Cumulative Total Cost: 0.00862269 Cumulative CPU Cost: 35911.7 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0013338 Cumulative Re-CPU Cost: 5555 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00862269 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 8) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 109) From Operator #83 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q57.STATE+Q57.RETURN+Q57.RETURN_STATUS +Q57.CALLVAL+Q57.RETVAL 111) From Operator #84 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 8 149) From Operator #85 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 150) To Operator #20 Estimated number of rows: 0.333333 Number of columns: 1 Subquery predicate ID: 5 Column Names: ------------ +Q59.RETURN 83) TBSCAN: (Table Scan) Cumulative Total Cost: 2.8813e-05 Cumulative CPU Cost: 120 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.8813e-05 Cumulative Re-CPU Cost: 120 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 108) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 5 Output Streams: -------------- 109) To Operator #82 Estimated number of rows: 1 Number of columns: 5 Subquery predicate ID: 5 Column Names: ------------ +Q57.STATE+Q57.RETURN+Q57.RETURN_STATUS +Q57.CALLVAL+Q57.RETVAL 84) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 110) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 111) To Operator #82 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 8 85) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0069438 Cumulative CPU Cost: 28919.5 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00363161 Cumulative Re-CPU Cost: 15124.9 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0069438 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 11) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 120) From Operator #86 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 8 Column Names: ------------ +Q24.$C1+Q24.$C0+Q54.$C0 148) From Operator #92 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q52.$C1+Q52.$C0 Output Streams: -------------- 149) To Operator #82 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 8 86) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00154634 Cumulative CPU Cost: 6440.18 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00154634 Cumulative Re-CPU Cost: 6440.18 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00142115 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 113) From Operator #87 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q54.$C0 119) From Operator #88 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q24.$C1+Q24.$C0 Output Streams: -------------- 120) To Operator #85 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 8 Column Names: ------------ +Q24.$C1+Q24.$C0+Q54.$C0 87) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 112) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 113) To Operator #86 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q54.$C0 88) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0010903 Cumulative CPU Cost: 4540.89 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0010903 Cumulative Re-CPU Cost: 4540.89 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001079 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 115) From Operator #89 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q23.$C0 118) From Operator #90 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q20.$C0 Output Streams: -------------- 119) To Operator #86 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q24.$C1+Q24.$C0 89) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000424848 Cumulative CPU Cost: 1769.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000424848 Cumulative Re-CPU Cost: 1769.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000417644 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 16) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_FUNC$() IS NULL Input Streams: ------------- 114) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 115) To Operator #88 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q23.$C0 90) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 12) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 117) From Operator #91 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 118) To Operator #88 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q20.$C0 91) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 116) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 117) To Operator #90 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 8 92) FILTER: (Filter) Cumulative Total Cost: 0.00539746 Cumulative CPU Cost: 22479.3 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00208527 Cumulative Re-CPU Cost: 8684.71 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00539746 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 11) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 147) From Operator #93 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q52.$C1+Q52.$C0 Output Streams: -------------- 148) To Operator #85 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q52.$C1+Q52.$C0 93) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00477268 Cumulative CPU Cost: 19877.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00146049 Cumulative Re-CPU Cost: 6082.62 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00476137 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 122) From Operator #94 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q51.$C0 146) From Operator #95 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q49.$C0 Output Streams: -------------- 147) To Operator #92 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 8 Column Names: ------------ +Q52.$C1+Q52.$C0 94) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 42) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 121) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 122) To Operator #93 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q51.$C0 95) FILTER: (Filter) Cumulative Total Cost: 0.00423261 Cumulative CPU Cost: 17627.9 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000920415 Cumulative Re-CPU Cost: 3833.33 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00423261 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 18) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 145) From Operator #96 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 8 Output Streams: -------------- 146) To Operator #93 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 8 Column Names: ------------ +Q49.$C0 96) TBSCAN: (Table Scan) Cumulative Total Cost: 0.00419699 Cumulative CPU Cost: 17479.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000884799 Cumulative Re-CPU Cost: 3685 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00418979 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 19) Residual Predicate, Evaluate at Application Subquery Comparison Operator: Less Than (<) Subquery Input Required: Yes Filter Factor: 0.333333 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 123) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 8 140) From Operator #97 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 19 142) From Operator #109 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 144) From Operator #110 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 145) To Operator #95 Estimated number of rows: 0.333333 Number of columns: 0 Subquery predicate ID: 8 97) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.0029455 Cumulative CPU Cost: 12267.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.0029455 Cumulative Re-CPU Cost: 12267.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.0029455 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Predicates: ---------- 20) Predicate used in Join Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 132) From Operator #98 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 19 Column Names: ------------ +Q32.$C1+Q32.$C0+Q40.$C0 139) From Operator #104 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q38.$C1+Q38.$C0 Output Streams: -------------- 140) To Operator #96 Estimated number of rows: 0.0384 Number of columns: 0 Subquery predicate ID: 19 98) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.00133299 Cumulative CPU Cost: 5551.6 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00133299 Cumulative Re-CPU Cost: 5551.6 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.001216 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) OUTER Input Streams: ------------- 125) From Operator #99 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q40.$C0 131) From Operator #100 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q32.$C1+Q32.$C0 Output Streams: -------------- 132) To Operator #97 Estimated number of rows: 0.96 Number of columns: 3 Subquery predicate ID: 19 Column Names: ------------ +Q32.$C1+Q32.$C0+Q40.$C0 99) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 124) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 125) To Operator #98 Estimated number of rows: 0.96 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q40.$C0 100) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000881053 Cumulative CPU Cost: 3669.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000881053 Cumulative Re-CPU Cost: 3669.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00087385 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE JN INPUT: (Join input leg) INNER Input Streams: ------------- 127) From Operator #101 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q31.$C0 130) From Operator #102 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q28.$C0 Output Streams: -------------- 131) To Operator #98 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q32.$C1+Q32.$C0 101) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000219699 Cumulative CPU Cost: 915 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000219699 Cumulative Re-CPU Cost: 915 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000212496 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 24) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (Q57.$C3 = 1) Input Streams: ------------- 126) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 127) To Operator #100 Estimated number of rows: 2.23517e-10 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q31.$C0 102) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 21) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 129) From Operator #103 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 130) To Operator #100 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q28.$C0 103) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 128) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 129) To Operator #102 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 104) FILTER: (Filter) Cumulative Total Cost: 0.00161251 Cumulative CPU Cost: 6715.78 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.00161251 Cumulative Re-CPU Cost: 6715.78 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00161251 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 20) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 138) From Operator #105 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q38.$C1+Q38.$C0 Output Streams: -------------- 139) To Operator #97 Estimated number of rows: 0.04 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q38.$C1+Q38.$C0 105) NLJOIN: (Nested Loop Join) Cumulative Total Cost: 0.000987731 Cumulative CPU Cost: 4113.69 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000987731 Cumulative Re-CPU Cost: 4113.69 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000976424 Estimated Bufferpool Buffers: 0 Arguments: --------- EARLYOUT: (Early Out flag) NONE FETCHMAX: (Override for FETCH MAXPAGES) IGNORE ISCANMAX: (Override for ISCAN MAXPAGES) IGNORE Input Streams: ------------- 134) From Operator #106 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q37.$C0 137) From Operator #107 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q35.$C0 Output Streams: -------------- 138) To Operator #104 Estimated number of rows: 1 Number of columns: 2 Subquery predicate ID: 19 Column Names: ------------ +Q38.$C1+Q38.$C0 106) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000322273 Cumulative CPU Cost: 1342.2 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000322273 Cumulative Re-CPU Cost: 1342.2 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.00031507 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) OUTER MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Predicates: ---------- 31) Residual Predicate Comparison Operator: Is Null Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- $INTERNAL_PRED$ Input Streams: ------------- 133) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 134) To Operator #105 Estimated number of rows: 0.0384 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q37.$C0 107) FILTER: (Filter) Cumulative Total Cost: 0.000447658 Cumulative CPU Cost: 1864.4 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000447658 Cumulative Re-CPU Cost: 1864.4 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000447658 Estimated Bufferpool Buffers: 0 Arguments: --------- JN INPUT: (Join input leg) INNER Predicates: ---------- 27) Residual Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 2.32831e-10 Predicate Text: -------------- (1 = 0) Input Streams: ------------- 136) From Operator #108 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 137) To Operator #105 Estimated number of rows: 1 Number of columns: 1 Subquery predicate ID: 19 Column Names: ------------ +Q35.$C0 108) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 135) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 136) To Operator #107 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 109) TBSCAN: (Table Scan) Cumulative Total Cost: 0.000135661 Cumulative CPU Cost: 565 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 0.000135661 Cumulative Re-CPU Cost: 565 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 0.000128458 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 141) From Object SYSIBM.GENROW Estimated number of rows: 1 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 142) To Operator #96 Estimated number of rows: 0.96 Number of columns: 0 Subquery predicate ID: 19 110) TBSCAN: (Table Scan) Cumulative Total Cost: 2.16097e-05 Cumulative CPU Cost: 90 Cumulative I/O Cost: 0 Cumulative Re-Total Cost: 2.16097e-05 Cumulative Re-CPU Cost: 90 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 2.16097e-05 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE ROWLOCK : (Row Lock intent) NEXT KEY SHARE SCANDIR : (Scan Direction) FORWARD TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY Input Streams: ------------- 143) From Object SYSIBM.TFCALL Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 19 Output Streams: -------------- 144) To Operator #96 Estimated number of rows: 0 Number of columns: 0 Subquery predicate ID: 19 111) TBSCAN: (Table Scan) Cumulative Total Cost: 19.9541 Cumulative CPU Cost: 277155 Cumulative I/O Cost: 1.96 Cumulative Re-Total Cost: 12.6434 Cumulative Re-CPU Cost: 55877.6 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 19.9541 Estimated Bufferpool Buffers: 1 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) 1 PREFETCH: (Type of Prefetch) NONE SCANDIR : (Scan Direction) FORWARD Predicates: ---------- 130) Sargable Predicate Comparison Operator: Equal (=) Subquery Input Required: No Filter Factor: 0.04 Predicate Text: -------------- (1 = CASE WHEN NOT(Q155.$C0 IN (0, 1)) THEN $INTERNAL_FUNC$() WHEN (CASE WHEN ($INTERNAL_FUNC$() IS NULL OR 4 IS NULL) THEN NULL WHEN ((((LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> LENGTH($INTERNAL_FUNC$())) OR (LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> 4)) OR (BIGINT($INTERNAL_FUNC$()) < 0)) OR (BIGINT($INTERNAL_FUNC$()) >= POWER(10, 4))) THEN 0 ELSE 1 END <> 1) THEN $INTERNAL_FUNC$() WHEN (CASE WHEN ($INTERNAL_FUNC$() IS NULL OR 10 IS NULL) THEN NULL WHEN ((((LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> LENGTH($INTERNAL_FUNC$())) OR (LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> 10)) OR (BIGINT($INTERNAL_FUNC$()) < 0)) OR (BIGINT($INTERNAL_FUNC$()) >= POWER(10, 10))) THEN 0 ELSE 1 END <> 1) THEN $INTERNAL_FUNC$() WHEN (CASE WHEN ($INTERNAL_FUNC$() IS NULL OR 4 IS NULL) THEN NULL WHEN ((((LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> LENGTH($INTERNAL_FUNC$())) OR (LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> 4)) OR (BIGINT($INTERNAL_FUNC$()) < 0)) OR (BIGINT($INTERNAL_FUNC$()) >= POWER(10, 4))) THEN 0 ELSE 1 END <> 1) THEN $INTERNAL_FUNC$() WHEN (CASE WHEN ($INTERNAL_FUNC$() IS NULL OR 4 IS NULL) THEN NULL WHEN ((((LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> LENGTH($INTERNAL_FUNC$())) OR (LENGTH(LTRIM(RTRIM($INTERNAL_FUNC$()))) <> 4)) OR (BIGINT($INTERNAL_FUNC$()) < 0)) OR (BIGINT($INTERNAL_FUNC$()) >= POWER(10, 4))) THEN 0 ELSE 1 END <> 1) THEN $INTERNAL_FUNC$() ELSE 0 END) Input Streams: ------------- 158) From Operator #6 Estimated number of rows: 0.0384 Number of columns: 15 Subquery predicate ID: 4 Column Names: ------------ +Q152.$C14+Q152.$C13+Q152.$C12+Q152.$C11 +Q152.$C10+Q152.$C9+Q152.$C0+Q152.$C1+Q152.$C2 +Q152.$C3+Q152.$C4+Q152.$C5+Q152.$C6+Q152.$C7 +Q152.$C8 Output Streams: -------------- 159) To Operator #4 Estimated number of rows: 0.00147456 Number of columns: 0 Subquery predicate ID: 4 Objects Used in Access Plan: --------------------------- Schema: SCHE_UTIL Name: IMPORT_VIEW_1 Type: View (reference only) Schema: SYSIBM Name: SQL080208110659050 Type: Index Schema: SCHE_PROD Name: TARGET_TABLE_1 Type: Table Schema: SCHE_UTIL Name: STAGING_TABLE_1 Type: Table Schema: GLOBALSYS Name: PASSWORDS Type: Table Schema: SYSIBM Name: GENROW Type: Table Function Schema: SYSIBM Name: TFCALL Type: Table Function Extended Statistics Information: -------------------------------- Tablespace Context: ------------------- Name: TBSPNAM Overhead: 12.500000 Transfer Rate: 0.130000 Prefetch Size: 64 Extent Size: 64 Type: Database managed Partition Group Name: NULLP Buffer Pool Identifier: 0 Name: USERSPACE1 Overhead: 7.500000 Transfer Rate: 0.060000 Prefetch Size: 32 Extent Size: 32 Type: Database managed Partition Group Name: NULLP Buffer Pool Identifier: 0 Function Statistics: -------------------- Name: CHKSTR_TSTAMP_ Schema: FGR Number of IOs per Invocation: 0.000000 Number of Instructions per Invocation: 445.000000 Number of IOs per Input Arg Byte: 0.000000 Number of Instructions per Input Arg Byte: 0.000000 Number of IOs first/last Invocation: 0.000000 Number of Instructions first/last Invocation: 0.000000 Avg Percent of Input Arg Bytes: 0 Type: UNKNOWN Base Table Statistics: ---------------------- Name : STAGING_TABLE_1 Schema: SCHE_UTIL Number of Columns: 9 Number of Pages with Rows: 113681 Number of Pages: 113681 Number of Rows: 8637702 Table Overflow Record Count: 0 Width of Rows: 102 Time of Creation: 2008-05-22-01.55.40.346151 Last Statistics Update: 2008-05-22-06.28.23.157882 Primary Tablespace: TBSPNAM Tablespace for Indexes: NULLP Tablespace for Long Data: NULLP Number of Referenced Columns: 9 Number of Indexes: 0 Volatile Table: No Number of Active Blocks: -1 Number of Column Groups: 0 Number of Data Partitions: 1 Average Row Compression Ratio: -1.000000 Percent Rows Compressed: -1.000000 Average Compressed Row Size: -1 Statistics Type: A Column Information: -------------------- Number: 9 Name: B_DOK Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 6 Scale for decimal column: 0 Number of distinct column values: 2 Average column length: 7 Number of most frequent values: 2 Number of quantiles: 4 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 8 Name: R_TS_DOK Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 12 Scale for decimal column: 0 Number of distinct column values: 1100262 Average column length: 13 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 7 Name: COLNAME2 Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 4 Scale for decimal column: 0 Number of distinct column values: 2400 Average column length: 5 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 6 Name: COLNAME1 Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: VARCHAR Maximum column length: 20 Scale for decimal column: 0 Number of distinct column values: 38912 Average column length: 25 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 5 Name: DT_STRING Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 12 Scale for decimal column: 0 Number of distinct column values: 99328 Average column length: 13 Number of most frequent values: 10 Number of quantiles: 10 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 4 Name: SOMECHARCODE1 Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 4 Scale for decimal column: 0 Number of distinct column values: 992 Average column length: 5 Number of most frequent values: 8 Number of quantiles: 10 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 3 Name: R_TS_AJOUR Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 12 Scale for decimal column: 0 Number of distinct column values: 1311520 Average column length: 13 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 2 Name: SOMECHARCODES Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 4 Scale for decimal column: 0 Number of distinct column values: 2784 Average column length: 5 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: ------------------------------- [removed for privacy reasons] Column Information: -------------------- Number: 1 Name: V_ID Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: CHARACTER Maximum column length: 10 Scale for decimal column: 0 Number of distinct column values: 8637702 Average column length: 10 Number of most frequent values: 10 Number of quantiles: 20 [removed for privacy reasons] Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Distribution Statistics: [removed for privacy reasons] Table Function Statistics: -------------------------- Name : GENROW Schema: SYSIBM Type: System table function Number of Columns: 1 Number of Pages with Rows: -1 Width of Rows: 11 Primary Tablespace Name: NULLP Base Table Statistics: ---------------------- Name : PASSWORDS Schema: GLOBALSYS Number of Columns: 2 Number of Pages with Rows: 1 Number of Pages: 1 Number of Rows: 1 Table Overflow Record Count: 0 Width of Rows: 42 Time of Creation: 2008-02-08-11.06.58.331730 Last Statistics Update: 2008-04-24-02.28.56.898828 Primary Tablespace: USERSPACE1 Tablespace for Indexes: USERSPACE1 Tablespace for Long Data: NULLP Number of Referenced Columns: 2 Number of Indexes: 1 Volatile Table: No Number of Active Blocks: -1 Number of Column Groups: 0 Number of Data Partitions: 1 Average Row Compression Ratio: -1.000000 Percent Rows Compressed: -1.000000 Average Compressed Row Size: -1 Statistics Type: A Column Information: -------------------- Number: 2 Name: PW Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: VARCHAR Maximum column length: 100 Scale for decimal column: 0 Number of distinct column values: 1 Average column length: 22 Number of most frequent values: -1 Number of quantiles: -1 Second highest data value: NULLP Second lowest data value: NULLP Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Column Information: -------------------- Number: 1 Name: PURPOSE Statistics Available: Yes Column Statistics: ------------------ Schema name of the column type: SYSIBM Name of column type: VARCHAR Maximum column length: 30 Scale for decimal column: 0 Number of distinct column values: 1 Average column length: 14 Number of most frequent values: -1 Number of quantiles: -1 Second highest data value: NULLP Second lowest data value: NULLP Column sequence in partition key: 0 Average number of sub-elements: -1 Average length of delimiters: -1 Indexes defined on the table: ----------------------------- Name : SQL080208110659050 Schema: SYSIBM Unique Rule: Primary key index Used in Operator: Yes Page Fetch Pairs: Not Available Number of Columns: 1 Index Leaf Pages: 1 Index Tree Levels: 1 Index First Key Cardinality: 1 Index Full Key Cardinality: 1 Index Cluster Ratio: 100 Index Cluster Factor: -1.000000 Time of Creation: 2008-02-08-11.06.59.024403 Last Statistics Update: 2008-04-24-02.28.56.898828 Index Sequential Pages: 0 Index First 2 Keys Cardinality: -1 Index First 3 Keys Cardinality: -1 Index First 4 Keys Cardinality: -1 Index Avg Gap between Sequences: 0.000000 Fetch Avg Gap between Sequences: -1.000000 Index Avg Sequential Pages: 0.000000 Fetch Avg Sequential Pages: -1.000000 Index Avg Random Pages: 1.000000 Fetch Avg Random Pages: -1.000000 Index RID Count: 1 Index Deleted RID Count: 0 Index Empty Leaf Pages: 0 Avg Partition Cluster Ratio: -1 Avg Partition Cluster Factor: -1.000000 Data Partition Cluster Factor: 1.000000 Data Partition Page Fetch Pairs: Not Available Table Function Statistics: -------------------------- Name : TFCALL Schema: SYSIBM Type: System table function Number of Columns: 0 Number of Pages with Rows: -1 Width of Rows: 6 Primary Tablespace Name: NULLP