IBM i
These properties vary according to the database vendor requirements for JDBC driver implementations. Set the appropriate properties on every data source that you configure. These settings are for a DB2 UDB data source.
What type of configuration do we have?
DB2 UDB for iSeries with the appserver for AIX, HP-UX, IBM i, Linux, Solaris, or Windows
You can configure the following types of providers:
- DB2 UDB for iSeries (Native)
- DB2 UDB for iSeries (Native XA)
- DB2 UDB for iSeries (Toolbox)
- DB2 UDB for iSeries (Toolbox XA)
- DB2 UDB for iSeries (Native)
The iSeries Developer Kit for Java contains this Type 2 JDBC driver that is built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. This provider:
- Is for local DB2 connections on iSeries. It is not recommended for remote access.
- Supports the one-phase data source:
com.ibm.db2.jdbc.app.UDBConnectionPoolDataSource- Requires the following JDBC driver files:
- db2_classes16.jar - for nodes that are running at V7.0 or later. The location of the jar file is /QIBM/Proddata/java400/jdk6/lib/ext/db2_classes16.jar.
- db2_classes.jar - for nodes that are running at V6.1 or earlier. The location of the jar file is /QIBM/ProdData/Java 400/ext/db2_classes.jar.
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper- Does not require an authentication alias.
- Requires the following properties:
- databaseName - The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.
- DB2 UDB for iSeries (Native XA)
The iSeries Developer Kit for Java contains this XA-compliant Type 2 JDBC driver built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. This provider:
- Is for local DB2 connections on iSeries. It is not recommended for remote access.
- Supports the following two-phase data source:
com.ibm.db2.jdbc.app.UDBXADataSource- Requires the following JDBC driver files:
- db2_classes16.jar - for nodes that are running at V7.0 or later. The location of the jar file is /QIBM/Proddata/java400/jdk6/lib/ext/db2_classes16.jar.
- db2_classes.jar - for nodes that are running at V6.1 or earlier. The location of the jar file is /QIBM/ProdData/Java 400/ext/db2_classes.jar.
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper- Does not require an authentication alias.
- Requires the following properties:
- databaseName - The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.
- DB2 UDB for iSeries (Toolbox)
This JDBC driver, also known as iSeries Toolbox driver for Java , is provided in the DB2 for iSeries database server. This provider:
- Is for remote DB2 connections on iSeries. Use this driver instead of the IBM Developer Kit for Java JDBC Driver to access remote DB2 UDB for iSeries systems.
- Supports the following one-phase data source:
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource- Requires the following JDBC driver files:
- jt400.jar
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper- Does not require an authentication alias if the appserver and DB2 UDB for iSeries are installed in the same server. If they are installed in different servers, the user ID and password are required.
- Requires the following properties:
- serverName - The name of the server from which the data source obtains connections. Example: myserver.mydomain.com.
- DB2 UDB for iSeries (Toolbox XA)
This XA compliant JDBC driver, also known as iSeries Toolbox XA compliant driver for Java , is provided in the DB2 for iSeries database server. This provider:
- Is for remote DB2 connections on iSeries. Use this driver instead of the IBM Developer Kit for Java JDBC Driver to access remote DB2 UDB for iSeries systems.
- Supports the following two-phase data source:
com.ibm.as400.access.AS400JDBCXADataSource- Requires the following JDBC driver files:
- jt400.jar
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper- Does not require an authentication alias if the appserver and DB2 UDB for iSeries are installed in the same server. If they are installed in different servers, the user ID and password are required.
- Requires the following properties:
- serverName - The name of the server from which the data source obtains connections. Example: myserver.mydomain.com.
Related tasks
Set a JDBC provider and data source
Set a JDBC provider
Set a data source
Create and configuring a JDBC provider and data source using the Java Management Extensions API
Related information
DB2 Universal Database for iSeries support pages
DB2 for iSeries product Web pages