zOs/SQL/EXPLAIU1

--- 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  UU612010
       ,UU612020
       ,UU612030
       ,UU612040
       ,UU612050
       ,UU612060
       ,UU612070
       ,UU612080
       ,UU612090
       ,UU612100
       ,UU600040
       ,UU600080
       ,UU600090
       ,UU600100

from oa1t.TUU612A2
   , oa1t.TUU600A2

where  UU612010   =  ?
and    UU612020   =  ?
and    UU612030   =  ?

and    UU600010   =  UU612010
and    UU600020   =  UU612020
and    UU600030   =  UU612030
and    (UU612070 * 30) + UU612080 >= 0
and    UU612050   =  ?

order by UU612070 desc
        ,UU612080 desc
for fetch only
;
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
;;;;