Preparing to Downgrade Adaptive Server

Prepare your system before starting the downgrade.

• If the logical page size for your Adaptive Server is larger than 8192 bytes and you have configured any databases to allow wide data-only-locked rows, turn the option off:

  sp_configure @dbname, 'allow wide dol rows', false

  Before you downgrade Adaptive Server, verify that no wide DOL rows exist in any table in these databases. Adaptive Server cannot find them, and thus does not warn you about their existence. When you then downgrade to a version that is earlier than 15.7, Adaptive Server treats these as corrupt.

  This does not occur if your logical page size is 8192 bytes or smaller.

• If you have configured any database to use either row or page compression, turn it off:

  alter database @dbname set compression none

• If any database has non-zero, in-row large object (LOB) lengths, set it to zero:

  alter database @dbname set inrow_lob_length = 0

• If any table is configured to use compression, turn it off:

  alter table @tablename set compression = none
  reorg rebuild @tablename

• If any table uses LOB compression or uses in-row LOBs:
  1. Copy the data from that table to a new table
  2. 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, sp_downgrade displays an error 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 whatever device you prefer, as long as you specify the number of indicated pages as being at least as large as the num value.