zOs/SQL/XB21

     -- table Space und Details für 1 StichDatum
set current path oa1p;
with t2 as
(
   select rz, dbSys, dbName, name, instance, partition
       , max(loadTs) loadTs
       , max(case when loadTs <    '2014-09-15-00.00.00'
                  then loadTs else '0001-01-01-00.00.00' end) loadFP
     from oa1p.tqz006GbGrTsSTats
    where rz = 'RZ2' and dbSys = 'DVBP'
   --   and dbName = 'XBFIS002'
    group by rz, dbSys, dbName, name, instance, partition
)
   select t2.rz, t2.dbSys, t2.dbName, t2.name, t2.instance, t2.partition
      , substr(fosFmte7(real(rn.nActive) * rn.pgSize * 1024), 1, 7)
          "newUsed"
      , substr(fosFmte7(rN.totalRows), 1, 7) "newRows"
      , rN.nActive "newActive"
      , rO.nActive "oldActive"
      , substr(fosFmte7(real(rO.nActive) * rO.pgSize * 1024), 1, 7)
          "oldUsed"
      , substr(fosFmte7(rO.totalRows), 1, 7) "newRows"
      ,t2.loadTs, t2.loadFP
     from t2
      join oa1p.tqz006GbGrTsSTats rN
        on t2.loadTS is not null and rN.state <> 'd'
                and t2.rz        = rN.rz
                and t2.dbSys     = rN.dbSys
                and t2.dbName    = rN.dbName
                and t2.name      = rN.name
                and t2.instance  = rN.instance
                and t2.partition = rN.partition
                and t2.loadTs    = rN.loadTS
      join oa1p.tqz006GbGrTsSTats rO
        on t2.loadTS is not null and rO.state <> 'd'
                and t2.rz        = rO.rz
                and t2.dbSys     = rO.dbSys
                and t2.dbName    = rO.dbName
                and t2.name      = rO.name
                and t2.instance  = rO.instance
                and t2.partition = rO.partition
                and t2.loadFP    = rO.loadTs
      where rN.nActive <> rO.nActive
      order by real(rn.nActive) * rn.pgSize * 1024 desc
      fetch first 1000 rows only
      with ur
;x;
select rz, dbSys, dbName, name
      , substr(case when tsTy <> '' then tsTy else tsType end
          || case when clone in ('N', '?') and instance=1 and tsInst=1
                  then ''
                  else case when instance=tsInst then 'b' else 'c' end
                      || instance end, 1, 3) "yci"
      , substr(case when partition = 0 and parts = 0 then ''
            else case when partition is null            then ' ---'
                      when partition = 0 and tsTy = 'G' then ' pbg'
                      when partition = 0                then ' ???'
                      else right('   ' || partition, 4)
                 end
             ||'/'|| value(right('   '|| parts, 4),'----')
            end, 1, 9) "part/ tot"
   -- , smallInt(partition) part
      , substr(fosFmte7(real(nActive) * pgSize * 1024), 1, 7) used
      , substr(fosFmte7(totalRows), 1, 7) rows
      , substr(tb, 1, 30) "table"
      , updateStatsTime, t.*
    from t
    order by rz, dbSys, dbName, name, instance, partition
;