Skip to main content

​
Prerequisites

requires the jt400.jar driver (download) to connect to your DB2 for i database. Before you create your connection, download and copy the driver to your lib directory, as follows:
  • Microsoft Windows: InstallationDirectory\lib
  • UNIX or Mac OS X: InstallationDirectory/lib

​
Authenticate to DB2 for i

After you add the connector, you need to set the required properties.
  • Server: Enter the address or host name of the DB2 for i server. The default server is localhost.
  • Database: Enter the name of your DB2 for i database.
  • Port: Enter the port number for your server. The default port is 446.
  • User: Enter the username that you use to authenticate to the DB2 for i database.
  • Password: Enter the password that you use to authenticate to the DB2 for i database.

​
Complete Your Connection

To complete your connection:
  1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
  2. Click Create & Test to create your connection.