Finding the session which uses a particular temporary table

I need to know what session or sql is consuming high temporary space due to other session are affected (-264 Could not write to a temporary file.) I have two temporary dbspaces (tmp1 and tmp2, 1 GB c/u). I get from sysmaster: tabname type nptotal dbspace_name _temptable sys_temp 465318 tmp1 ... tmp1 is out of space. tmp2, however is almost idle. I noted that round robin between tmp1 and tmp2 didn't work in this case. Do you have any clues ? My IDS version is 7.31 Thanks

roger_vilca@yahoo.es wrote: > I need to know what session or sql is consuming high temporary space > due to other session are affected (-264 Could not write to a > temporary file.) > > I have two temporary dbspaces (tmp1 and tmp2, 1 GB c/u). > > I get from sysmaster: > > tabname type nptotal dbspace_name > > _temptable sys_temp 465318 tmp1 > ... > > > tmp1 is out of space. tmp2, however is almost idle. > > I noted that round robin between tmp1 and tmp2 didn't work in this > case. > > > > Do you have any clues ? > > My IDS version is 7.31 > work out the partition numbers that are of interest and then match them against an onstat -g opn -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm