Temp table session

Hi all, We are running IDS 10 FC 5 on HP-UX We have been experiencing a problem recently where the tempdb spaces are being filled up (even after adding 20Gb). In order to trace the application(s) responsible I would like to find out the session id from which the table was created. Does anyone know how I would do this. Regards Mark

If the query is actively running and you do not know which session is creating and filling the temp table(s) you can run onstat -g opn. In this output you want to look for tables created in your temp dbspaces. For example in the below output: IBM Informix Dynamic Server Version 10.00.UC8 -- On-Line -- Up 06:38:31 --344064 Kbytes tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode 2646 0x1b2538f0 0 0x00000400 0x00000291 0x007000ad 3 2 0 2646 0x1b2538f0 1 0x00000002 0x00000003 0x007000ad 3 2 0 2646 0x1b2538f0 2 0x00000408 0x00000797 0x007000ad 3 2 0 2653 0x1b25488c 0 0x00000400 0x00000291 0x00800002 2 2 0 2653 0x1b25488c 1 0x00000002 0x00000003 0x00800002 2 2 0 2653 0x1b25488c 2 0x00000408 0x00000017 0x0080003d 1 1 0 *2653 0x1b25488c 3 0x0000090a 0x00000003 0x00500003 1 1 9 *2653 0x1b25488c 4 0x0000090a 0x00000003 0x00600003 1 1 9 *2653 0x1b25488c 5 0x0000090a 0x00000003 0x00400004 1 1 9 The lines with * preceding them represent temp dbspaces - based on the partnum column. The first 3 positions of the partnum is my dbspace number (in hex). In my case dbspaces 4,5, and 6 are temp dbspaces. Now I take the rstcb column from the same lines and use it to grep out of onstat -u (make sure to take the X off of your grep pattern): onstat -u | grep 1b25488c onstat -u | grep 1b25488c 1b25488c ---PR-- 2549 informix 41 0 0 2 104568 0 From this I know my session id is 2549 - the third column above. Hope that helps! Mike