Installation guide

alter table @tablename set compression = none
reorg rebuild @tablename
• If any table uses LOB compression or in-row LOBs:
a) Copy the data from that table to a new table.
b) Drop the original table.
• If any table was altered to include nonmaterialized columns, convert those columns to
standard columns:
reorg rebuild @tablename
• If there are any holes in the log from previous alter database log off commands, remove
the holes by using alter database log on to extend the log.
If you do not perform this before the downgrade, you see a message similar to:
Error: Database 'dbname' contains num hidden pages that have to be
filled.
Please, use ALTER DATABASE LOG ON command to extend the log num
pages.
You can extend the log on any device, as long as you specify the number of indicated pages
as being at least as large as the
num value.
Downgrading from Adaptive Server 15.7 ESD #2
Use sp_downgrade to downgrade Adaptive Server 15.7 ESD #2 to an earlier version.
Prerequisites
Note: Do not use these steps if you are downgrading from Adaptive Server version 15.7 ESD
#2 to either version 15.7 or 15.7 ESD #1. Instead, see
Downgrading to an Earlier Version of
Adaptive Server 15.7 on page 108.
1.
Save the current auditing settings for the 15.7 ESD #2 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
2.
Back up all of your databases and the $SYBASE release area.
Task
Downgrade from Adaptive Server 15.7 ESD #2 to an Adaptive Server 15.0, 15.0.1, 15.0.2,
15.0.3, or 15.5. Downgrading to versions of Adaptive Server earlier than 15.0 is not supported.
1.
Start the 15.7 ESD #2 server in single-user mode using dataserver -m to guarantee that no
other user can access Adaptive Server while you are going through the downgrade steps.
See the
Utility Guide for more details on starting the server in single-user mode.
CHAPTER 11: Adaptive Server Downgrades
106 Adaptive Server Enterprise