xact coordination interval defines the length of time between attempts to resolve transaction branches that have been propagated to remote servers.
|
Summary Information |
|
|---|---|
|
Default value |
60 (seconds) |
|
Valid values |
1 – 2147483647 (seconds) |
|
Status |
Dynamic |
|
Display level |
10 |
|
Required role |
System administrator |
|
Configuration group |
DTM Administration |
The coordinating SAP ASE makes regular attempts to resolve the work of remote servers participating in a distributed transaction. The coordinating server contacts each remote server participating in the distributed transaction in a serial manner, as shown in the figure below. The coordination service may be unable to resolve a transaction branch for a variety of reasons. For example, if the remote server is not reachable due to network problems, the coordinating server reattempts the connection after the time specified by xact coordination level.
With the default value of xact coordination interval, 60, SAP ASE attempts to resolve remote transactions once every minute. Decreasing the value may speed the completion of distributed transactions, but only if the transactions are themselves resolved in less than a minute. Under normal circumstances, there is no performance penalty to decreasing the value of xact coordination interval.
Setting xact coordination interval to a higher number can slow the completion of distributed transactions, and cause transaction branches to hold resources longer than they normally would. Under normal circumstances, do not increase the value of xact coordination interval beyond its default.