Transaction management involving remote servers uses a two-phase
commit protocol.
SAP Sybase IQ implements a strategy that ensures transaction
integrity for most scenarios.
Remote transaction management
The method for managing transactions involving remote servers uses a two-phase commit protocol. SAP Sybase IQ implements a strategy that ensures transaction integrity for most scenarios. However, when more than one remote server is invoked in a transaction, there is still a chance that a distributed unit of work will be left in an undetermined state. Even though two-phase commit protocol is used, no recovery process is included.