Restore functionality in the server after an upgrade.
sp_configure "configuration file", 0, "verify", "full_path_to_file"
See Reference Manual: Procedures and the Performance and Tuning Guide for details about sp_configure and sp_sysmon, and the System Administration Guide for information on configuring memory.
The server ensures that all data cache sizes remain the same after upgrading. Adaptive Server treats this size as an absolute value of 8MB and sets it in the config file..
During the upgrade process, the server ensures that the default data cache size remains the same. Therefore, during the preupgrade process, the size of the default data cache is obtained and written to the configuration file as an absolute value, not as a default. This enables the server to have the same default data cache size as before the upgrade. If this size is less than the default size of 8MB, the server allocates a default data cache of 8MB.
isql -Usa -Psa_password -Sserver_name -i$SYBASE/$SYBASE_ASE/scripts/installcommit