zOs/SQL/CATTSINF

select *
    from sysibm.sysTables
    where dbName = 'WP04A1P' and tsName = 'A301A52'
;
select *
    from sysibm.sysTablespace
    where dbName = 'WP04A1P' and name = 'A301A52'
;
select *
    from sysibm.sysTablePart
    where dbName = 'WP04A1P' and tsName = 'A301A52'
;
select *
    from sysibm.sysTableSpaceStats
    where dbName = 'WP04A1P' and name = 'A301A52'
;
select i.*
    from sysibm.sysTables t
      join sysibm.sysIndexes i
        on i.tbCreator = t.creator and i.tbName = t.name
    where t.dbName = 'WP04A1P' and t.tsName = 'A301A52'
;
select p.*
    from sysibm.sysTables t
      join sysibm.sysIndexes i
        on i.tbCreator = t.creator and i.tbName = t.name
      join sysibm.sysIndexPart p
        on i.creator = p.ixcreator and i.Name = p.ixname
    where t.dbName = 'WP04A1P' and t.tsName = 'A301A52'
;
select r.*
    from sysibm.sysTables t
      join sysibm.sysIndexes i
        on i.tbCreator = t.creator and i.tbName = t.name
      join sysibm.sysIndexSpaceStats r
        on i.creator = r.creator and i.Name = r.name
    where t.dbName = 'WP04A1P' and t.tsName = 'A301A52'
;