Postdowngrade Tasks

After you perform the basic downgrade steps, some changes from the 15.5 Cluster Edition 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 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.0.1 Cluster Edition, 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.

  1. 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 are not removed. Attempts to execute such stored procedures against an older binary will have unpredictable results.
  2. During upgrade from a previous 15.0.1 Cluster Edition or 15.0.3 Cluster Edition version to Adaptive Server 15.5 Cluster Edition you should have created a 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>
  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. After returning to a pre-15.5 Cluster Edition binary:
    1. If during the upgrade process you ran the ‘update all statistics’ on syslogins then you must delete statistics for syslogins and re-create them.
    2. spt_values are dropped and re-created when you run the 15.0.1 Cluster Edition or 15.0.3 Cluster Edition installmaster, so any new types are eliminated from this table.
  5. New configuration parameters have been added in 15.5 Cluster Edition. If a downgraded server is booted using the 15.5 Cluster Edition 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.1 Cluster Edition or 15.0.3 Cluster Edition version of installmaster removes configuration parameters that belong to 15.5 Cluster Edition, by deleting sysconfigures rows for configuration parameters that do not exist in sysurconfigs. After running installmaster the error messages will no longer appear when you start the server.
  6. Keywords decrypt_default, xmltable, 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. See the Additional steps if you used 15.5 Cluster Edition features before downgrading topic for more information.
Parent topic: Downgrading