zOs/SQL/EXPLAIU3

--- 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 value(sum(xx.a_lndng_vle_rep),0)
     from

    (select distinct a.a_lndng_vle_rep as a_lndng_vle_rep
          , a.i_id_cltrl as i_id_cltrl
     from   oa1t.tui200a1 a
        ,   oa1t.tui310a1 b
     where a.i_id_unit   = ?
     and   a.i_id_unit   = b.i_id_unit
     and   a.i_id_cltrl  = b.i_id_cltrl
     and   a.i_id_cstmr  = ?
     and   a.i_id_cstmr ^= b.i_id_cstmr_crdt) as xx
;
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
;;;;