zOs/SQL/OLDNAMP

select d.name,
       ( select count(*) from sysibm.systables c
             where c.type = 'T' and c.dbName = d.name ) "tables"
    from sysibm.sysDatabase d
    where d.name like 'AV%' -- in ( 'DBJ01', 'DBP01' )
    group by d.name
    order by d.name
;
select d.name,
       ( select count(*) from sysibm.systables c
             where c.type = 'T' and c.dbName = d.name ) "tables"
    from sysibm.sysDatabase d
    where d.name like 'AV%' -- in ( 'DBJ01', 'DBP01' )
    order by d.name
;