zOs/SQL/TADM09

select dayOfWeek(datum), Datum, DB_NAME, TS_NAME, PARTITIONS_NR,
       sum(real(HI_U_RBA)) used,
       count(*) cnt
    from OA1T.TADM09A1
    where db_Name = 'DG01A1T' and ts_Name = 'A121A'
        and partitions_nr = 15
    group by  DB_NAME, TS_NAME, PARTITIONS_NR, DATUM
    order by datum desc
    with ur
;elect DB_NAME, TS_NAME, PARTITIONS_NR,
    order by 5     desc
    with ur