Installation guide

Considerations for Component Integration Services
If you have both a local and a remote server running on Adaptive Server version 15.x and are
upgrading both of them to version 15.7 ESD #2, upgrade the local server first. If you plan to
upgrade one server but not the other, upgrade the local server.
Sybase does not certify that Component Integration Services running on earlier versions of
Adaptive Server can connect to later versions. You may encounter errors if an earlier version
of Adaptive Server maps a proxy table to a later version and the remote table uses functionality
that is unavailable in the earlier version.
Sybase certifies that each version of Adaptive Server connects to earlier versions through
Component Integration Services. Component Integration Services is tested and certified to
connect to earlier versions of Adaptive Server.
Preparing to Upgrade
Before you upgrade, run the
preupgrade
utility. You must have system administrator
privileges to perform an upgrade.
If your server is at a 15.x level, do not use the sqlupgrade or sqlupgraderes upgrade utilities.
Each new server version contains features that introduce parameters, commands, reserved
words, and so on. preupgrade prepares the old server by making sure all necessary directories
and settings are correct for the upgrade. When running preupgrade, manually stop and start
the server. You need not start the server before running the sqlupgrade upgrade utility; the
utility starts the server when needed.
• If you are upgrading from:
• Version 12.5.3 with cache bindings on sybsystemdb – drop the cache bindings for
sybsystemdb that are bound to a user-defined cache before you run preupgrade.
• Earlier than version 15.x but later than 12.5.3 – from the Adaptive Server 15.7 ESD #2
installation directory, perform the preupgrade checks on the old server using the
preupgrade utility, located in $SYBASE/ASE-15_0/upgrade.
• Manually drop objects before you execute procedures for the first time. The first time you
run the server after an upgrade, the server internally rebuilds procedures from the text in
syscomments. The procedure may not execute properly if it contains code that drops,
then re-creates, an existing object.
1.
Go to the directory where your current version of Adaptive Server is installed.
2.
Enter cd in to go to the directory ASE-version, where
version is your current version of
Adaptive Server.
3.
Perform cd in to the upgrade directory.
CHAPTER 10: Adaptive Server Upgrades
72 Adaptive Server Enterprise