Installation guide

Additional Considerations for New Features Used
Additional downgrade steps may be necessary due to Adaptive Server 15.7 or later features
that are unavailable in the Adaptive Server version to which you are downgrading.
In general, no additional steps are required when you are returning to an Adaptive Server
version in which the feature was already available.
Returning to 15.0.2 ESD #3 is easier than downgrading to other versions, because this version
can handle a number of error conditions that may arise as a result of downgrading.
If you return to a pre-15.0.2 ESD #3 version of Adaptive Server, no error handling is provided.
Using the new features can result in inexplicable behavior, including misleading error
messages and stack traces, unless you are uninstall all usages of the new features reported by
sp_downgrade
.
Feature Considerations
Wide, varia-
ble-length da-
ta-only-
locked (DOL)
rows
You cannot downgrade versions that contain wide, variable-length DOL rows to
versions that do not support the feature.
Use the dol_downgrade_check function to determine if a database includes tables
with wide, variable-length DOL rows. See
Reference Manual: Building Blocks .
If you:
1. Disable the allow wide dol rows database option before performing a database
or transaction log dump, then
2. Load these database dumps onto an earlier version of Adaptive Server
Data returned from queries on the wide rows may be incorrect, or queries might fail
because the earlier version of Adaptive Server perceives the data rows as corrupt.
Java in Adap-
tive Server
• User classes compiled by a Java version later than 1.2 do not work in pre-15.0.3
Adaptive Server versions.
• Earlier versions of Adaptive Server ignore the enable pci parameter; you can
remove it.
• The sybpcidb database is not used by Adaptive Server versions earlier than
15.0.3, and may be dropped.
sp_addserver
with filter pa-
rameter
If you have any entries in sysservers.srvnetname column that are longer
than 32 bytes, delete these entries before downgrading, and add them back after
downgrading.
CHAPTER 11: Adaptive Server Downgrades
Installation Guide 111