Set up the Database Driver DataSource

About this task

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

Procedure

  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;

    Server name : The name of the DB2 database server;

    Port number : The DB2 database server port;

    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.