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 for z/OS Option places a default copy of the SQL information file for each DB2 access service library into the <install_dir>\servers\<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 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:
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 <install_dir>\servers\<servername>\cfg directory and want to use the file, enter the full path and custom file name as the SQLInformationFile property value.
