Leonid Vorontsov,

select
owner
, dbinfo('dbspace',t.partnum)
, t.tabname
, hex(t.partnum)
--, sum(npdata)
, sum(pe_size)
from
systabnames t
--, sysptnhdr h
, sysptnext e
where
--h.partnum = t.partnum
t.partnum = e.pe_partnum
and dbinfo('dbspace',e.pe_partnum) .... <--- !!!! you filter
--and dbinfo('dbspace',e.pe_partnum)='$1'
--and dbinfo('dbspace',h.partnum)='$1'
group by 1,2,3,4

Не помню с какой версии появилось, на 12.10.FC9 есть (у меня 11.70 без этого)
https://informix.hcldoc.com/14.10/help/index.jsp?topic=/com.ibm.adref.doc/ids_adr_1200.htm
Если есть sysmaster:sysptrhdr.sid то все проще

SELECT i.sid, hex(i.flags) flags, hex(i.partnum) partition,
trim(n.dbsname) || ":" || trim(n.owner) || ":" || trim(n.tabname) table,
i.nptotal allocated_pages
FROM sysmaster:systabnames n, sysmaster:sysptnhdr i
WHERE (sysmaster:bitval(i.flags, "0x0020") = 1)
AND i.partnum = n.partnum