Windows: Create Datastore Data Sources for Db2

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

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 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 datastores are configured. You now need to configure the database configuration file to use the data sources: see Update the Configuration File for Db2 Datastores.