zOs/SQL/TECSVEXP

--- 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 rc.* --case when erReD = '' then 'r' when erReU = '' then 'l'
   --   else '?' end fun, rc.*
  from oa1p.vQZ005ConSumLoad  rc
    where    rc.db =   'QZ01A1P' --d rc.ts = 'A005A'--, 'DB2ADMIN')
/*where   (rc.db, rc.ts) 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.name like 'TQZ004%'
   ) )
*/ order by rc.db, rc.ts, rc.pa, rc.inst
;
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
;;;;