Downgrading from Adaptive Server 15.7 SP100

Use sp_downgrade to downgrade Adaptive Server 15.7 SP100 to an earlier version.

Prerequisites

Note: Do not use these steps if you are downgrading from Adaptive Server Cluster Edition version 15.7 SP100 to the Cluster Edition version 15.7, 15.7 ESD #1, 15.7 ESD #2, ESD #3, or ESD #4. Instead, see Downgrading to an Earlier Version of Adaptive Server 15.7.

Save the current auditing settings for the 15.7 SP100 Adaptive Server by saving the output of the sp_displayaudit system procedure in all system and user databases where any auditing options have been turned on:
```
1> sp_displayaudit
2> go
```
Back up all of your databases and the $SYBASE release area.

Task

Downgrade from Adaptive Server 15.7 SP100 Cluster Edition to Adaptive Server Cluster Edition versions 15.5 or 15.7. Downgrading to earlier versions of Adaptive Server is not supported.

Note: The sybcluster utility does not have a built-in tool to perform an upgrade or downgrade between two versions of Adaptive Server Cluster Edition.

If you have used pluggable component interface (PCI) functionality, and are downgrading to a version of the 15.0.1 Cluster Edition or a 15.0.1 Cluster Edition ESD, drop the sybpcidb database and restart the old server binary.
If you are downgrading to version 15.0.3 Cluster Edition, re-run installpcidb and restart the old server binary.
Start the 15.7 SP100 Cluster Edition server in single-user mode, with only one instance running, using dataserver -m option to guarantee that no other user can access Adaptive Server while you are performing the downgrade. See Utility Guide for more details on starting the server in single-user mode.
Make sure Adaptive Server 15.7 SP100 is prepared for downgrade by executing this command from the master database:
```
sp_downgrade 'prepare', @toversion='version'
```
For downgrade purposes, Cluster Edition is differentiated from a nonclustered Adaptive Server by a "5" at the end of the version string regardless of the version to which you want to downgrade. If you are downgrading to Adaptive Server Cluster Edition version 15.5, for example, specify your target version as "15.5.0.5". You may omit the periods and use "15505", but the number must still end with a 5. Otherwise, the procedure assumes "0" as the final digit, indicating a nonclustered Adaptive Server. This produces an error, as you cannot downgrade from Cluster Edition to any nonclustered server.
Make sure Adaptive Server 15.7 SP100 Cluster Edition is prepared for downgrade by executing sp_downgrade from the master database:
```
sp_downgrade 'prepare', @toversion=<'version'>
, @override = 1
```
Write the value of "version" as "15.0.1.5", "15015", "15.0.3.5", or "15035". The version you enter is the version to which you are downgrading.

sp_downgrade 'prepare' validates the readiness of Adaptive Server 15.7 SP50 PL00 for downgrade. It may print messages regarding manual changes required before the downgrade can be completed. Repeat this step, correcting any errors reported, and make sure you understand the implications of all warnings before proceeding.
Execute the following, where version is the same number you used in the previous step:
sp_downgrade 'downgrade', @toversion='version', @override=1
Once this procedure completes successfully, there can be no more activity on the 15.7 SP100 server. Run checkpoint and immediately issue the shutdown command to shut down the cluster.

Note: Since Adaptive Server 15.7 SP100 transaction logs may contain data that older server versions cannot interpret correctly, all transactions in all databases must be completed to prevent the older server from recovering any transactions. To ensure that all transactions are completed, issue the normal shutdown command, and not the shutdown with nowait command, after running sp_downgrade.
Copy the RUN_SERVER file to the release area of the version to which you are downgrading. Modify the RUN_SERVER file to use the dataserver binary from the release area of the version to which you are downgrading. Remove the -m option when you modify the RUN_SERVER file or ensure the server is not running in single-user mode.
Extract the quorum device using:
```
qrmutil --quorum-dev=<dev> --extract-config=quorum.out 
```
If you are downgrading to Cluster Edition version 15.0.1 or a 15.0.1 ESD, comment out these two lines in quorum.out:
```
#installation mode=shared
#membership mode=
```
Rebuild the new quorum device with the old quorum device backup you created by adding this to the dataserver parameters:
```
--buildquorum=force --cluster-input=quorum.out
```
Restart the old server by first connecting to the cluster in sybcluster by running connect to cluster_name.
After you connect to the cluster and the cluster name appears at the prompt, issue the following to start Aadptive Server:
```
start cluster
```
Note: If you restart a downgraded server using the 15.7 configuration file, the new options cause the message Unknown parameter. This message is reported only the first time the server is started. When downgrading to a 15.0.1 Cluster Edition server, user passwords may be reset and printed on the console. Save the output of sp_downgrade 'downgrade', <version> into a file so that the passwords are not lost. The old passwords do not work. Otherwise, you must restart the downgraded server with -psa to regenerate the sa password.
Depending upon whether you are starting from a fresh installation or from a previously upgraded 15.x installation, run previously saved restore_msgs.ebf or instmsgs.ebf from 15.0.1 Cluster Edition or 15.0.3 Cluster Edition if none were saved, before running installmaster for the Cluster Edition.
```
isql -Usa -Psa_password -irestoremsgs.ebf
```
Restart all instances of the cluster.
Run any post-downgrade scripts that may be applicable to your site, including installmaster and instmsgs.ebf.
To restore the original messages for the 15.0.x version of Adaptive Server, run this script after downgrading the server:
```
isql -Usa -Psa_password -irestoremsgs.ebf
```

If you have not used any 15.7 SP100 functionality, this completes the primary downgrade process.