This section describes the basic steps for downgrading from Adaptive Server 15.0.2 to a 15.0 or 15.0.1 version. Additional actions are required if you used 15.0.2 features. If that is the case, follow the steps in the “Additional steps required if you used 15.0.2 features before downgrading,” section of this chapter.
Adaptive Server 15.0.2 provides a new procedure called sp_downgrade that is used to help with the downgrade process. This procedure requires 'sybase_ts_ role' to be on. The ‘sa_role’ or ‘sso_role’ permissions are expected when running this procedure. For more detailed information on this new system procedure and its syntax see ‘The New System Procedures’ section in the ‘System Changes’ chapter of the Adaptive Server New Feature Guide for 15.0.2.
Returning to 15.0.1 ESD#3 is preferable, because
this version can handle a number of error conditions that may arise
as a result of downgrading for several reported errors.
If you return to a pre-15.0.1 ESD3 version of Adaptive Server, no error handling is provided. Using the new features can result in inexplicable behavior, misleading error messages and stack traces.
Back up all of your databases and the $SYBASE release area prior to the 15.0.2 downgrade.
Start the 15.0.2 server in single user mode using dataserver -m option to guarantee that no other user can access Adaptive Server while you are going through the downgade steps. See Utility Guide for more details on starting the server in single user mode.
Make sure Adaptive Server 15.0.2 is prepared for downgrade by executing.
sp_downgrade 'prepare', <'version'>
The value of “version” may be written as “15.0” or “150” or “15.0.1” or “1501”. However, the version entered should be the Adaptive Server version you want to downgrade to.
If you have used the 15.0.2 features for encrypted columns
and
You are reverting back to Adaptive Server 15.0 GA or Adaptive Server 15.0 ESD #1 you must specify the version as '15.0'.
You are reverting back to Adaptive Server 15.0 EC, 15.0 ESD #2, 15.0.1 or later you must specify the version parameter as '15.0.1'.
sp_downgrade 'prepare' validates the readiness of Adaptive Server 15.0.2 for downgrade. This means that sp_downgrade 'prepare' may print messages regarding manual changes required before the downgrade can be completed. Errors reported must be corrected and implications of warnings reported must be understood before you can proceed with further downgrade steps. Refer to Table 6-1 to get more information on correcting the issues reported by sp_downgrade 'prepare'.
Repeat step 3 until sp_downgrade 'prepare' reports no errors. Your system is now ready to downgrade.
Begin the downgrade process by executing:
sp_downgrade 'downgrade', <'version'>
The version number should be the same as the version you entered in step 3. Once the above command completes successfully there can be no more activity on the 15.0.2 server. You must immediately shutdown the 15.0.2 server.
Copy the RUN_SERVER file to the 15.0 or 15.0.1 release area you are downgrading to. Modify the RUN_SERVER file to use the dataserver binary from the 15.0 or 15.0.1 release.
Restart the old server using the modified RUN_SERVER file.
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 only the first time the server
is booted.
Run any scripts that may be applicable to your site listed in the post-downgrade tasks.
These are the tasks needed for downgrade to Adaptive Server 15.0 or 15.0.1 if you have not used any 15.0.2 functionality. If you have used 15.0.2 functionality then follow the additional steps are described in the rest of the section.