zOs/SQL/OBID
with id as
( select 102 id from sysibm.sysDummy1
union select 113 id from sysibm.sysDummy1
)
select 'ts obid', s.obId, dbName, name
from sysibm.sysTablespace s, id
where dbname = 'DB2ADMIN' and OBID = id
union select 'ts psid', s.psId, dbName, name
from sysibm.sysTablespace s, id
where dbname = 'DB2ADMIN' and psID = id
union select 'tb obid', t.obId, dbName, name
from sysibm.sysTables t, id
where dbname = 'DB2ADMIN' and obID = id
union select 'ix obid', x.obId, dbName, name
from sysibm.sysIndexes x, id
where dbname = 'DB2ADMIN' and obID = id
;
select *
from sysibm.sysTables
where dbname = 'DB2ADMIN' and OBID = 102
;
select *
from sysibm.sysIndexes
where dbname = 'DB2ADMIN' and OBID = 102