Configuring a DB2 ODBC Data Source Name

You will need the following information from your DBA to configure a DB2 ODBC data source name (DSN):

  • The name of the database in which your workspace repositories will be stored.

  • The host name for the computer on which the database resides.

  • The port number for communications with the host, if it is not the standard port number.

Note: Keep the DSN handy. You will need to specify it when you create an CA workspace. For instructions on how to create a workspace, see Getting Started in the CA documentation set.
  1. In the Windows Control Panel, double-click Administrative Tools. The Administrative tools window opens.
  2. Double-click Data Sources (ODBC). The ODBC Data Source Administrator window opens.
  3. Select the System DSN tab and click Add. The Create New Data Source window opens.
  4. Select IBM DB2 ODBC DRIVER - DB2COPY1 and click Finish. The ODBC IBM DB2 Driver configuration dialog opens.
  5. In the Data Source Name field, enter a name of your choice to identify the data source. If your DBA has supplied a common DSN for use across the enterprise, enter it here.
  6. In the Description field, enter an optional description for the data source.
  7. In the Database alias field, select an existing database alias from the drop-down, then click OK.
  8. If a database alias has not been defined, click Add. The CLI/ODBC Settings window opens.
  9. In the Data Source tab, the Data source name and Description fields are pre filled with the information you supplied in the ODBC IBM DB2 Driver configuration dialog. In the User ID field, enter your domain user name. In the Password field, enter your domain user password. The fields are case-sensitive.
  10. Select the TCP/IP tab and specify the following information:
    • In the Database name field, enter the name of the database in which your workspace repositories will be stored.
    • In the Database alias field, enter a database alias.
    • In the Host name field, enter the host name for the computer on which the database resides.

    • In the Port number field, enter the port number for communications with the host. Use the standard port number of 50000 unless otherwise instructed by your DBA.

  11. Click OK. You are returned to the ODBC Data Source Administrator window. Select the new data source name and click Configure. The CLI/ODBC Settings window for the data source opens.
  12. In the Data Source tab, the Data source name and Description fields are pre filled with the information you supplied in the ODBC IBM DB2 Driver configuration dialog. In the User ID field, enter your domain user name. In the Password field, enter your domain user password. The fields are case-sensitive. Click Connect to test the database connection. You are notified that the connection was created successfully. Click OK.
    Note: If you receive an error, verify the driver configuration settings and retest the connection. See your DBA if the problem persists.
  13. Click OK to exit the CLI/ODBC Settings window. Then click OK again to exit the ODBC Data Source Administrator window.