Installation guide
stored procedures introduced in releases subsequent to the downgraded server are not
removed.
Warning! Executing new stored procedures against an older binary may cause
unpredictable results.
2.
During the upgrade to Adaptive Server 15.7 ESD #2, you should have created a
restore_msgs.ebf file. Run this script now to restore your messages back to the
version from which you upgraded:
isql -Usa -P <sa_password> -S <server_name> -i
<restore_msgs.ebf>
Note: If you upgraded from a version 15.0 or 15.0.1 and are reverting back to 15.0 or
15.0.1, run instmsgs.ebf file only from the relevant release.
3.
The on-disk structures of stored procedures, triggers, and views may contain statement
identity tokens, datatypes, and object references that are not understood by the earlier
Adaptive Server versions. You must drop all compiled objects that use features introduced
into Adaptive Server subsequent to the version to which you are downgrading.
4.
If during the upgrade process you ran
update all statistics
on syslogins, you must
delete statistics
for syslogins and re-create them.
spt_values
are dropped and re-created when you run
installmaster
from the release area
you downgraded to. Any new types are eliminated from this table.
5.
Run installmaster from the release area of the server to which you downgraded to remove
configuration parameters that belong to 15.7 ESD #2, by deleting
sysconfigures
rows for
configuration parameters that do not exist in syscurconfigs. After running
installmaster, the error messages no longer appear when you start the server.
If you start a downgraded server using the 15.7 ESD #2 configuration file, the new options
generate an Unknown parameter message. The unknown options are reported the first
time you restart the server. You can ignore these messages; the configuration file is
rewritten without the unknown options.
Note: Keywords decrypt_default, xmltable, and path were added in Adaptive Server 15.5
Cluster Edition, making it impossible to create identifiers using these names. You must
change applications if you used these names.
See also
•
Additional Considerations for New Features Used
on page 111
•
Reenabling Replication Server After the Dataserver Upgrade
on page 90
CHAPTER 11: Adaptive Server Downgrades
Installation Guide 115