Hi,
With this SMI query you can find out the names, dbspace of creation (rootdbs or temp dbspaces), database, owner (userid), timestamp, type of temp table (logging vs non-logging), disk space used, of each of the temporary tables that are currently created on the system:
How to find out the temporary tables that are currently created
http://www-1.ibm.com/support/docview.wss?uid=swg21174524
You could also/then trace the sessions to see the SQL statement that creates tables with the names above, or the users of the sessions and databases matching the owners above.
Hope it helps.
Regards,
Veronica.
Date: Wed, 28 May 2008 07:21:01 -0500
Subject: what is using tmp dbspace ?
From: floyd@fwellers.com
To: informix-list@iiug.org
Is there a way to tell what session is using the tmp dbspaces ?
Thanks,
floyd
_________________________________________________________________
Blog your life in 3D with Windows Live Writer.
http://www.windowslive.com/overview.html?ocid=TXT_TAGLM_Wave2_wl_writer_022008