zOs/SQL/CATINFO

-- catalog rows for a table A540769.TPER13
select t.*
    from sysibm.systables t
    where t.creator = 'A540769' and t.name = 'TPER13'
    order by creator, name
;
select s.*
    from sysibm.systables t
      join sysibm.sysTablespace s
        on t.dbName = s.dbName and t.tsName = s.name
    where t.creator = 'A540769' and t.name = 'TPER13'
    order by s.dbName, s.name
;
select p.*
    from sysibm.systables t
      join sysibm.sysTablePart p
        on t.dbName = p.dbName and t.tsName = p.tsName
    where t.creator = 'A540769' and t.name = 'TPER13'
    order by p.dbName, p.tsName, p.partition
;
select t.*
    from sysibm.sysTabStats t
    where t.owner = 'A540769' and t.name = 'TPER13'
    order by owner, name, partition
;
select c.*
    from sysibm.sysColumns c
    where c.tbCreator = 'A540769' and c.tbName = 'TPER13'
    order by c.tbCreator, c.tbName, c.colNo
;
select c.*
    from sysibm.sysColDist c
    where c.tbOwner = 'A540769' and c.tbName = 'TPER13'
    order by c.tbOwner, c.tbName, c.name, COLGROUPCOLNO
;
select c.*
    from sysibm.sysColStats  c
    where c.tbOwner = 'A540769' and c.tbName = 'TPER13'
    order by c.tbOwner, c.tbName, c.name, c.partition
;
select c.*
    from sysibm.sysColDistStats  c
    where c.tbOwner = 'A540769' and c.tbName = 'TPER13'
    order by c.tbOwner, c.tbName, c.name, c.partition, COLGROUPCOLNO
;