Add the data source for the database driver and configure the properties for the data
source.
About this task
Perform the following list of steps for each of the data sources. For each data source,
substitute
curamdb,
curamsibdb, and
curamtimerdb
for
<DatasourceName>.
Note: In the data source name, do not use angle
brackets.
Procedure
- Select DB2 Using IBM JCC Driver(XA) that is displayed on the
JDBC Providers list. The configuration screen for the provider is
displayed.
- Select the Data sources link that is listed under
Additional Properties.
- Select New to add a data source.
- Use the following list of properties for the fields:
- Data source name
<DatasourceName>
- JNDI name
jdbc/<DatasourceName>
- Select Next to continue.
- Use the following list of properties for the fields:
- Driver type 4.
- Database name The name of the Db2 database.
- Server name The name of the Db2 database server.
- Port number The Db2 database server port.
Ensure that the Use this data source in container managed persistence
(CMP) checkbox is selected.
- Select Next.
- Use the following list of properties for the fields:
- 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 alias that you configured in the security setting. For more
information, see the Creating the Data Source Login Alias related link.
Unless a specific change is required, do not modify the other fields.
- Select Next to continue.
- Select Finish to confirm the changes and continue.
- Select the newly created DatasourceName data source from the displayed
list.
- Select the Custom Properties link in Additional
Properties.
- Select fullyMaterializeLobData.
- Set the value to false.
- Select OK to confirm the change.