zOs/WK/MF160NEX

--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table  ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 3   for
 SELECT
 HEX(MF150001), MF150022, MF150023, MF150064, SUBSTR(MF150066,9,7),
 MF150004, MF150059, MF150013, CHAR(MF150083), CHAR(MF150084),
 CHAR(MF150085), MF150011, MF150030, MF150031, MF150028, MF150029,
 MF150079, MF150017, MF150044, MF150009, ' ', MF150042, CHAR(MF150043),
 MF150016, CHAR(MF150018), CHAR(MF150019), MF150055, CHAR(MF150053),
 MF150035, MF150036, MF150038, MF150041, MF150040, MF150014, MF150015,
 ' ', MF150001, MF150003, MF150008, MF150084, MF150085
 FROM oa1p.TMF150A1
 JOIN oa1p.TMF160A1 ON (id_mittelfluss = MF150001
                   and effektiv_datum between ?
                                      and     ?)
 WHERE MF150022 BETWEEN ? AND ?
 AND   MF150023 BETWEEN ? AND ?
 AND   MF150085 BETWEEN 0 AND 90
   AND   NOT (MF150029 = '130'
         OR MF150028 IN ('680', '681', '682', '700', '701',
                         '702', '710', '711', '712', '720', '721',
                         '722', '730', '731', '732', '938', '939'))
 AND   MF150019 <> 0
 WITH UR
 ;
explain plan set queryno = 5   for
 SELECT
 HEX(MF150001), MF150022, MF150023, MF150064, SUBSTR(MF150066,9,7),
 MF150004, MF150059, MF150013, CHAR(MF150083), CHAR(MF150084),
 CHAR(MF150085), MF150011, MF150030, MF150031, MF150028, MF150029,
 MF150079, MF150017, MF150044, MF150009, ' ', MF150042, CHAR(MF150043),
 MF150016, CHAR(MF150018), CHAR(MF150019), MF150055, CHAR(MF150053),
 MF150035, MF150036, MF150038, MF150041, MF150040, MF150014, MF150015,
 ' ', MF150001, MF150003, MF150008, MF150084, MF150085
 FROM oa1p.TMF150A1
 JOIN oa1p.TMF160A1 ON (id_mittelfluss = MF150001
                   and effektiv_datum between '15.02.2012'
                                      and     '16.02.2012' )
 WHERE MF150022 BETWEEN ? AND ?
 AND   MF150023 BETWEEN ? AND ?
 AND   MF150085 BETWEEN 0 AND 90
   AND   NOT (MF150029 = '130'
         OR MF150028 IN ('680', '681', '682', '700', '701',
                         '702', '710', '711', '712', '720', '721',
                         '722', '730', '731', '732', '938', '939'))
 AND   MF150019 <> 0
 WITH UR
 ;
explain plan set queryno = 9   for
 SELECT
 HEX(MF150001), MF150022, MF150023, MF150064, SUBSTR(MF150066,9,7),
 MF150004, MF150059, MF150013, CHAR(MF150083), CHAR(MF150084),
 CHAR(MF150085), MF150011, MF150030, MF150031, MF150028, MF150029,
 MF150079, MF150017, MF150044, MF150009, ' ', MF150042, CHAR(MF150043),
 MF150016, CHAR(MF150018), CHAR(MF150019), MF150055, CHAR(MF150053),
 MF150035, MF150036, MF150038, MF150041, MF150040, MF150014, MF150015,
 ' ', MF150001, MF150003, MF150008, MF150084, MF150085
 FROM oa1p.TMF150A1
 JOIN oa1p.TMF160A1 ON (id_mittelfluss = MF150001
                   and effektiv_datum between '15.01.2012'
                                      and     '14.02.2012' )
 WHERE MF150022 BETWEEN ? AND ?
 AND   MF150023 BETWEEN ? AND ?
 AND   MF150085 BETWEEN 0 AND 90
   AND   NOT (MF150029 = '130'
         OR MF150028 IN ('680', '681', '682', '700', '701',
                         '702', '710', '711', '712', '720', '721',
                         '722', '730', '731', '732', '938', '939'))
 AND   MF150019 <> 0
 WITH UR
 ;
select * from  plan_view1
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by --collid, progName, applName, explain_time,
             queryNo, qBlockNo, planno,
             stage, predNo
    with ur
;
rollback
;;;;