RE: what is using tmp dbspace ?

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