Installation guide

If you run instmsgs.ebf after installing the 15.7 ESD #2 localized message, this script may
delete some new messages.
Restoring Functionality in Adaptive Server After Upgrading
Restore functionality in the server after an upgrade.
1.
If you changed any configuration parameters before upgrading, use sp_configure to set
them back to their earlier values.
2.
Use sp_dboption to reset any database options you disabled before upgrading.
3.
Before you use the upgraded server, verify that all scripts developed at your site point to
Adaptive Server 15.7 ESD #2.
4.
Verify procedure cache allocation. The size should be the same as before upgrading, unless
the original size was smaller than the default value.
5.
Check the procedure cache requirements. Stored procedures, triggers, and other compiled
objects require much more memory to run in Adaptive Server 15.7 ESD #2.
Use sp_configure to increase the procedure cache size during runtime, and
sp_configure verify to verify any changes you make to the configuration file without
having to restart Adaptive Server:
sp_configure "configuration file", 0, "verify",
"full_path_to_file"
See Reference Manual: Procedures and the Performance and Tuning Guide for details
about sp_configure and sp_sysmon, and the System Administration Guide for
information on configuring memory.
6.
Verify data cache allocation.
The server ensures that all data cache sizes remain the same after upgrading. Adaptive
Server treats this size as an absolute value of 8MB and sets it in the config file..
During the upgrade process, the server ensures that the default data cache size remains the
same. Therefore, during the preupgrade process, the size of the default data cache is
obtained and written to the configuration file as an absolute value, not as a default. This
enables the server to have the same default data cache size as before the upgrade. If this size
is less than the default size of 8MB, the server allocates a default data cache of 8MB.
7.
If you unmirrored devices, remirror them using the disk remirror command.
8.
If you used compiled objects, see How Compiled Objects Are Handled When Upgrading
Adaptive Server on page 101.
9.
If you used two-phase commit in the earlier version of Adaptive Server, run the script to
install the two-phase commit tables:
isql -Usa -Psa_password -Sserver_name
-i$SYBASE/$SYBASE_ASE/scripts/installcommit
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 89