How do I install and configure a JDBC Driver to connect to DB2 on iSeries?
NOTE: A few customers have experienced issues connecting to DB2 on iSeries using the JDBC driver. In these cases, the issues were resolved by using the ODBC driver.
- Download JTOpen from http://jt400.sourceforge.net/. The ZIP file includes the JDBC driver file
- Install the driver in Jitterbit by unzipping the download and then copying the
<JITTERBIT_HOME>with the path to your Private Agent root directory.
Edit the file
<JITTERBIT_HOME>/JdbcDrivers.confand add this driver entry:
- Restart the Jitterbit Tomcat server service.
- The newly installed driver should now be available in Design Studio. During configuration of a source or target database, select IBM DB2 (AS400) [JDBC] from the driver selection list.
Under Options, enter a manual connection string, replacing this example with your own host, libraries, and database name (if applicable):