OpenTP1 Version 7 Operation

[Contents][Index][Back][Next]

6.1.6 Suspending transaction recovery (when Oracle9i RAC is used)

When you use Oracle9i RAC#, if the system ends abnormally, in-doubt transactions (undetermined transactions) are transferred from the failed running server to the standby server. If the transfer of in-doubt transactions takes too much time, the transaction determination type may become inconsistent between OpenTP1 and Oracle9i because of the specifications of Oracle9i.

Therefore, the transaction recovery by OpenTP1 is suspended during the transfer of in-doubt transactions to avoid the inconsistency of transaction determination types.

#
RAC is an abbreviation for Real Application Clusters. RAC is a cluster system that allows multiple nodes to share a single database on a shared disk.
Organization of this subsection
(1) How to use this facility
(2) Notes

(1) How to use this facility

To use Oracle9i RAC, specify the -r option in the trnstring definition command in the transaction service definition and suspend the recovery of OpenTP1 transactions. To enable the -r option in the trnstring definition command, you need to specify "OPS_FAILOVER=T" as an open character string.

When the -r option is specified in the trnstring definition command, the system suspends the responses from the resource manager, locking the transaction recovery process. Therefore, increase the number of transaction parallel recovery processes (value specified in the trn_recovery_process_count operand) for the number of resource managers specified in the -r option in the trnstring definition command. If you do not increase the number of transaction parallel recovery processes, transaction recovery processing may be affected.

(2) Notes

If an error occurs in a resource manager during startup processing or online processing while transaction recovery is suspended, the transaction recovery is delayed until the error in the resource manager is corrected.

You can change or delete the -r option in the trnstring definition command in the transaction service definition at restart. For details, see the description about the system service definition and the definitions that can be changed at restart in the manual OpenTP1 System Definition.