zOs/SQL/CATTSSPA

set current path oa1p;
with s as (
select dbName, name, count(*) parts, sum(real(totalRows)) rows
    from sysibm.systableSpaceStats
    group by dbName, name
)
select count(*) ts, sum(parts) parts,
    fosFmtE7(min(rows)) min,
    fosFmtE7(max(rows)) max,
    fosFmtE7(sum(rows)) sub
    from s
 -- where dbName like 'MF%'
    group by floor(log10(max(1, rows)) * 3)
    order by min(rows) desc
;x;
set current path oa1p;
with s as (
select dbName, name, count(*) parts, sum(space) spc
    from sysibm.systableSpaceStats
    group by dbName, name
)
select count(*) ts, sum(parts) parts,
    fosFmtE7(min(spc)) min,
    fosFmtE7(max(spc)) max,
    fosFmtE7(sum(spc)) sub
    from s
 -- where dbName like 'MF%'
    group by floor(log10(spc) * 3))
    order by min(spc) desc
;x;
select min(partition), max(partition)
    , min(char(limitKey,10)) ,max(char(limitKey,10))
    , sum(spacef * 1024) alloc
    , sum(spacef * percActive / 100 * 1024) active
    , sum(spacef * percActive * 1024 / (100-pageSave)) uncompressed
    , avg(percActive) meanActive
    , avg(pageSave) meanSave
    , sum(case when pageSave = 0 then 0 else 1 end) comprParts
  --  spacef, percActive, pageSave
    from sysibm.systablePart
    where dbName = 'MF01A1P' and tsName = 'A150A'
    and partition between  80 and 179
    group by trunc(partition/5, 0)
    order by 1
    with ur
;