zOs/SQL/PDBPEAK

set current path = oa1p;
select trunc_timestamp(timestamp, 'hh'),
       fosFmtE7(sum(CLASS1_CPU_TOTAL/3600 )) "c1cpu",
       fosFmtE7(sum(CLASS2_CPU_TOTAL/3600 )) "c2cpu"
    from rz2hh.tacct_General
    where subsystem_id like 'DOF4%'
       and timestamp > current timestamp -10 days
       and dayofweek_iso(timestamp) <= 5
          AND hour(timestamp) between 9 and 11
    group by trunc_timestamp(timestamp, 'hh')
    order by 1 desc
    with ur
;;;
select trunc_timestamp(timestamp, 'hh'),
       fosFmtE7(sum(CLASS7_CPU_TOTAL/3600 )) "c7cpu"
    from rz2hh.tacct_Program
    where subsystem_id like 'DOF%'
       and timestamp > current timestamp -10 days
       and dayofweek_iso(timestamp) <= 5
          AND hour(timestamp) between 9 and 11
    group by trunc_timestamp(timestamp, 'hh')
    order by 1 desc
    with ur
    ;;;