Installation guide

upgrade_object to upgrade compiled objects such as check constraints, rules, triggers,
and views.
4.
Run the scripts for different options or licensed features:
• installcommit – if you use two-phase commit or distributed transactions, re-run
installcommit to restore:
• sp_start_xact
• sp_abort_xact
• sp_remove_xact
• sp_stat_xact
• sp_scan_xact
• sp_probe_xact
• installsecurity – if you used auditing in your earlier installation.
• installhasvss – if you enabled high availability, and are using this feature in this
installation.
• installmsgsvss – if you enabled real-time messaging, and you are using this feature in
this installation.
• installpcidb – if you enabled the Java in the database feature in your earlier installation.
• installjsdb – if you enabled Job Scheduler in your earlier installation.
5.
If you have any system stored procedures that you had saved from before the upgrade
(because you had modified them without altering their names), reload them now.
See also
• How Compiled Objects Are Handled When Upgrading Adaptive Server on page 101
Running the instmsgs.ebf Script
Run message-related scripts after upgrading from an Adaptive Server version 15.0.x to
version 15.7 ESD #2.
1.
If you upgraded from Adaptive Server version 15.0.x, run uninstmsgs.ebf:
isql -Usa -Ppassword -w1000 -iuninstmsgs.ebf -orestoremsgs.ebf
This safeguards your modified messages in the master database before you install the
default version 15.7 ESD #2 messages.
2.
Regardless of the Adaptive Server version you upgraded from, run the instmsgs.ebf:
isql -Usa -Ppassword -iinstmsgs.ebf
Note: To undo instmsgs.ebf changes, run this script once you have downgraded to the
version from which you upgraded:
isql -S -Usa -P restore_msgs.ebf
3.
If you use localized files, install any localized language using langinstall, sqlloc, or
syconfig.
CHAPTER 10: Adaptive Server Upgrades
88 Adaptive Server Enterprise