Two-phase commit

StepsTo use two-phase commit with ASE servers

  1. Connect to an ASE.

  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 ASE.