Filter
Top Products
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.
2Use
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.