RE: Informix 7.24 Temp Tables Not Dropping

We had a version of 7.24 on AIX that had similar difficulties. Working fine on 7.24.UC6 (AIX 4.1.5) -----Original Message----- From: RG [mailto:rgriffin@farmerstel.com] Sent: Monday, March 15, 1999 9:01 PM To: informix-list@iiug.org Subject: Re: Informix 7.24 Temp Tables Not Dropping Are you sure the app that is creating the temp tables is really exiting? Monitor that with onstat -g sql and onstat -u. I'll guess that those sessions aren't really going away??? Another alternative is to have the application programmers add code to explicitly drop the temp table when the app no longer needs it...that's cleaner anyway. -- Robert jeffm@lysander.co.uk wrote in article <7cj90d$trc$1@nnrp1.dejanews.com>... > Hi everyone. > > I have a system running IDS 7.24 on HP-UX 10.20. Some software is creating > temporary tables using 'SELECT...INTO TEMP' and these are going into the > rootdbs. The database is logged and tables are NOT created 'WITH NOLOG'. > > This in itself isn't the problem because these tables must be created WITH > NOLOG to go to the temporary dbspaces (despite what manuals say!)rather than > rootdbs when running in a logged database. The problem we have is that the > tables are never dropped, except during initialisation when the engine is > bought down. Does anyone else have experience of this or know why it may be > happenning. Informix seem unaware of it and reckon the tables should get > dropped once the application exits. > > Jeff McFee > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >