Connecting InfoSphere Data Architect to a Db2 database

These instructions explain how to create a connection from InfoSphere Data Architect version 9.1.x to the Db2 database, BLUDB.

Before you begin

Before you can connect to your database, you must carry out the following steps:

  • Verify prerequisites, including installing driver packages, configuring your local environment, and downloading SSL certificates (if needed)

  • Collect connect information, including database details such as host name and port numbers, and connect credentials such as user ID and password

Procedure

  1. In the Data Source Explorer view of InfoSphere Data Architect, right-click Database Connections, then select New.
  2. On the Local tab, select DB2 for Linux, UNIX, and Windows as the database manager.
  3. On the General tab, enter the following values:
    Database
    BLUDB
    Host
    The host name that you collected beforehand.
    Port
    For a connection without SSL, enter 50000. For a connection with SSL, enter 50001.
    User name
    The user ID that you collected beforehand.
    Password
    The password that you collected beforehand.
  4. For an SSL connection, click the Optional tab. Enter an sslConnection property and specify a value of true. Click Add.
  5. Optional: Click Test Connection to verify that the connection succeeded.