TempDir CLI/ODBC and IBM data server driver configuration keyword
Defines the directory used for temporary files.
- db2cli.ini keyword syntax:
- TempDir = < full path name >
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="TempDir" value="full path name"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Use the system temporary directory specified by the TEMP or TMP environment variables.
- Usage notes:
When working with Large Objects (CLOBS, BLOBS, and other large objects), 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 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.