zOs/SQL/CATTAB

select  char(strip(creator) || '.'  || strip(Name), 24) "table",
        char(strip(dbName) || '.'  || strip(tsName), 17) "db.tablspace",
        cardf "rows"
    from sysibm.sysTables
    where type = 'T' and dbName like 'BJA_0001'
    order by 1
    ;
x
select left(dbname, 10)|| strip(creator) || '.' || strip(name)
    from sysibm.systables
    where type = 'T' and dbName like 'RP%'
    order by dbname asc, creator asc, name asc
    ;
group by l
select s.l, count(*)
from
    (
    select length(strip(name)) l
    from sysibm.systables
    where type = 'T' and creator like 'OA1%'
    ) s
group by l