Transaction service

The parameters in the TRANSACTIONS section of the file govern InterChange Server's use of a database on behalf of the transaction service.

DATA_SOURCE_NAME

Required

The name of an IBM-branded driver or DB2 JDBC type 2 driver data source where the transaction service stores information about transactions. For an explanation of the JDBC URL, refer to the System Administration Guide.

Example: DATA_SOURCE_NAME = jdbc:ibm-crossworlds:oracle:// @server:1521;SID=TransDB

Default

There is no default value for this parameter.

MAX_CONNECTIONS

Specifies how many database connections InterChange Server can open on behalf of the transaction service. Set this parameter only if you have partitioned InterChange Server work load across database servers.

Example: MAX_CONNECTIONS = 30

Default

MAX_CONNECTIONS = 2147483647

USER_NAME

The name that InterChange Server uses to log in to the data source on behalf of the transaction service. Use this parameter to specify a non-default login account.

In an environment where all services of InterChange Server are using the same DBMS, and where you have changed the user name and password of the login account, this value should be the same under Repository, Event Management, Transactions, and Flow Monitoring.

In an environment where you have partitioned InterChange Server's use of database resources across multiple DBMS servers, you can have a different user name for each DBMS server. In that case, this parameter specifies the user name that InterChange Server uses on behalf of the transaction service. The account must have the privilege to create tables.

Example: USER_NAME = transact

Default

There is no default value for this parameter.

PASSWORD

The encrypted password associated with the user name for the transaction service.

Example: PASSWORD*=a6gefs

Attention:
Do not attempt to change the encrypted password. See the Encryption for Passwords section in the System Administration Guide for more information about how password encryption works.

DB_CONNECT_RETRIES

Specifies the maximum number of times that the server will try to reconnect to the database after the connection is found to be broken. The recommended retry count is 3. If the value is set to 0, this is equivalent to switching off the database connectivity resilience.

Use the DB_CONNECT_INTERVAL parameter to specify the time to wait between retries. The recommended time is 60 seconds.

The DB_CONNECT_RETRIES parameter and the DB_CONNECT_INTERVAL parameter in this section act upon the transaction management database. If database connectivity issues occur during communication between the server and the transaction management database, this pair of parameters controls how often and how frequently the server will try to reconnect to that database.

Note:
The DB_CONNECT_RETRIES parameter does not appear in the InterChange Server Configuration Wizard and must be altered by editing the [TRANSACTIONS] section of the InterchangeSystem.cfg using the System Manager.

Default

DB_CONNECT_RETRIES = 3

DB_CONNECT_INTERVAL

Specifies the time to wait between retries. The recommended time is 60 seconds. Setting the retry interval too high will slow the system down unnecessarily.

Set this value in the InterchangeSystem.cfg file in the [TRANSACTIONS] section. The value you specify is in seconds.

Note:
The DB_CONNECT_INTERVAL parameter does not appear in the InterChange Server Configuration Wizard and must be altered by editing the [TRANSACTIONS] section of the InterchangeSystem.cfg using the System Manager.

Default

DB_CONNECT_INTERVAL = 60

Copyright IBM Corp. 1997, 2004