Connecting IBM Data Studio to a Db2 database

These instructions explain how to create a connection from IBM Data Studio version 4.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 IBM Data Studio, click All Databases > New Connection to a database.
  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.
    Port
    For a connection without SSL, enter 50000. For a connection with SSL, enter 50001.
    User name
    The user name that you use to log in.
    Password
    The password that you use to log in.
  4. For an SSL connection, click the Optional tab, and then click Add. For the sslConnection property, specify true.
  5. Optional: Click Test Connection to verify that the connection succeeded.