Running the installcommit script

If you use two-phase commit or distributed transactions, rerun the installcommit SQL script to restore the following stored procedures:

sp_start_xact
sp_abort_xact
sp_remove_xact
sp_stat_xact
sp_scan_xact
sp_probe_xac

Note:

If you modified any of these Sybase system stored procedures without changing the names, executing installcommit overwrites your modifications. In this case, reload the modified stored procedures after you run installcommit.

Using isql, run the new installcommit script included with this release.

isql -Usa -P<sa password> -S<servername> -n
-i$SYBASE/$SYBASE_ASE/scripts/installcommit 
-o<output file>

Where:

-P is the password parameter
-S is servername parameter

Save the output to an operating system file.