Chapter 2: Creating and Configuring DB2 Access Services

SQLInformationFile

Specifies the file that the sp_sqlgetinfo system procedure uses for target database information.

SQLInformationFile=[filename | db2.sif]

0–128 characters

db2.sif

filename is the file with sp_sqlgetinfo information.

During installation, DirectConnect places a default copy of the SQL information file for each DB2 Access Service Library into the DC-12_6\servername\cfg directory, where servername is the name of the DirectConnect server. If this property is left blank or not changed, the default file is used.
To customize the file, you first make a copy of the default file, save it under a new file name, and then edit the custom file by following these rules:
- Do not modify the header section of the file.
- Begin comments with a semicolon (;) or crosshatch (#) in column 1, on a line by themselves.
- Add additional properties to the [Start SQLGetInfo] section of the file in the property=value format as follows:
```
SQL_ACTIVE_CONNECTIONS=0
```
- Save the file.
To use the custom file, you must enter the custom file name as the SQLInformationFile property value.
If you move the custom file to a directory other than the DC-12_6\servername\cfg directory and want to use the file, enter the full path and custom file name as the SQLInformationFile property value.