Configuring TAFJ and WebSphere DataSource

This section shows the steps required in configuring TAFJ and WebSphere Data source.

Creating a JDBC Provider

Procedure

1. Click Resources > JDBC > JDBC providers > New.
2. Specify the following properties:
   1. DatabaseType: DB2
   2. ProviderType: DB2 Universal JDBC Driver Provider
   3. Implementation type: XA data source
   4. Name: DB2 Universal JDBC Driver Provider



3. Click Next.



4. Enter the directory path for the db2jcc.jar and db2jcc_license_cisuz.jar files. For example, /usr/lpp/db2/db2910_jdbc/classes

This will be saved as a WebSphere variable ${DB2UNIVERSAL_JDBC_DRIVER_PATH}.

5. Click Next and Finish.



6. Save changes to master configuration.
7. Set the user id and password in the tafj.properties file, which is located in %TAFJ_HOME%/conf under the keys temn.tafj.jdbc.username and temn.tafj.jdbc.password. For example,

Temn.tafj.jdbc.username            =             user1
Temn.tafj.jdbc.password             =             password

Creating the Temenos Transact Manager Database Credentials

Procedure

1. Click Security > Global security > Java Authentication and Authorization Service > J2C authentication data > New.
2. Specify the following properties:
   1. Alias: T24 Database
   2. User ID: username
   3. Password: your password

      

NOTE: The alias is used to identify the Manager while the user and password is used to login to the database instance.
3. Click OK and save changes to master configuration.
4. Set the user id and the password in the tafj.properties file, which is located in %TAFJ_HOME%/conf under the keys temn.tafj.jdbc.username and temn.tafj.jdbc.password. For example,

temn.tafj.jdbc.username  = *******

temn.tafj.jdbc.password  = *******

Creating a Data Source

Procedure

1. Click Resources > JDBC > Data Source > Scope > Server > New.
2. Specify the following properties:
   1. Data Source Name: TAFJ XA DB2 Data source
   2. JNDI Name: jdbc/t24DataSource

      

3. Click Next.
4. Click Select an existing JDBC provider and select DB2 Universal JDBC Driver provider (XA).



5. Click Next.
6. Specify the following details:
   1. Driver type: 4
   2. Database name: The DB2 location name
   3. Server Name: The hostname or IP address of the DB2 server
   4. PortNumber: The DRDA port number for DB2

      The DB2 location name can be found from the results of a DISPLAY DDF DB2 command:

      

7. Set two variables in the tafj.properties file in %TAFJ_HOME%/conf under the keys temn.tafj.jdbc.url and temn.tafj.jdbc.driver. For example,

temn.tafj.jdbc.driver = COM.ibm.db2.jdbc.app.DB2Driver
temn.tafj.jdbc.url = jdbc:db2://10.44.5.224:5032:T24_DB03



8. Click Next.



9. In the Setup security alias section, select the authentication alias created before for XA recovery.

   Component-managed authentication alias : T24 database

   Container-managed authentication alias: T24 database

10. Click Next.



11. Click Finish and save settings to master configuration.

Setting Connection Type

Procedure

1. Click Resources > JDBC > Data Source > TAFJ XA DB2 Data source > Connection pools > Custom properties > New.
2. Set the new Custom property globalConnectionTypeOverride to unshared.



3. Click OK and save the changes to the master configuration.

Setting Data source multithread for DB2

Procedure

1. Click Resources > JDBC > Data Source > TAFJ XA DB2 Data source > WebSphere Application server data source properties.
2. Select the Enable multithreaded access detection check box.



3. Click OK and save the changes to the master configuration.

Setting Data Source Isolation Level for DB2

Procedure

1. Set the default transaction isolation level for new JDBC connections to READ COMMITTED (2).
2. Click Resources > JDBC > Data Source > TAFJ XA DB2 Data source > Custom properties.
3. Set webSphereDefaultIsolationLevel custom property to 2.