Sybase 15.0.2 - 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.