zOs/SQL/CATTSCOM

select min(pageSave), max(pageSave), count(*)
    , case when reorglastTime < current timestamp - 6 month
                  and (reorgInserts / max(1000, totalRows)) > .9
                  then 'r' else ' ' end
    , max(reorgLastTime)
    , 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 p,
         sysibm.systableSpaceStats r
         where p.dbName = r.dbName and p.tsName = r.Name
              and p.partition = r.partition
            --and p.dbName like 'BE%'
    group by case when pagesave<0 then -99
                  when pagesave=0 then   0
                  else max(1, trunc(pageSave/10, 0)) end
    , case when reorglastTime < current timestamp - 6 month
                  and (reorgInserts / max(1000, totalRows)) > .9
                  then 'r' else ' ' end
    order by 1, 4
    with ur
;