Post-downgrade Tasks for Adaptive Server

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

SAP certifies that each version of Adaptive Server can connect to earlier releases through Component Integration Services. Component Integration Services is tested and certified to connect to earlier versions of Adaptive Server.

SAP does not certify that Component Integration Services running on earlier versions of Adaptive Server can connect to later versions. You may encounter errors if an earlier version of Adaptive Server maps a proxy table to a later version and the remote table uses functionality not available in the earlier release.

For example, if you have a local and a remote server, both running Adaptive Server version 15.7 ESD #2 Cluster Edition, upgrade the local server first, if you are performing an upgrade on each of them. If one is to be upgraded but not the other, the local server should be upgraded first.

After you run installmaster, installcommit, installsecurity, and installmsgsvss on your downgraded server, any changed system stored procedures are returned to their earlier form. Any new stored procedures introduced to Adaptive Server are not removed. Attempts to execute such stored procedures against an older binary may generate unpredictable results.
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 version to which you are downgrading.
If during the upgrade process you ran 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.
Run installmaster from the release area of the server to which you downgraded to remove configuration parameters that belong to 15.7 SP100, 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 SP100 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.
Note: Keywords decrypt_default, xmltable, and path were added in Adaptive Server 15.5 Cluster Edition, making it impossible to create identifiers using these names. You must change applications if you used these names.