zOs/TX/REC01IDS

select substr(strip(s.dbName) || '.' || strip(s.name), 1, 17),
       s.dbid, psid, s.obid,
       t.obid, substr(strip(t.creator) || '.' || strip(t.name), 1, 27)
    from sysibm.sysTablespace s
        left join sysibm.sysTables t
        on   t.dbName = s.dbName and t.tsName = s.name
    where s.dbName = 'DA540769' and s.name like 'ARE%'
    order by 1