Specifies how commits or rollbacks are to be coordinated among multiple database connections.
Syntax:
SYNCPOINT={ONEPHASE | TWOPHASE | NONE}
NOSYNCPOINT
Parameters:
| NONE |
Specifies that no Transaction Manager (TM) is to be used to perform a two-phase commit, and does not enforce single updater,
multiple reader. A COMMIT is sent to each participating database. The application is responsible for recovery if any of the
commits fail.
|
| ONEPHASE |
Specifies that no TM is to be used to perform a two-phase commit. A one-phase commit is to be used to commit the work done
by each database in multiple database transactions.
|
| TWOPHASE |
Specifies that the TM is required to coordinate two-phase commits among those databases that support this protocol. |