zOs/SQL/MF

--- 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;
set current schema = oa1t;
explain plan set queryno = 3   for
 SELECT DISTINCT (A.ID_MITTELFLUSS),A.BUID_KUNDE,A.CIFNUMMER_KUNDE,
     a.KUNDEN_BEZIEHUNGNR,a.AUFTRAGSNUMMER,a.BEWEGUNGSART_Depot,
     A.VALOR,A.VALOREN_SEQUENZNR,A.MF_PRODUKT,A.BUCHUNGSDATUM,A.BUWHR,
     a .ZU_ABFLUSS,a.VOLUMEN_NOM_STCK,a.LIFE_CYCLE_STATUs,
   B.POLICEN_NR
 FROM VMF150A1V A LEFT OUTER JOIN VMF401A1V B
 ON A.ID_MITTELFLUSS = b.UUID
 where a.LIFE_CYCLE_STATUS IN (0, 90)
      AND A.ERSTELLUNGSTIMSTMP BETWEEN '2012-03-23-00.00.00.000000'
      and '2012-05-23-23.59.59.999999' and a.STORNO ^= 'S'
      AND A.BETRAG_BUWHR = 0 WITH UR
 ;
set current schema = A540769;
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
;;;;