Run the instmsgs.ebf script, Restoring functionality in adaptive server – Sybase ADAPTIVE 15.0.2 User Manual
Page 86

Post-upgrade tasks
70
Adaptive Server Enterprise
Run the instmsgs.ebf script
You must run the instmsgs.ebf script after you upgrade from a 15.0 Adaptive
Server to a 15.0.2 Adaptive Server. Run the instmsgs.ebf script immediately
after runnning the installmaster script.
If you are a localized customer:
•
First run the instmsgs.ebf script, and then install any localized language
using
langinstall
,
sqlloc
, or
syconfig
.
•
If you run instmsgs.ebf after installing the 15.0.2 localized message, this
script may delete some new messages.
Restoring functionality in Adaptive Server
To reset or enable options or functionality you had to change before the
upgrade:
1
Reset the configuration parameters.
If you changed any configuration parameters before upgrading, use
sp_configure
to set them back to their previous values.
2
Use
sp_dboption
to reset any database options you disabled before
upgrading.
3
After you complete the upgrade, but before you use the upgraded Adaptive
Server, verify that all scripts developed at your site point to Adaptive
Server 15.0.2.
4
Verify procedure cache allocation after upgrading.
This section is for information only. Adaptive Server ensures that
procedure cache size
after upgrade is the same as before upgrade, unless
the original size was less than the default value.
If you are upgrading from a version of Adaptive Server that is earlier than
version 12.5.x,
procedure cache percent
has been changed to
procedure
cache size
. Adaptive Server now allocates memory dynamically and
determines the size of the procedure and data caches in terms of
megabytes. During the upgrade process, Adaptive Server converts the
procedure cache percent
to an absolute value and sets
procedure cache size
based on this value.