zOs/SKELS/NAKCNRTS

select char(tm.name, 16) "tb", mult,
          decimal(sum(r.totalrows), 15) "rtsRows"
    from tm
        left join sysibm.tablespacestats r
        on r.dbid = tm.dbid and r.psid = tm.psid
    where tm.dbname $DBIN
    group by tm.creator, tm.name, mult
    order by tm.name
;
select char(strip(s.dbName) || '.' || strip(s.name), 17) "db.ts",
       min(r.updatestatstime),
       case when min(r.name) is null then '*** no RTS'
            when partitions <= 1 and count(*) = 1 then ''
            when partitions = count(*) then ''
            else                   '***missRTS'
       end "rtsSta",
       smallInt(count(*)), s.partitions
    from sysibm.systablespace s
        left join sysibm.tablespacestats r
        on s.dbid = r.dbid and s.psid = r.psid
    where s.dbName $DBIN
    group by s.dbName, s.name, s.partitions
    order by 3 desc, 2 asc
;