DB2 for iSeries database connections

Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to DB2® for iSeries™.
The following JDBC Driver is supported for DB2 for iSeries:
  • AS/400® Toolbox for Java™ JDBC Driver
  • DB2 Universal Driver
AS/400 Toolbox for Java JDBC Driver

The AS/400 Toolbox is available with the DB2 Application Development Client. The iSeries JDBC Driver is also included with WebSphere® Development Studio for iSeries or Rational® Application Developer for iSeries.

This JDBC driver is also included with this product, in the com.ibm.datatools.db2.iseries plug-in.

DB2 JDBC Drivers

You can download the DB2 JDBC drivers at www.ibm.com/software/data/db2/.The DB2 Universal Driver is included with the DB2 Application Development Client. This driver is a two tier pure Java JDBC driver that allows a Java client to communicate directly with DB2 UDB servers through the DRDA® protocol. This driver supports both Type 2 connections (to databases that are cataloged on your local computer) and Type 4 connections (using a host, database name, and port). This driver is designed to replace the Type 3 Net driver.

The DB2 Universal Driver is included with this product, in the com.ibm.datatools.db2 plug-in.

Tip: When you connect to DB2 for iSeries, you should filter the objects that are retrieved from the database to improve connection performance. If you do not filter the objects, then all schemas in QSYS will be selected, which can cause the connection to take a long time to complete and the memory allocated to Java can be exceeded. In an iSeries system, a schema is a library and a table is a physical file.
The following connection field should be filled in as described to connect to a DB2 for iSeries database. Other fields should be filled in as described in New Connection wizard - Connection parameters page.
Class location

Type the class location containing the JDBC driver.

If you are using the driver that is included in the Application Development client, the class file is located in ..SQLLIB\tools\jt400.jar

If you are using the driver that is included with this product, the class file is located in <RDA>\rda_prod\eclipse\plugins\com.ibm.datatools.db2.iseries_x.x.x\driver

If you are using the driver that is included with WebSphere Development Studio for iSeries or Rational Application Developer for iSeries, the JAR file is also jt400.jar. The path to this file varies depending on which tool you installed. To use the IBM® Toolbox for Java driver to connect to an IBM DB2 for iSeries server, the jt400.jar file must be installed on your workstation.

Related concepts
Overview of database connections
Related tasks
Connecting to a database by using a wizard
Related reference
Connection Parameters page
Filter page
New or Existing Connection page

Feedback