zOs/SQL/PDBSPACE

with sDay as                                      -- Gruppierung pro Tag
  ( select -- db_name db, ts_name ts,
           datum, sum(hi_u_rba) b
        from OA1P.TADM09A1
                              --->>> DB und oder TS selektieren
        where DB_NAME = 'DWB03' -- and TS_NAME = 'A704A'
                              --->>> Zeitraum selektieren
            and datum >= '01.01.2007'
        group by datum -- ,db_name, ts_name
  ),
sInt as                                      -- Gruppierung pro Interval
  ( select -- db, ts,
           max(datum) datum, max(b) b
      from sDay
      group by -- db, ts
                              --->>> Tages Interval selektieren
            floor(days(datum) / 7)
                              --->>> oder Monats Interval selektieren
         -- year(datum), floor((month(datum)-1) / 2)
  ),
sMax as                                  -- Maximum Wert für Darstellung
  ( select max(b) b from sDay)
select -- char(strip(sInt.db)||'.'||strip(sInt.ts),21) "db.ts",
       sInt.b "bytes",
       datum "datum",
       repeat('*', int(round(sInt.b * 40 / sMax.b, 0)))
    from sInt, sMax
    order by datum desc