Post-Downgrade Tasks for Adaptive Server

After you perform the basic downgrade steps, finish the process by handling residual tasks.

1. Installing system stored procedures of the old version drops auditing information about system stored procedures. Use the output of sp_displayaudit recorded during predowngrade to help determine the system stored procedures for which auditing was enabled. Reenter the audit options using sp_audit. For example, sp_addlogin was audited in your server before upgrading, run this command to reenable auditing on sp_addlogin:

   sp_audit "exec_procedure", "all", "sp_addlogin", "on"

   After you run installmaster, installmodel, installcommit, installsecurity, installhasvss, installjsdb, and installmsgsvss on your downgraded server, return system stored procedures to their earlier form. New stored procedures introduced in releases subsequent to the downgraded server are not removed.

   Warning!  Attempts to execute new stored procedures against an older binary have unpredictable results.
2. During the upgrade to Adaptive Server 15.7 you should have created a restore_msgs.ebf file. Run this script now to restore your messages back to the version from which you upgraded:

   isql -Usa  -P <sa_password>  -S <server_name> -i <restore_msgs.ebf> 

   Note: If you upgraded from a 15.0 or 15.0.1 release and are reverting back to the 15.0 or 15.0.1 release, then you must only run instmsgs.ebf file from the relevant release.
3. The on-disk structures of stored procedures, triggers, and views may contain statement identity tokens, datatypes, and object references that are not understood by the earlier Adaptive Server versions. You must drop all compiled objects that use features introduced into Adaptive Server subsequent to the release to which you are downgrading.
4. If during the upgrade process you ran the update all statistics on syslogins, you must delete statistics for syslogins and re-create them.
   spt_values are dropped and re-created when you run installmaster from the release area you downgraded to. Any new types are eliminated from this table.
5. Running installmaster from the release area of the server to which you downgraded removes configuration parameters that belong to 15.7, by deleting sysconfigures rows for configuration parameters that do not exist in syscurconfigs. After running installmaster, the error messages no longer appear when you start the server.
   If you start a downgraded server using the 15.7 configuration file, the new options generate an Unknown parameter message. The unknown options are reported the first time you restart the server. You can ignore these messages; the configuration file is rewritten without the unknown options.