zOs/SQL/SPCPRT

-- report space realtimestatistics (RTS)
--      group by tablespace and show
--      sum and maximum over partitions
select char(strip(coalesce(s.db, i.db))
                   ||'.'|| coalesce (s.ts, i.ts), 24) "db.ts",
        s.parts, i.parts,
        s.ss "TSsumSpace", s.sm "TSmaxSpace",
        i.ss "IXsumSpace", i.sm "IXmaxSpace",
        s.cnt "TS.cnt", s.minTi, s.maxTi,
        i.cnt "IX.cnt", i.minTi, i.maxTi
    from
        (select dbname db, name ts, max(partition) parts, count(*) cnt,
              sum(float(space) * 1024) ss, max(float(space) * 1024)sm,
              min(updatestatstime) minTi, max(updatestatstime) maxTi
            from sysIbm.tableSpaceStats
            group by dbName, name
        ) s
        left join
        (select t.dbname db, t.tsName ts,
                 max(q.partition) parts, count(*) cnt,
                 sum(float(q.space)* 1024) ss,
                 max(float(q.space)* 1024) sm,
                 min(q.updatestatstime) minTi,
                 max(q.updateStatstime) maxTi
             from sysibm.sysTables t
                 join sysibm.sysIndexes i
                 on i.tbCreator = t.creator and i.tbName = t.name
                 join sysIbm.indexSpaceStats q
                 on q.dbName = t.dbname
                          and q.indexspace = i.indexspace
             group by t.dbname, t.tsName
        ) i
        on i.db = s.db and i.ts = s.ts
     where  s.db like 'DF5407%'
     ;
     where  s.db like 'DBJ%' or s.db like 'DED%'or s.db like 'DGM%'
         or s.db like 'DRE%' or s.db like 'DNF%'or s.db like 'DSA%'
         or s.db like 'DWB%'
    order by s.db, s.ts