zOs/SQL/CATTSIX

select s.name, char(strip(i.creator) || '.' || strip (i.name), 30),
       i.indexSpace, s.dbName
    from sysibm.sysIndexes i, sysIbm.sysTables t, sysIbm.sysTablespace s
    where    i.dbName = t.dbName and i.tbName = t.name
        and  t.dbName = s.dbName and t.tsName = s.name
        and  s.dbName = 'SAMT2' and s.name like 'SAM%'
    order by 1, 2