zOs/SQL/PDBPKGER

set current path oa1p;
select date(timestamp) date, plan_name
     , fosFmtE7(sum(CLASS7_CPU_TOTAL)/86400) as avCpu
     , fosFmte7(SUM(SQL_STMTS_ISSUED)) stmts
     , fosFmtE7(sum(CLASS7_CPU_TOTAL)) as c7cpu
     , fosFmtE7(sum(CLASS7_SU_CPU )) as c7su
     , fosFmtE7(sum(CLASS7_CPU_TOTAL)
        / max(SUM(SQL_STMTS_ISSUED), 1)) "cpu/stmt"
 FROM RZ2dd.TACCT_PROGRAM
   WHERE TIMESTAMP between '2012-10-12-00.00.00.000000'
                       and '2012-12-19-23.59.00.000000'
                       and pck_id = 'YERSGRI'
 AND GROUP_NAME = 'DBOF'
   group by date(timestamp), plan_name
 order by date(timestamp) desc
 ;x;
select *
 FROM RZ2DD.TACCT_PROGRAM
   WHERE TIMESTAMP between '2012-10-12-00.00.00.000000'
                       and '2012-12-19-23.59.00.000000'
                       and pck_id = 'YERSGRI'
 AND GROUP_NAME = 'DBOF'
 order by timestamp desc, subsystem_id
;x;
select date(timestamp) date
     , fosFmte7(SUM(SQL_STMTS_ISSUED)) stmts
     , fosFmtE7(sum(CLASS7_CPU_TOTAL)) as c7cpu
     , fosFmtE7(sum(CLASS7_SU_CPU )) as c7su
     , fosFmtE7(sum(CLASS7_CPU_TOTAL)
        / max(SUM(SQL_STMTS_ISSUED), 1)) "cpu/stmt"
 FROM RZ2HH.TACCT_PROGRAM
   WHERE TIMESTAMP between '2012-10-12-00.00.00.000000'
                       and '2012-12-19-23.59.00.000000'
                       and pck_id = 'YERSGRI'
 AND GROUP_NAME = 'DBOF'
 and hour(timestamp) in (10,11,14,15)
   group by date(timestamp)
 order by date(timestamp) desc
 ;x;