You can use the contents of the sample db2dsdriver.cfg.sample file to create an IBM® data server driver configuration file (db2dsdriver.cfg). The location of the sample configuration file depends on your IBM data server product installation and operating system.
You can use the DB2DSDRIVER_CFG_PATH registry variable to specify multiple paths for the IBM data server driver configuration file. The IBM data server driver configuration file paths in the DB2DSDRIVER_CFG_PATH registry variable must be specified in the order of precedence. When the DB2DSDRIVER_CFG_PATH registry variable is set, only the paths that are specified in the DB2DSDRIVER_CFG_PATH registry variable are searched in listed sequence.
You can manually copy and edit the IBM data server driver configuration file. After you edit the file, you must restart your ODBC, CLI, .NET, OLE DB, PHP, Ruby, or embedded SQL applications for the changes to take effect. The IBM data server driver configuration file is read when application starts.
If you have an IBM Data Server Runtime Client or IBM Data Server Client, you can copy the existing database directory information into the IBM data server driver configuration file by using the db2dsdcfgfill command. When you run the db2dsdcfgfill command, the configuration file is populated based on the contents of the local database directory, node directory, and Database Connection Services (DCS) directory of a specific database manager instance.
IBM Data Server Client and IBM Data Server Runtime Client can catalog remote databases locally. IBM Data Server Client and IBM Data Server Runtime Client derive database, host, and port information from the database and node catalog directories and use that information to locate the corresponding entries in the IBM data server driver configuration file. Even if the DCS directory is cataloged with a different target database, the database name that is specified in the database directory is used to locate the corresponding entry in the IBM data server driver configuration file.
In Version 10.1 Fix Pack 2 and later fix packs, silent installation on Windows operating systems accepts a customized IBM data server driver configuration file. You can use the DB2DSDRIVER_CFG_SOURCE_PATH response file keyword to specify the full path of a customized IBM data server driver configuration file. The IBM data server driver configuration file is then copied from the path that is specified in the DB2DSDRIVER_CFG_SOURCE_PATH response file keyword to the common application data path. Any existing IBM data server driver configuration file in the common application data path is silently overwritten by the customized IBM data server driver configuration file in the DB2DSDRIVER_CFG_SOURCE_PATH path during an upgrade operation.
DB2_COMMON_APP_DATA_TOP_PATH=C:\My Common App Data
DB2DSDRIVER_CFG_SOURCE_PATH = C:\Common Repository\mydsdriver.cfg
COPY_NAME = IBMDB2CL4