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 a later step (Update the Configuration File for Db2 Datastores).
Use the following steps if you do not intend to use connection strings, but instead create ODBC data sources to access datastore
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.
ODBC Data Source Administrator dialog box, select the
System DSN tab.
Add a new data source for each required datastore:
Select the appropriate ODBC driver for your database (for example,
IBM DB2 ODBC Driver is a common one for Db2), and click
ODBC IBM DB2 Driver - Add wizard appears.
Enter a name and description for the data source.
Note: The data source name must be 8 characters or less.
The ODBC Data Source Administrator appears again.
Repeat these sub-steps for each additional datastore you require.
The data sources for the datastores are configured. You now need to configure the database configuration file to use the data
Update the Configuration File for Db2 Datastores.