Re: 7.23 doesn't use tempdbs

Gabriela Bellani wrote: > > Davin, > > Are you creating your temp tables with the option WITH NO LOG ? > create temp table your_table > ( .... > ) with no log;> > OR > > select anything_you_want into temp your_table with no log; > > If not they are created in a dbspace with logging ..... > > -- > Gabriela Bellani > gbellani@bcobisel.com.ar I've come across this before (Informix 7.2x on HP-UX, but I expect it's the same issue as you're seeing). What I think is happening is that Informix can't perform logging on a dbspace created with -t, but your database has logging switched on - so Informix creates the table elsewhere so that it can log it. (Strange reasoning - I know!) If you don't want to have to use "with no log" on all your SQL, then you can drop and recreate your tempdbs dbspace without the -t option. You can still use this dbspace for temp tables. Personally I've never used the -t option because of this downside. Is there any advantage in using it? Richard