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 running on z/OS® and connecting to an application server that is also running on z/OS.
This provider is a one-phase commit JCC provider for DB2 that uses the IBM Data Server Driver for JDBC and SQLJ. The DB2 Using IBM JCC Driver is the next generation of the DB2 Universal JCC driver. Data sources you create under this provider support only 1-phase commit processing, unless you use the type 2 JDBC driver with the application server for z/OS. If you run the application server on z/OS with the type 2 driver, the driver uses RRS and supports 2-phase commit processing.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
The db2jcc_license_cisuz.jar does not ship with the application server. Place this file in the same directory as the db2jcc4.jar file, so that the UNIVERSAL_JDBC_DRIVER_PATH points to both files.
${DB2_JCC_DRIVER_PATH}/db2jcc4.jar ${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar ${DB2_JCC_DRIVER_PATH}/db2jcc_license_cisuz.jar
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
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, Java™ EE resource provider or connection factory custom properties collection. Assign the property the value of true.
com.ibm.db2.jcc.DB2XADataSource
${DB2_JCC_DRIVER_PATH}/db2jcc4.jar ${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar ${DB2_JCC_DRIVER_PATH}/db2jcc_license_cisuz.jar ${DB2_JCC_DRIVER_NATIVEPATH}
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
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 Java EE resource provider or connection factory custom properties collection. Assign the property the value of true.
com.ibm.db2.jcc.DB2ConnectionPoolDataSourceThis data source can support two-phase transactions (for the application server on the z/OS platform only). If you set the DB2 Universal JDBC Driver for type 2 connectivity, the application server running on z/OS uses RRS to process transactions, including two-phase commit transactions. When used with driver type 4 connectivity, this data source implementation supports one-phase transactions only.
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar ${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar ${DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH}
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
In the case where driverType 2 is specified and the data source is used with res-auth CONTAINER, you can specify a container-managed authentication alias; however, it is not required. If you do not specify a container-managed alias, the user identity associated with a connection created by the data source will be the user identity associated with the current thread at the time the connection is obtained.
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 ${DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH}
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper