Configuring Two-Phase Commit with Adaptive Servers

Set the DirectConnect server for two-phase commit.

1. Connect to an Adaptive Server.
2. Add an external login entry for the DirectConnect 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 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.