Special Downgrade Instructions

Learn about special downgrading instructions for this version of Adaptive Server.

Use sp_downgrade_esd to Downgrade Fom Adaptive Server 15.7 SP100 to Earlier Versions

If you are downgrading from Adaptive Server 15.7 SP100 to 15.7 ESD #4, 15.7 ESD #3, 15.7 ESD #2, 15.7 ESD #1 and 15.7, use sp_downgrade_esd(not sp_downgrade) to downgrade both Adaptive Server and any databases you may have upgraded to 15.7 SP100. See Downgrading to an Earlier Version of Adaptive Server 15.7 in the installation guide for your platform.

Downgrading Cluster Edition From 15.7 ESD #2 to ESD #1 with sybcluster

Use the following step to downgrade Cluster Edition 15.7 ESD #2 to ESD #1 using sybcluster:

  1. Back up $SYBASE for 15.7 ESD #2.
  2. Restart the cluster in single-user mode.
  3. Run sp_downgrade_esd on each database.
    Note: For temporary databases,  running sp_downgrade_esd is optional.
  4. Install 15.7 ESD #1 on top of the current $SYBASE.
    Note: Do not configure SCC from the installer.
  5. Replace SCC-3_2 from the backup copy of 15. 7 ESD #2 $SYBASE.
    Note: This allows you to keep the 15.7 ESD #2 version of SCC for use after the downgrade.
  6. Replace SDCADMIN-15_0 from the backup copy of 15.7 ESD #2 $SYBASE.

    This allows you to keep the 15.7 ESD #2 version of sybcluster for use after the downgrade.

  7. Start the SCC agent on each node.
  8. Run sybcluster and execute start instance <instance 1> to bring up the first instance.
  9. Run installmaster on the first instance.
  10. Run sybcluster and execute shutdown cluster.
  11. Run sybcluster and execute start cluster.
Parent topic: Special Upgrade and Downgrade Instructions