zOs/SQL/CATID

select char(t.dbname, 8) db, char(s.name,8) ts, char(t.name, 30) tb,
              s.dbid tsDbid, s.psid tsPsId, s.obid tsObId
           ,  t.dbid tbDbid,                t.obid tsObId
     from sysibm.systables t, sysibm.systablespace s
     where s.dbname = t.dbname and s.name = t.tsname
           and t.dbname = 'QZ01A1P';
     order by ts.dbName, ts.name