zOs/TX/PER12EXP

set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_PREDICAT_TABLE;
delete from A540769.DSN_FILTER_TABLE;
explain plan set queryno = 1   for
  select * from A540769.tper12 where i1=? and ? = i2 ;
explain plan set queryno = 2   for
  select * from A540769.tper12 where j1=? and j2 = ?;
explain plan set queryno = 3   for
  select * from A540769.tper12 where k1=? and k2 = ?;
explain plan set queryno = 4   for
  select * from A540769.tper12 where l1=? and l2 = ?;
explain plan set queryno = 11  for
  select * from A540769.tper12 where i1=? and i2 in (?, ?, ?);
explain plan set queryno = 12   for
  select * from A540769.tper12 where j1=? and j2 in (?, ?, ?);
explain plan set queryno = 13   for
  select * from A540769.tper12 where k1=? and k2 in (?, ?, ?);
explain plan set queryno = 14   for
  select * from A540769.tper12 where l1=? and l2 in (?, ?, ?);
select * from  plan_view1
    order by applname, progname, queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_viewPred
    order by collid, progName, applName, explain_time,
             queryNo, qBlockNo, planno,
             stage, predno
;
commit