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

Page 86

Advertising
background image

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.

Advertising