Restoring functionality in adaptive server – Sybase 15.0.2 User Manual
Page 86
Post-upgrade tasks
72
Adaptive Server Enterprise
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.
For example, if
procedure cache percent
is configured as 20 percent of
200MB of memory, then the absolute value of
procedure cache percent
is
40MB. During the upgrade process, Adaptive Server converts
procedure
cache percent
at 20 percent to
procedure cache size
at 40MB. If the value
for
procedure cache size
is less than the default value, Adaptive Server sets
procedure cache size
to the default value. For example, if
procedure cache
percent
is set to 10 percent in the example above, and the absolute value
of 10 percent is less than the default value of
procedure cache size
, then
procedure cache size
is set to the default value.
With the introduction of dynamically reconfigured memory configuration
parameters in Adaptive Server 12.5.x, an increase in Adaptive Server’s
memory use does not decrease the size of the procedure cache or the data
cache. That is, if your default data cache is set to 40MB, and you increase
your procedure cache, the default data cache is still 40MB.
For more information about
sp_configure
, see the Reference Manual.