DBTEMP (IDS)

Home | Previous Page | Next Page Environment Variables > Environment Variables >

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.

>>-setenv--DBTEMP--pathname------------------------------------><

pathname: is the full pathname of the directory for temporary files and tables.

For DB-Access to work correctly on Windows platforms, DBTEMP should be set to $INFORMIXDIR/infxtmp.

The following example sets DBTEMP to the pathname usr/magda/mytemp for UNIX systems that use the C shell:

setenv DBTEMP usr/magda/mytemp

Important:

DBTEMP can point to an NFS-mounted directory only if the vendor of that NFS device is certified by IBM. For information about NFS products for mounting storage space for an Informix database server, see the product compatibility data at http://www.ibm.com/software/data/informix/pubs/smv/
index.html.

If DBTEMP is not set, the database server creates temporary files in the /tmp directory and temporary tables in the DBSPACETEMP directory. See DBSPACETEMP for the default if DBSPACETEMP is not set. Similarly, if you do not set DBTEMP on the client system, temporary files (such as those created for scroll cursors) are created in the /tmp directory.

You might experience unexpected behavior or failure in operations on values of large or complex data types, such as BYTE or ROW, if DBTEMP is not set.