These properties vary according to the database vendor requirements for JDBC driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for a DB2 data source that is connecting to an application server that is running on Windows, Unix, Linux, or similar systems.
Starting with version 9 of DB2, UNIX systems require a 64-bit kernel. In addition, the width of the default instance bit is now determined by the operating system, which is different than with previous versions of DB2. With these changes in operating system requirements, the -w option, which would have provided the ability to specify the bit width of the instance, was removed for the db2icrt, db2ilist and db2iupdt commands.
These changes on UNIX systems preclude the ability to create or maintain a 32-bit instance of the application server with version 9 of DB2 on UNIX platforms. On 64-bit UNIX systems that have a 32-bit instance created for version 8 of DB2, migrate the 32-bit instance for version 8 of DB2 to a 64-bit instance for version 8 of DB2 before you migrate the instance to version 9 of DB2.
gotchaThe DB2 Universal JDBC Driver is an architecture-neutral JDBC driver for distributed and local DB2 access. Because the Universal Driver architecture is independent of any particular JDBC driver connectivity or target platform, it allows both Java connectivity (Type 4) or Java Native Interface (JNI) based connectivity (Type 2) in a single driver instance to DB2.
This JDBC driver allows applications to use both JDBC and Structured Query Language in Java (SQLJ) access.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
java com.ibm.db2.jcc.DB2Jcc -versionThe output for the above example is:
IBM DB2 JDBC Universal Driver Architecture 2.2.xx
The db2jcc_license_cisuz.jar does not ship with the application server and should be located in the same directory as the db2jcc.jar file, so that the DB2UNIVERSAL_JDBC_DRIVER_PATH points to both.
<classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar </classpath> <classpath>${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar</classpath> <classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar</classpath>
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
Requires a valid authentication alias.
You can use useTransactionRedirect for both driverType 2 and driverType 4 data sources. To configure the property, use either the wsadmin scripting tool or the administrative console page J2EE resource provider or connection factory custom properties collection. Assign the property the value of true.
The DB2 Universal JDBC Driver provider (XA) is an architecture-neutral JDBC provider for distributed and local DB2 access. Whether you use this provider for Java connectivity or Java Native Interface (JNI) based connectivity depends on the version of DB2 you are running. Version 6.0 and later of the application server requires DB2 8.1 Fix Pack 6. This version of DB2 only supports XA connectivity over the Java Native Interface (JNI) based connectivity (Type 2) driver. In order to use XA connectivity with the Type 4 driver, DB2 8.1 Fix Pack 7 or higher is required.
The DB2 Universal JDBC Driver (XA) supports two phase transactions and the more advanced data source option offered by the application server (as opposed to the other option, Version 4 data sources). This driver also allows applications to use both JDBC and SQLJ access.
com.ibm.db2.jcc.DB2XADataSource
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
You must use the right license JAR file to access a specific database backend.
${DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH}
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
Requires a valid authentication alias.
You can use useTransactionRedirect for both driverType 2 and driverType 4 data sources. To configure the property, use either the wsadmin scripting tool or the administrative console page J2EE resource provider or connection factory custom properties collection. Assign the property the value of true.
java com.ibm.db2.jcc.DB2Jcc -versionexample output of the above:
IBM DB2 JDBC Universal Driver Architecture 2.2.xx
The DB2 legacy CLI-based Type 2 JDBC Driver Provider is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers.
COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
Requires JDBC driver files: db2java.zip (Note: If you run SQLJ in DB2 Version 8, db2jcc.jar is also required.)
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias if the application server is running on the same machine as the database. Otherwise, connectivity through this driver does require an alias.
The DB2 legacy CLI-based Type 2 JDBC Driver (XA) is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers.
COM.ibm.db2.jdbc.DB2XADataSource
Requires JDBC driver files: db2java.zip (Note: If you run SQLJ in DB2 Version 8, db2jcc.jar is also required.)
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias if the application server is running on the same machine as the database. Otherwise, connectivity through this driver does require an alias.
The DB2 Universal JDBC Driver is an architecture-neutral JDBC driver for distributed and local DB2 access. Because the Universal Driver architecture is independent of any particular JDBC driver connectivity or target platform, it allows both Java connectivity (Type 4) or Java Native Interface (JNI) based connectivity (Type 2) in a single driver instance to DB2. Version 5.0.2 and later of the application server supports both Type 2 and Type 4 JDBC drivers. To use the Type 4 driver, you must install DB2 Version 8.1 or a later version. To use the Type 2 driver, you must install DB2 Version 8.1 Fix Pack 2 or a later version.
This JDBC driver allows applications to use both JDBC and Structured Query Language in Java (SQLJ) access.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
java com.ibm.db2.jcc.DB2Jcc -versionThe output for the above example is:
IBM DB2 JDBC Universal Driver Architecture 2.2.xx
The db2jcc_license_cisuz.jar does not ship with the application server and should be located in the same directory as the db2jcc.jar file, so that the DB2UNIVERSAL_JDBC_DRIVER_PATH points to both.
<classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar </classpath> <classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar</classpath> <classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar</classpath>
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
Requires a valid authentication alias.
The DB2 Universal JDBC Driver (XA) is an architecture-neutral JDBC driver for distributed and local DB2 access. In version 5.0.2 of the application server, this driver only supports Java Native Interface (JNI) based connectivity (Type 2) in a single driver instance to DB2. To use this driver, you must install DB2 Version 8.1 Fix Pack 2 or a later version. This driver supports two phase transactions and a version 5.0 data source for the application server. This driver allows applications to use both JDBC and SQLJ access.
com.ibm.db2.jcc.DB2XADataSource
java com.ibm.db2.jcc.DB2Jcc -versionexample output of the above:
IBM DB2 JDBC Universal Driver Architecture 2.2.xx
You must use the right license jar file to access a specific database backend.
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
Requires a valid authentication alias.
The DB2 legacy CLI-based Type 2 JDBC Driver Provider is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers. For use with the application server on Windows, supported UNIX systems, or workstation-based Linux systems, this provider requires DB2 Connect (which is available from DB2).
COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
Requires JDBC driver files: db2java.zip (Note: If you run SQLJ in DB2 Version 8, db2jcc.jar is also required.)
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias.
The DB2 legacy CLI-based Type 2 JDBC Driver (XA) is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers. For use with the application server on Windows, supported UNIX systems, or workstation-based Linux systems, this provider requires DB2 Connect (which is available from DB2).
COM.ibm.db2.jdbc.DB2XADataSource
Requires JDBC driver files: db2java.zip (Note: If you run SQLJ in DB2 Version 8, db2jcc.jar is also required.)
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias.