After you perform the basic downgrade steps, some changes from the 15.0.2 upgrade still persist.
Sybase 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.
Sybase does not certifiy that Component Integration Services running on earlier versions of Adaptive Server can connect to later versions. You may encounter errors if an ealier 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.0, be sure to 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, installhasvss, 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 in releases subsequent to 15.0 or 15.0.1 are not removed. Attempts to execute such stored procedures against an older binary will have unpredictable results.
During upgrade from a previous 15.0 or 15.0.1 version to Adaptive Server 15.0.2 you should have created an restore_msgs.ebf file. Now you must run this script to restore your messages back to the version from which you upgraded.
isql -Usa -P<sa password> -S<server name> -i<restore_msgs.ebf>
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.
After returning to a pre-15.0.2 binary:
If during the upgrade process you ran the ‘update all statistics’ on syslogins then you must delete statistics for syslogins and recreate them.
spt_values is dropped and re-created when you run the 15.0 or 15.0.1 installmaster, so any new types are eliminated from this table.
New configuration parameters have been added in 15.0.2. If a downgraded server is booted using the 15.0.2 configuration file, the new options will cause the message ‘Unknown parameter’ the unknown option will be reported the first time the server is booted. These messages can be ignored because the configuration file will be rewritten without the unknown options.Running the 15.0 or 15.0.1 version of installmaster removes configuration parameters that belong to 15.0.2, by deleting sysconfigures rows for configuration parameters that do not exist in syscurconfigs. After running installmaster the error messages will no longer appear when you start the server.
Keywords decrypt_default, xmltable, path, were added in Adaptive Server 15.0.2, making it impossible to create identifiers using these names. You must change applications if you used these names.
See “Additional steps if you used 15.0.2 features before downgrading” for more information.
