RE: DBTEMP

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Art S. Kagel Sent: 27 April 2005 02:05 AM To: informix-list@iiug.org Subject: Re: DBTEMP Dirk Moolman wrote: > I am trying to understand the environment variable DBTEMP better. I am > using DBSPACETEMP in my onconfig, but the DBA who created the system I > work on, also included DBTEMP in the user .profile >Outdated. Not really used anymore, replaced with DBSPACETEMP and >PSORT_DBTEMP. This was used in OL4 & 5 to place sort-work files in >filesystems and similarly for some kinds of temp tables. The former is not >controlled by either DBSPACETEMP or PSORT_DBTEMP depending on whether >parallel sorting is enabled and if the latter is set. > >Art S. Kagel > Now I understand why I couldn't find it in the manuals - only DBSPACETEMP & PSORT_DBTEMP like you mentioned above. The interesting thing is that someone set this variable on my system, and it is actually being used by the engine (7.31) I disabled it, so that file that were created here, can now be created in either /tmp or my temp dbspaces. Thanks Dirk sending to informix-list

For temporary files ids will use: PSORT_DBTEMP if not defined he will check DBSPACETEMP environment var, if not defined will check DBSPACETEMP in the ONCONFIG, if not defined will use /tmp. used for the following operations: ORDER BY/GROUP BY UNIQUE/DISTINCT, SORT-MERGE-Join, Hash table, Index builds, Logical log files during a warm restore For temporary tables ids will use DBSPACETEMP environment variables if not defined will check the DBSPACETEMP configuration parameter if not defined rootbds used for the following operations: INTO TEMP statement CREATE TEMP TABLE BLOB