zOs/TX/QBCDPEXP

--- 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     *
from    oa1p.TCD150A1
where   CD150001 =  'TRACE'
and
( (     CD150002 =  'CLIE'
    and CD150003 =  'NTID'
  )
  or
  (
        CD150002 =  'PID '
    and CD150003 =  '    '
  )
)
and
(    substr(cd150011, 1,  8) = ?
  or substr(cd150011, 1, 10) = ?
)
and     CD150005 <  ?
and     CD150006 >= ?
;
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
;;;;