Filter
Top Products
Post-upgrade tasks
72 Adaptive Server Enterprise
In pre-12.5 versions of Adaptive Server, the default data cache available
depended on the amount of memory available to Adaptive Server. If the
default data cache was set to 2MB, Adaptive Server allocated 2MB to the
default data cache. If, after memory was allocated to all user-defined data
caches and to the procedure cache, there was more memory available, that
memory was allocated to the default data cache. However, if there was not
enough memory available for Adaptive Server to set up the user-defined
caches and the procedure cache, then memory was taken from the default
data cache regardless of the designated configuration parameter.
Therefore, it was possible to set default data cache to the default value and
have all remaining available memory allocated to the default data cache.
Adaptive Server 12.5.x and later treats the default data cache size as an
absolute value and sets it in the config file. The string DEFAULT in the
config file has a different meaning for default data cache size in Adaptive
Server 12.5.x and later.
In pre-12.5 Adaptive Server, it meant all the memory left after allocating
memory for other configurations, procedures, and user-defined named
caches. In Adaptive Server 12.5.x and later, it means a default value of
8MB.
During the upgrade process, Adaptive Server ensures that the default data
cache size remains the same. Therefore, during the pre-upgrade process,
the size of the default data cache is obtained and written to the
configuration file as an absolute value, not as “DEFAULT”. This enables
Adaptive Server to have the same default data cache size as before the
upgrade. If this size is less than the default size of default data cache of
8MB, then Adaptive Server allocates a default data cache of size 8MB.
7 If you unmirrored devices, remirror them, using the
disk remirror
command.
8 For information about upgrading compiled objects, see “Upgrading
compiled objects with dbcc upgrade_object” on page 109.
9 If you used two-phase commit in 11.9.x, run the script to install the
two-phase commit tables:
isql -Usa -Psa_password -Sserver_name
-i$SYBASE/$SYBASE_ASE/scripts/installcommit
You do not need to run this script if you do not use two-phase commit.