zOs/SQL/SPACE
select 'taRun', sum(spacef * 1024) sp, count(*) cnt,
min(statstime) minTi, max(statstime) maxTi
from sysibm.systablepart
union select 'ixRun' , sum(ip.spacef * 1024) sp,
count(*) cnt,
min(ip.statstime) minTi, max(ip.statstime) maxTi
from sysibm.sysIndexPart ip
union select 'taReal', sum(float(space) * 1024) sp, count(*) cnt,
min(updatestatstime) minTi, max(updatestatstime) maxTi
from sysIbm.tableSpaceStats
union select 'ixReal' , sum(float(q.space)* 1024) sp, count(*) cnt,
min(updatestatstime) minTi, max(updatestatstime) maxTi
from sysIbm.indexSpaceStats q
with ur