Haven't got the query ready, but I'd explore the
sysmaster database.

In sysptnhdr , you will find all tables in temp dbspaces (most significant
3 disgits of the hex partnum represent the DBSpace , so search for all
tables whose partnum is like '0xDDD%' where DDD is the Dbspace number)
sysptnhdr also has a column nptotal , which gives you the total amount of
pages used. this is not exact, but should provide close enough an approximation
I guess.

Apart from that ß please consider an upgrade to the latest IDS patch version
Please conatatc SAP informix support to get zou this latest version for 9.4.

I do not recommend to stay on IDs 9.40.FC5 vanilla , due to bugs SAP customers
encountered
HTH
Tilman


-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Habichtsberg, Reinhard
Sent: Donnerstag, 15. Februar 2007 10:25
To: Informix-List (E-Mail)
Subject: Amount of temp space

Hi,

IDS 9.40 FC5

Is there any way to determine the amount of space sessions claim in the
exclusive temp dbspaces. Ideal would be an ordered list.

TIA
Reinhard
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list