DB2 Version 9.7 for Linux, UNIX, and Windows

TempDir CLI/ODBC configuration keyword

Defines the directory used for temporary files.

db2cli.ini keyword syntax:: TempDir = < full path name >
Default setting:: Use the system temporary directory specified by the TEMP or TMP environment variables.
Usage notes:

When working with Large Objects (CLOBS, BLOBS, etc...), when data conversion occurs, or when data is sent to the server in pieces, a temporary file is often created on the client machine to store the information. Using this option you can specify a location for these temporary files. The system temporary directory will be used if nothing is specified.

The keyword is placed in the data source specific section of the db2cli.ini file, and has the following syntax:

TempDir= F:\DB2TEMP

The path specified must already exist and the user executing the application must have the appropriate authorities to write files to it. When the DB2® CLI Driver attempts to create temporary files, an SQLSTATE of HY507 will be returned if the path name is invalid, or if the temporary files cannot be created in the directory specified.