zOs/SQL/CATSTOGR

select substr(stgroup,1, 10), count(*) "#DBs",
         min(createdTs) "creation", max(createdTS)
    from sysibm.sysDatabase
    group by stGroup
    order by stGroup
    with ur
;
select substr(storName, 1, 10), count(*) "#tbParts",
         min(createdTs) "creation", max(createdTS)
    from sysibm.sysTablePart
    group by storName
    order by storName
    with ur
;
select substr(storName, 1, 10), count(*) "#ixParts",
         min(createdTs) "creation", max(createdTS)
    from sysibm.sysIndexPart
    group by storName
    order by storName
    with ur
;                    x
select count(*), storname
    from sysibm.systablePart
    group by storName
    with ur