zOs/SQL/CATTS

set current path oa1p;                                                  00000122
select count(*), fqzFmtBin7(sum(1024. * nPages * pgSize))               00000222
               , fqzFmtBin7(min(1024. * nPages * pgSize))               00000322
               , fqzFmtBin7(max(1024. * nPages * pgSize))               00000422
    from sysibm.systablespace s join sysibm.sysTablespaceStats r        00000522
         on s.dbid = r.dbid and s.psid = r.psid                         00000622
    where partitions = 0 and segsize > 0                                00000722
    group by floor(log(max(1024. * nPages * pgSize, 1024.)) / log(2))   00000822
    order by min(1024. * nPages * pgSize) desc                          00000922
    with ur                                                             00001022
;;                                                                      00001122
set current path oa1p;                                                  00001222
select count(*), fqzFmtBin7(sum(spaceF * 1024))                         00001322
               , fqzFmtBin7(min(spaceF * 1024))                         00001422
               , fqzFmtBin7(max(spaceF * 1024))                         00001522
    from sysibm.systablespace                                           00001622
    where partitions = 0 and segsize > 0                                00001722
    group by floor(log(max(spaceF, 1) * 1024) / log(2))                 00001822
    order by min(spaceF * 1024) desc                                    00001922
    with ur                                                             00002022
;;                                                                      00002122
select count(*), pgSize                                                 00002221
     from sysibm.sysTableSpace                                          00002321
     group by pgSize                                                    00002421
;x;                                                                     00002521
select count(*), SBCS_CCSID, DBCS_CCSID, MIXED_CCSID                    00002620
     from sysibm.sysTableSpace                                          00002720
     group by SBCS_CCSID, DBCS_CCSID, MIXED_CCSID                       00002820
     order by SBCS_CCSID, DBCS_CCSID, MIXED_CCSID                       00002920
     with ur                                                            00003020
;;                                                                      00003120
select count(*), partitions                                             00003219
     from sysibm.sysTableSpace                                          00003319
     group by partitions                                                00003419
     order by partitions                                                00004019
     with ur                                                            00005018
;;                                                                      00006018
select count(*), s.partitions, t.partkeycolnum                          00010016
    from sysibm.systablespace s, sysibm.systables t                     00010115
    where s.dbName = t.dbName and s.name = t.tsName                     00010215
    group by partitions, partkeycolnum                                  00010317
    order by 3 desc, 2 desc                                             00010414
;                                                                       00010514
select char(dbName, 8) "db", char(name, 12) "ts",                       00011014
           bPool, ntables, partitions, segSize, pgSize, nActive         00020001
    from sysibm.systablespace                                           00030000
    where     dbname in ('BJ01A1T', 'NF01A1T', 'NF02A1T', 'NF03A1T')    00040013
    order by 1, 2                                                       00050000
;                                                                       00051002
select char(s.dbName, 8) "db", char(s.name, 12) "ts", nTables,          00060005
           char(t.name, 12) "table"                                     00070003
    from sysibm.systablespace s                                         00080003
    left join sysibm.systables t                                        00081003
    on s.dbname = t.dbname and s.name = t.tsName                        00082003
    where s.ntables <> 1 and t.type = 'T'                               00090006
        and s.dbname in ('BJ01A1T', 'NF01A1T', 'NF02A1T', 'NF03A1T')    00090113
    order by 1, 2, 4                                                    00100005