Upgrading Adaptive Server

Learn about how to upgrade Adaptive Server.

A minor change was made to the format of a log record in both the cluster and non-cluster editions of Adaptive Server 15.5 that introduces an unlikely possibility for Adaptive Server to misinterpret this changed log record in cases where the upgraded server contains a database that is the primary database for replication.

This change should not affect your upgrade process; however, it requires that some steps be strictly followed when you move from Adaptive Server 15.0.x or earlier to Adaptive Server 15.5.x (non-cluster editions). See the following table for all possible combinations of upgrades.

An upgrade is done by:
  1. Upgrading your entire installation by switching binaries.
  2. Upgrading a single database using online database having first loaded it with a database dump and transaction logs taken on a server on a lower version.
Upgrading Your Entire Installation
Current version Upgrading to Special Upgrade Information
Adaptive Server 15.0.x or earlier Adaptive Server 15.5.x

If you are using Replication Server to replicate one or more databases in the installation to be upgraded, then ensure that all transactions have been replicated before the polite shutdown is done, by draining the log, See the section, "Upgrading Adaptive Server in a replication system" in Chapter 3 of the configuration guide for your platform in the Replication Server documentation for more information on this. Also, see "Upgrading Servers With Replicated Databases" in the chapter on "Upgrade" in the Adaptive Server installation guide for your platform.

Adaptive Server 15.0.x Adaptive Server Cluster Edition 15.5.x

If you are using Replication Server to replicate one or more databases in the installation to be upgraded, then ensure that all transactions have been replicated before the polite shutdown is done, by draining the log, See the section, "Upgrading Adaptive Server in a replication system" in Chapter 3 of the configuration guide for your platform in the Replication Server documentation for more information on this. Also, see "Upgrading Servers With Replicated Databases" in the chapter on "Upgrade" in the Adaptive Server installation guide for your platform.

Adaptive Server 15.5.x Adaptive Server Cluster Edition 15.5.x

Not supported.

Adaptive Server Cluster Edition 15.5.x Adaptive Server 15.5.x

Not supported.

Upgrading a single database
Current version Upgrading to Special Upgrade Instructions
Adaptive Server 15.0.x and earlier Adaptive Server 15.5.x

When you use online database to upgrade a single database in Adaptive Server 15.5.x (either the cluster or noncluster edition) after loading a database dump and transaction logs from Adaptive Server 15.0.x or earlier, and if the database you are upgrading is also replicated, make sure the database's transaction log is truncated before you turn replication back on.

See the section "Reenabling Replication Server After the Dataserver Upgrade" in the "Upgrade" chapter in the Adaptive Server installation guide for your platform.

Adaptive Server 15.5.x Adaptive Server Cluster Edition 15.5.x

Upgrading a single database from the non-cluster edition of 15.5 or 15.5 ESD 1 to cluster edition of 15.5 or 15.5 ESD 1 is supported, and no particular steps must be emphasized in order to ensure a smooth upgrade.

Adaptive Server Cluster Edition 15.5.x Adaptive Server 15.5.x

Upgrading a single database from Adaptive Server Cluster Edition version 15.5 or 15.5 ESD 1 to the non-cluster 15.5 or 15.5 ESD 1 versions is not supported and its prevention is enforced by Adaptive Server.