zOs/SQL/CATTBCNT

set current sqlid = 's100447';                                          00000114
CREATE VIEW T.T AS SELECT 1 #a# from sysibm.sysDummy1;                  00000213
rollback;;;                                                             00000312
select left(dbName, 1), count(distinct dbName) dbs,                     00000411
                        count(*) tbs                                    00000511
    from sysibm.sysTables                                               00000611
    group by left(dbName, 1)                                            00000711
    order by 1                                                          00000811
    with ur                                                             00000911
;;;                                                                     00001011
select *                                                                00001104
from                                                                    00002004
(                                                                       00003004
select s.dbName, s.name, s.type, min(s.nTables) mi, max(s.nTables) ma,  00010008
         count(*) cnt,                                                  00010104
         sum(case when t.name is null then 0 else 1 end) tbs            00011004
    from sysibm.sysTablespace s                                         00020003
        left join sysibm.systables t                                    00021003
        on t.dbName = s.dbName and t.tsName = s.name                    00030003
              and t.type in ('T', 'M')                                  00031010
    group by s.dbName, s.name, s.type                                   00050009
 ) c                                                                    00060005
     where (mi <> ma or mi <> tbs)                                      00080007