zOs/SQL/CATBP

select s.bPool, t.name
    from sysibm.sysTablespace s
    join sysibm.sysTables t
    on t.dbName = s.dbName and t.tsName = s.name
    where t.creator = 'VDPS2' and
          t.name in ('VTINSTRIDENT'
                    ,'VTINSTRUMENT'
                    ,'VTINSTIROLE'
                    ,'VTINSTIIDENT'
                    )
;x;
select bPool, count(*)
    from sysibm.sysTablespace
    group by bPool
    order by bPool
    with ur