DB2 Universal Database for iSeries database connections
Use the New Database Connection wizard or the Database Connection page to create a JDBC connection to DB2 Universal Database for iSeries.
The following JDBC Driver is supported for DB2 Universal Database for iSeries:
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.
When you connect to DB2 Universal Database 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. Connecting without filtering can also 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 Universal Database for iSeries database. Other fields should be filled in as described in the pop-up help.
- 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 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.
Related tasks
Troubleshooting database connection problems
Related reference
Supported database types
License requirements for all DB2 Universal Database database connections
DB2 Universal Database for Linux, UNIX, and Windows database connections
DB2 Universal Database for z/OS and OS/390 database connections