zOs/SQL/CATLOAD

select count(*), left(jobName, 7),
        min(strip(dbName) || '.' || strip(tsName)),
        max(strip(dbName) || '.' || strip(tsName)),
        count(distinct strip(dbName) || '.' || strip(tsName))
    from sysibm.syscopy
    where icType in ('R', 'S')
          and timestamp > current timestamp - 28 days
    group by left(jobName, 7)
    order by 1 desc
    with ur
;
x
select count(*), date(timestamp)
    from sysibm.syscopy
    group by date(timestamp)
    with ur