zOs/SQL/CXEXP

--- 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 r.* from oa1p.vqz005RecovLoad r
   where (db = 'QZ01A1P' and ts in (?, ?, ?))
      or (db = ? and ts in (?, ?, ?))
      or (db = ? and ts in (?, ?, ?))
/* join (select unique dbName, tsName, partition
  from sysIbm.sysTablePart tp
  where  (tp.dbName, tp.tsName) in
  (select ts.dbName, ts.name
    from sysIbm.sysTableSpace ts
    where  (ts.dbName, ts.name) in
    (select t.dbName, t.tsName
      from sysIbm.sysTables t
      where t.type not in ('A', 'V') and  (t.creator, t.name) in
      (select vd.bCreator, vd.bName
        from sysIbm.sysViewDep vd
        where  (vd.dCreator, vd.dName) in
        (select v.creator, v.name
          from sysIbm.sysTables v
          where v.type = 'V' and  v.name like 'VQZ%REC%'
  ) ) ) ) ) j
  on r.db = j.dbName and r.ts = j.tsName and r.pa = j.partition
*/  order by db, ts, pa
;
select * from  plan_view1
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by collid, progName, explain_time,
             queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
    with ur
;
rollback
;;;;