This section explains how to install new 15.0.3 system stored procedures in the upgraded server. The new system stored procedures must be installed before any application activity starts. The scripts can be installed using the following isql commands:
isql -Usa -P<sa_password> -S<server_name> -i%SYBASE%\%SYBASE_ASE%\scripts\<script_name> -o<output_file>
The output of the script is saved in output_file.
If you have modified the system stored procedures without altering their original names, executing some of these scripts overwrites your modifications. You must reload the modified stored procedures after running these scripts:
instmstr – contains system administration procedures and must be installed.
installcommit – If you use two-phase commit or distributed transactions, you must 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
instsecu – Run this script if the Adaptive Server Auditing functionality was enabled in your earlier installation.
insthasv – Run this script if the HA functionality is enabled and the HA feature is currently in use in the upgraded installation of Adaptive Server.
installmsgsvss – Run this script if the RTDS ASE MESSAGING functionality is enabled and the RTDS ASE MESSAGING feature is being used in this installation.
installpcidb – Run this script if Java in database feature was enabled in your earlier installation.
installjsdb – Run this script if Job Scheduler functionality was enabled in your earlier installation.
