zOs/SQL/CATCOLUP

select (select partitions from sysibm.sysTableSpace s
            where s.dbName = t.dbName and s.name = t.tsName) parts,
       t.*
    from sysibm.sysTables t
    where t.type = 'T'
        and exists (select 1
             from sysibm.sysColumns c
             where t.creator = c.tbCreator and t.name = c.tbName
                 and c.updates = 'N'
                 and c.colType <> 'ROWID'
                 and c.default <> 'K'
                 and t.creator <> 'SYSIBM'
                 )
;X;
      group by t.creator, t.name
with c as
(
select count(*) cols,
sum(case when c.updates = 'N' then 1 else 0 end) updN
    from sysibm.sysTables t
      join sysibm.sysColumns c
      on t.creator = c.tbCreator and t.name = c.tbName
      where t.type = 'T'
      group by t.creator, t.name
)
select count(*) tbs,
       sum(case when updN = 0 then 0 else 1 end) tbsUpdN,
       sum(cols) cols,
       sum(updN) updN
    from c