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