Two-phase commit

The two-phase commit feature is a separately licensed product.

To use two-phase commit with ASE servers

1. Connect to an Adaptive Server Enterprise.

2. Add an external login entry for the DirectConnect for Oracle server for the “probe” login which is used to recover two-phase commit transactions. The Oracle login that is used must have the necessary privileges to recover transactions for any user.

   For example:

   sp_addexternlogin dco_server, probe, system, manager
   

3. Configure the DirectConnect for Oracle server to use two phase commit.

   For example:

   dco_server...sp_configure dco-server, two_phase_commit, 1
   

4. Shut down and restart the DirectConnect server.

5. Shut down and restart the Adaptive Server Enterprise.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF