Learn about special downgrading instructions for this version of Adaptive Server.
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.
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
Use the following step to downgrade Cluster Edition 15.7 ESD #2 to ESD #1 using sybcluster:
This allows you to keep the 15.7 ESD #2 version of sybcluster for use after the downgrade.