Re: Drop table from temp dbspace

On Feb 18, 4:08 am, Jose <joseph...@gmail.com> wrote: > Hello, > > Have a situation were one temporary table is not getting dropped > automatically from the temp dbspace. Table name is start with _ > (underscore). Table name is _temptable. > > Number of extents for this table is above 500 and our monitoring tool > is throwing alerts. > > Some application is doing this. Killing the session didn’t work. And > also restarted the application didn’t solve the issue. > > I know bouncing the Informix server will solve the issue. > > Is there any other solution apart from bouncing? Or bouncing is the > only solution. > > Informix version: Informix Dynamic Server 2000 Version 9.21.H > OS: HP-UX 11.X > > Output from oncheck: > > Chunk Pathname                                         Size > Used      Free >      4 /tempchunk1                                   1000000 > 14545    985455 > >  Description > Offset     Size >  ------------------------------------------------------------- > -------- -------- >  RESERVED PAGES > 0        2 >  CHUNK FREELIST PAGE > 2        1 >  (0x400001) temp1dbs:'informix'.TBLSpace > 3       50 >  (0x400042) xxx:'aa'._temptable > 53        8 >  (0x400003) xxx:'aa'._temptable > 61        8 > > ………… > > Thanks & Regards, > Jose Well, you could try and run onstat -g opn and see if you can find a thread that has the partnum that matches reported as open. If you can find a thread with that partition open, you could try and get it to exit. However, it seems like I recall some old defects where temp space may not have been properly cleaned up in all cases when a session exited. If that is the problem you are running into, then it is very likely that the only way to resolve the issue is the bounce of the server, which re-initializes the temp dbspaces when the engine is brought on-line. Jacques Renaut IBM Informix Advanced Support APD team