Set up the Database Driver DataSource

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. Click New to add a new data source;
4. Set the fields as follows:

   Data source name : <DatasourceName>

   JNDI name : jdbc/<DatasourceName>

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

   Driver type : 2 or 4 as required;

   Database name : The name of the DB2 database. (This will be equivalent to the curam.db.name property in the Bootstrap.properties file);

   Server name : The name of the DB2 database server. (This will be equivalent to the curam.db.servername property in the Bootstrap.properties file);

   Port number : The DB2 database server port. (This will be equivalent to the curam.db.serverport property in the Bootstrap.properties file);

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

7. Set the Component-managed authentication alias drop down value to: <valid for database>;

   Set the Mapping-configuration alias drop down value to: DefaultPrinicipalMapping

   Set the Container-managed authentication alias drop down value to: <valid for database>;

   where the <valid for database> alias used is the one set up in Creating the Data Source Login Alias;

   Leave all other fields untouched unless a specific change is required and click Next to continue.

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