Configuring For a Type 4 JDBC Universal Driver (XA)

Set up DB2 for z/OS Environment Variable

1. Navigate to Environment > WebSphere variables;
2. Note: The appropriate scope where the data source will be defined should be selected at this point.
3. Select the DB2UNIVERSAL_JDBC_DRIVER_PATH link from the list of environment variables. This will open the configuration screen for this variable;
4. Set the Value field to point to the directory containing the Type 4 drivers. This is normally the Cúram SDEJ drivers installation directory, e.g. /CuramSDEJ/drivers;
5. Press the OK button to confirm the changes.

Set up the Database Driver Provider

1. Navigate to Resources > JDBC > JDBC providers;
2. Note: The appropriate scope where the data source is to be defined should be selected at this point.
3. Press the New button to add a new driver. This will open a configuration screen;
4. Select the DB2 drop down from the list of database types supplied;
5. Select the DB2 Universal JDBC Driver Provider drop down from the list of Provider type supplied;
6. Select the XA data source drop down from the list of Implementation types supplied;
7. Press the Next button to continue;
8. Review the properties on the configuration screen that opens. Change the Class Path line ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar to point at the DB2 for z/OS license provided by IBM for zOS connectivity;
9. Press the Next and then the Finish button to confirm the changes.

Set up the Database Driver Data Source

The following steps should be repeated for each of the application Data Sources, substitutingcuramdb,curamsibdb andcuramtimerdb for <DatasourceName> (without the angle brackets):

1. Select theDB2 Universal JDBC Driver Provider (XA) now displayed on the list of JDBC Providers. This will open the configuration screen for the provider;
2. Select the Data sources link under Additional Properties;
3. Press the New button to add a new data source;
4. Set the fields as follows:

   Data source name : <DatasourceName>

   JNDI name : jdbc/<DatasourceName>

   Component-managed authentication alias and XA recovery authentication alias : <valid for database>

   where the alias used is the one set up in Creating the Data Source Login Alias;

5. Click Next to continue;
6. Set the fields as follows:

   Database name : The name of the DB2 for z/OS database;

   Driver type: 4;

   Server name: The name of the DB2 for z/OS database server;

   Port number : The DB2 for z/OS database server port;

   Leave all other fields untouched unless a specific change is required and click Next;

7. Press the Finish button to confirm the changes and continue;
8. Select the newly created DatasourceName data source from the displayed list;
9. Select the Custom Properties link under Additional Properties;
10. Select thefullyMaterializeLobData entry;
11. Set thevalue to be false;
12. Click the OK button to confirm the change.