zOs/SQL/EXPLMAT

delete from plan_table where queryno = 999
;
   set current refresh age = any;
   select current refresh age from sysibm.sysdummy1;
explain plan set queryno = 999 for
    SELECT NI920001
       , NI920002
       , NI920003
       , COUNT(*) COUNT
       , SUM(CASE WHEN NI920005 ='U' THEN 1 ELSE 0 END) URVRS
       , SUM(CASE WHEN NI920005 ='S' THEN 1 ELSE 0 END) SRVS
       , SUM(CASE WHEN NI920005 ='E' THEN 1 ELSE 0 END) ERRS
       , SUM(CASE WHEN NI920005 ='W' THEN 1 ELSE 0 END) WARNS
       , SUM(CASE WHEN NI920005 ='I' THEN 1 ELSE 0 END) INFOS
       FROM gdb0237.TNI920A101A
         WHERE NI920001='20070511'
       GROUP BY NI920001
       , NI920002
       , NI920003
;
select * from plan_view5
    where queryno = 999
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;
x
select * from plan_table
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;