community.borland.com

Article #25346: Redirecting temp file location in ibconfig file

Problem:
The InterBase 5.x documentation says that you can add a TMP_DIRECTORY setting
to the InterBase configuration file as an alternative to the TMP
 environment variable for sort file location.

Using the syntax described in the manual doesn't produce the desired action.
The temporary files are not  written to the location(s) specified in the configuration
file.

Note: See the Operations Guide chapter 4 Section "Configuring sort files" for 
proper syntax.


Solution:
The information in this article applies to:
* InterBase v5.x

Note: on Win95/NT the configuration file is called ibconfig
On Unix systems the InterBase configuration file is called
isc_config.

Add an entry for TMP_DIRECTORY in the configuration file.  

For example on NT use the following entry:

TMP_DIRECTORY 50000000  "c:dummytmp"

There are two things to watch out for when defining a TMP_DIRECTORY entry:
1) The size should be in bytes (InterBase doesn't recognize "M" or "K")  
2) The path needs to be in double-quotes. 


The InterBase Server must be restarted for the changes to take effect.

Last Modified: 18-OCT-00