The parameters in the TRANSACTIONS section of the file govern InterChange Server use of a database on behalf of the transaction service.
This parameter is required.
The name of an IBM-branded driver or DB2 driver data source where the transaction service stores information about transactions. For an explanation of the JDBC URL, refer System Administration Guide.
Example: DATA_SOURCE_NAME = jdbc:ibm-crossworlds:oracle:// @server:1521;SID=TransDB
There is no default value for this parameter.
The number of database connections InterChange Server can open on behalf of the transaction service. Set this parameter only if you have partitioned the InterChange Server workload across database servers.
Example: MAX_CONNECTIONS = 30
MAX_CONNECTIONS = 2147483647
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 amount of time to wait between retries.
DB_CONNECT_RETRIES = 3
Specifies the amount of time to wait between database connection retries. The recommended time is 60 seconds. Setting the retry interval too high will slow the system down unnecessarily. Setting the retry interval too low might lead to ICS shutdowns for database connectivity issues.
DB_CONNECT_INTERVAL = 60
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 nondefault 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 must be the same for Repository, Event Management, and Transactions.
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 this case, the parameter specifies the user name that InterChange Server uses on behalf of the transaction service. The account must have table creations privileges.
Example:
USER_NAME = ics (crossworlds for Oracle)
The encrypted password associated with the user name for the transaction service.
Example: PASSWORD*=a6gefs