Special Downgrade Instructions

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

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.