Edit online

Available in the Enterprise edition only.

To configure a data source for connecting to an IBM DB2 server, follow these steps:

  1. Go to the IBM website and in the DB2 Clients and Development Tools category select the DB2 Driver for JDBC and SQLJ download link. Fill out the download form and download the zip file.
  2. Unzip the downloaded archive.
  3. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  4. Click the New button in the Data Sources panel.

    The dialog box for configuring a data source is opened.

    Figure: Data Source Drivers Configuration Dialog Box

  5. Enter a unique name for the data source.
  6. Select DB2 in the driver Type drop-down menu.
  7. Click the Add Files button and select the IBM DB2 driver files from the archive that you downloaded and unzipped.

    The IBM DB2 driver files are:

    • db2jcc.jar
    • db2jcc_license_cisuz.jar
    • db2jcc_license_cu.jar
  8. Select the most appropriate Driver class.
  9. Click the OK button to finish the data source configuration.
  10. Continue on to configure your IBM DB2 connection.