Special Downgrade Instructions

Use sp_downgrade_esd to downgrade from Adaptive Server 15.7 ESD #2 to either 15.7 or 15.7 ESD#1

If you are downgrading from Adaptive Server 15.7 ESD #2 to either 15.7 or 15.7 ESD #1, do not use the sp_downgrade system procedure. Instead, use sp_downgrade_esd to downgrade both Adaptive Server, as well as any databases you may have upgraded to 15.7 ESD #2. See Downgrading to an Earlier Version of Adaptive Server 15.7 in the installation guide for your platform.

sp_downgrade_esd does not check tables which are configured for in-row LOB compression

When downgrade from Adaptive Server 15.7 ESD #2 to either 15.7 ESD #1 or 15.7, sp_downgrade_esd does not check tables when data compression and LOB compression is enabled for tables with in-row LOB column .

Workaround: Manually run the following query on each database to check for in-row LOB compressed tables. This query reports table names configured for in-row LOB compression.

select distinct convert(varchar(39), o.name) as 'check these tables' 
from syscolumns c, sysobjects o, syspartitions p 
where o.id = c.id and o.id = p.id 
and (o.sysstat3 & 28672 != 0 
    or (p.ptndcompver is not null and p.ptndcompver > 0)) 
and ((c.lobcomp_lvl is not null and c.status2 & 131072 = 0) 
    or ((o.lobcomp_lvl is not null and o.lobcomp_lvl > 0) 
        or (o.sysstat3 & 2048 != 0)) 
    or (p.lobcomp_lvl is not null and p.lobcomp_lvl > 0)) 
and (c.inrowlen is not null) and (c.inrowlen > 0) 
go

Note: The correct procedure to downgrade in-row LOB compressed tables is to set compression = none using alter table and run reorg rebuild for each table before downgrade.

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:

Backup $SYBASE for 15.7 ESD #2.
Restart the cluster in single user mode.
Run sp_downgrade_esd on each database.
Install 15.7 ESD #1 on top of the current $SYBASE.
Note: Do not configure SCC from the installer.
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.
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.
Start the SCC agent on each node.
Run sybcluster and execute start instance <instance 1> to bring up the first instance.
Run installmaster on the first instance.
Run sybcluster and execute shutdown cluster.
Run subcluster and execute start cluster.