zOs/SQL/XB16STAT

set current path oa1p;
with g as
(
  select count(*) parts
      , sum(real(nActive) * pgSize * 1024) usedSum
      , min(real(nActive) * pgSize * 1024) usedMin
      , max(real(nActive) * pgSize * 1024) usedMax
    from oa1p.TQZ006GBGRTSSTATS
    where rz = 'RZ2' and dbSys = 'DVBP' and dbName like 'XB%'
        and validBegin <= current timestamp
        and validEnd   >  current timestamp
    group by floor(real(nActive) * pgSize / 1024 / 1024)
)
select parts
  , substr(fqzFmtBin7(usedSum), 1, 7) usedSum
  , sum(parts) over(order by usedMax desc) partCum
  , substr(fqzFmtBin7(sum(usedSum) over(order by usedMax desc)
          ), 1, 7) usedCum
  , substr(fqzFmtBin7(usedMin), 1, 7) usedMin
  , substr(fqzFmtBin7(usedMax), 1, 7) usedMax
from g