zOs/SQL/EXPLAIU4

--- 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(TRV400.I_UP          , '***')
        ,value(TRV400.I_ID_UP       , -999999999999999)
        ,value(TRV110.I_PRTNR       , '***')
    --  ,value(TempTab.partnerCSID  , -999999999999999)
    --  ,value(TempTab.reportingDate, '31.12.9999')
        ,value(TRV110.I_ID_RM       , '***')
        ,value(TRV110.I_ID_CSP      , '***')

  from  oa1t.TRV400A1 TRV400

        left outer join oa1t.TRV110A1 TRV110
        on  TRV400.I_UP = TRV110.I_UP
  --    left outer join session.t_reportingData TempTab
  --    on  TRV110.I_PRTNR = TempTab.partnerUUID

  where TRV400.I_UP = ?

  order by 5 asc

  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
;;;;