select p.dbName, p.tsname, p.partition
from sysibm.sysTablePart p, sysibm.sysTableSpace s
where p.dbName = s.dbName and p.tsName = s.name
and not exists (select 0 from sysibm.sysTableSpaceStats r
where r.dbName = s.dbName and r.name = s.Name
and r.dbid = s.dbid and r.psid = s.psid
and r.partition = p.partition
)
-- and s.dbName Like 'M%'