zOs/SQL/EXPLA5CM

set current sqlId = 'A540769';
delete from  plan_table where queryno in (3, 4) ;
explain plan set queryno = 3 for
select * from SSXX28Q0.VIEW_EVENTS     ;
explain plan set queryno = 7 for
select * from SSXX28Q0.VIEW_EVENTS  WHERE DATA_SMNM = 'WI0100' ;
select p.* from   plan_view2 p
   -- where queryno in (3, 4)
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;
select current timestamp from sysibm.sysdummy1;
select * from SSXX28Q0.VIEW_EVENTS  WHERE DATA_SMNM = 'WI0100' ;
select current timestamp from sysibm.sysdummy1;