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 > I want to know what exactly gets written to the DBTEMP directory. > > I found the following info: > > DBTEMP (IDS) > The DBTEMP environment variable is used by DB-Access and IBM Informix > Enterprise Gateway products as well as by Dynamic Server and by earlier > database servers. DBTEMP resembles DBSPACETEMP, specifying the directory > in which to place temporary files and temporary tables. > > > I assume my database sorting will take place in the temp dbspaces > (DBSPACETEMP) - what is DBTEMP use for then ? > > sending to informix-list

DBTEMP (IDS) The DBTEMP environment variable is used by DB-Access and IBM Informix Enterprise Gateway products as well as by Dynamic Server and by earlier database servers. DBTEMP resembles DBSPACETEMP, specifying the directory in which to place temporary files and temporary tables. Dirk, check out the IDS 10 Information centre http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp Put in DBTEMP in the search ooption That will take you straight to the SQL Referenc emanuals discussing the use of DBTEMP