Re: Engine not using DBSPACETEMP in onconfig.pro

Hi John, AFAIK there are some "special" considerations on TEMP-tables: 1. You cannot use temporary dbspaces it you want your temp-tables to be logged! (see SQL-Syntax-Guide, WITH NO LOG-Option). 2. All temporary tables not explicitely created WITH NO LOG are logged! 3. That means, that no user-created temp-table resides in TMPDBS if it is not created WITH NO LOG; it is created in ROOTDBS instead. 4. Therefore ALWAYS use WITH NO LOG! (in SELECT ... INTO TEMP xxx as well as in CREATE TEMP xxx. Still there is something to say: If you create a temporary dbspace without the -t option using onspaces (it is then not a "real" temporary dbpsace in Informix-terms), and you instruct Informix-Online to use that dbspace for temporary tables, you'll achieve the following: + TEMP-Tables (logged or unlogged) are created in that dbspace. + U can use that dbspace for admin-tasks (e.g. reorganisation) - Both physical and logical logging will be performed on that dbspace. - the dbspaces will be archived Knowing the above we try to set up our systems as follows: 1. Create a small rootdbs not suitable for TEMP-tables. 2. Create one or more "real" TEMP-dbspaces (onspaces ... -t ...) 3. Create at least one "pseudo" TEMP-dbpsace (onspaces without -t) 4. Setup all TEMP-dbspaces in ONCONFIG. Hope that helps, Peter _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ _/_/ Mag. Peter Kolmhofer __ _ _____ _/ _/_/ Informix & DB2 DBA __ --/_|___\\______ _/ _/_/ Porsche Informatik (Austria) _ _ ( _ _ \\) _/ _/_/ A-5101 Bergheim, Handelszentrum 7 -(_)-------(_)- _/ _/_/ +43 662 4670-6258 fax: -6501 email:kop@porsche.co.at _/ _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > John Graffio wrote: > > I am running Informix OnLine Version 7.24.FC5 and having a problem > with it using the root space as the temp space. I have the following > line in my onconfig.pro: > > DBSPACETEMP tempspc # dEFAULT temp dbspace> However, I have noticed that temp tables are being produced in the > root space, which is specified here: > > ROOTNAME rootspc # Root dbspace name> > My platform is Digital Unix 4.0, DEC Alpha 1200 with 1GB memory. > > Here is a breakdown of the DB Spaces: > [LIST OF DBSPACES snipped]