zOs/TX/PER13EXP

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.tper13 where i1=? and ? = i2 ;
explain plan set queryno = 2   for
  select * from A540769.tper13 where i1=? and j2 = ?;
explain plan set queryno = 3   for
  select * from A540769.tper13 where i1=? and k2 = ?;
explain plan set queryno = 4   for
  select * from A540769.tper13 where i1=? and l2 = ?;
explain plan set queryno = 5   for
  select * from A540769.tper13 where i1=? and m2 = ?;
explain plan set queryno = 6   for
  select * from A540769.tper13 where i1=? and n2 = ?;
explain plan set queryno = 7   for
  select * from A540769.tper13 where i1=? and o2 = ?;
explain plan set queryno = 11  for
  select * from A540769.tper13 where i1=? and i2 in (?, ?, ?);
explain plan set queryno = 12   for
  select * from A540769.tper13 where i1=? and j2 in (?, ?, ?);
explain plan set queryno = 13   for
  select * from A540769.tper13 where i1=? and k2 in (?, ?, ?);
explain plan set queryno = 14   for
  select * from A540769.tper13 where i1=? and l2 in (?, ?, ?);
explain plan set queryno = 15   for
  select * from A540769.tper13 where i1=? and m2 in (?, ?, ?);
explain plan set queryno = 16   for
  select * from A540769.tper13 where i1=? and n2 in (?, ?, ?);
explain plan set queryno = 17   for
  select * from A540769.tper13 where i1=? and o2 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