Remote Transactions

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.
• Remote Transaction Restrictions
  Remote transaction management has savepoints and nested statement restrictions.