Windows: Create Datastore Data Sources for Db2

Note: We recommend that you use a connection string to connect to Db2 databases; that is, using the connect attribute within the database configuration file, which is covered in Update the Configuration File for Db2 Datastores.

If you did not use connection strings when configuring the database configuration file, use the following steps to create ODBC data sources to access the datastore databases.

Open the ODBC Data Source Administrator.
Tip: On most newer Windows versions, click the Start Menu button, type ODBC, and then select the appropriate desktop app.
On the ODBC Data Source Administrator dialog box, select the System DSN tab.
Add a new data source for each required datastore:
1. Click Add.
2. Select the appropriate ODBC driver for your database (for example, IBM DB2 ODBC Driver is a common one for Db2), and click Finish.
  The ODBC IBM DB2 Driver - Add wizard appears.
3. Enter a name and description for the data source.
  Note: The data source name must be 8 characters or less.
4. Click OK.
  The ODBC Data Source Administrator appears again.
5. Repeat these sub-steps for each additional datastore you require.
Click OK.

The data sources for the datastore databases are configured. You can now start to upload data files to them using the dbfhdeploy command line utility.