When the system administrator heuristically completes a prepared transaction, SAP ASE maintains information about the transaction’s commit status in master.dbo.systransactions. This information is maintained so external transaction coordinators can detect the presence of heuristically completed transactions.
If the external coordinator is another SAP ASE, the server examines the commit status and logs a warning message if the heuristic completion conflicts with the commit status of the distributed transaction. After examining the commit status, the coordinating SAP ASE clears the commit status information from systransactions.
If the external coordinator is an X/Open XA-compliant transaction manager, the transaction manager does not log warning message when the heuristic completion conflicts with the distributed transaction. However, X/Open XA-compliant transaction managers clear the commit status information from systransactions.