Restoring Functionality in Adaptive Server After Upgrading

Restore functionality in the server after an upgrade.

1. If you changed any configuration parameters before upgrading, use sp_configure to set them back to their earlier values.
2. Use sp_dboption to reset any database options you disabled before upgrading.
3. Before you use the upgraded server, verify that all scripts developed at your site point to Adaptive Server 15.7 SP100.
4. Verify procedure cache allocation. The size should be the same as before upgrading, unless the original size was smaller than the default value.
5. Check the procedure cache requirements. Stored procedures, triggers, and other compiled objects require much more memory to run in Adaptive Server 15.7 SP100.
   Use sp_configure to increase the procedure cache size during runtime, and sp_configure verify to verify any changes you make to the configuration file without having to restart Adaptive Server:

   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.

6. Verify data cache allocation.

   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 before the upgrade, 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.

7. If you unmirrored devices, remirror them using the disk remirror command.
8. If you used compiled objects, see How Compiled Objects Are Handled When Upgrading Adaptive Server.
9. If you used two-phase commit in the earlier version of Adaptive Server, run the script to install the two-phase commit tables:

   isql -Usa -Psa_password -Sserver_name 
   -i$SYBASE/$SYBASE_ASE/scripts/installcommit