zOs/SQL/CATCOPDA

-- sysCopies pro Tag und icType
--     copied = bytes kopiert
--     cnt = Anzahl copies
select date(timestamp) da, icType,
        sum(copyPagesF * pgSize * 1024) copied,
        sum(case when copyPagesF * pgSize >= 20 * 1024 * 1024
                 then copyPagesF * pgSize * 1024 else 0 end) coTape,
        sum(nPagesF * pgSize * 1024) coSize,
        sum(cPagesF * pgSize * 1024) coChgd,
        count(*) cnt
    from sysibm.syscopy c, sysibm.systablespace s
    where icType in ('F', 'I') -- and c.dbName like 'MF01%'
        and c.dbName = s.dbName and c.tsName = s.name
    group by date(timestamp), icType
    order by 1 desc, 2
    with ur
;