Upgrade

You can upgrade to Adaptive Server 15.5 from Adaptive Server versions 15.0 through 15.0.3 (except 15.0.1 Cluster Edition and 15.0.3 Cluster Edition).

If you are installing Adaptive Server 15.5 on top of an earlier 15.x version see Installing version 15.5 over an existing 15.x Adaptive Server.

If you need information on recovering from a failed upgrade see Recovering from a failed upgrade.

Adaptive Server version 15.5 introduces some new system catalogs and some changes to existing catalogs.

The catalog upgrade in 15.5 may affect your existing applications. If you are upgrading, see the Adaptive Server Enterprise New Feature Guide for 15.5 for a complete list of catalogs that are affected.

For a server installation 12.0.x and older, Sybase recommends that you upgrade to version 12.5.4, then upgrade to version 15.5.

You can upgrade Adaptive Server from a 32-bit version to a 64-bit version, but you cannot move from a 64-bit version to a 32-bit version. Likewise, you can upgrade only from an earlier version of Adaptive Server to a more recent version.

Only upgrades to and from the same page size are supported. Changing the server schema from one page size to another is a database migration. See sybmigrate in the Utility Guide for information about migration.

• Preparing to Upgrade
  You must have system administrator privileges to perform an upgrade.
• Preparing the Database and Devices for the Upgrade
  If you ran the pre-upgrade option in preupgrade, the utility scanned the system catalogs and calculated how much additional space needed to perform the upgrade.
• Upgrading to Adaptive Server 15.5
  To assist with the upgrade process, Sybase recommends you set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment variables to point to the old installation of Adaptive Server. If you set these environment variable to the old installation of the Adaptive Server, the upgrade utility automatically populates input fields with the correct information as you upgrade.
• Postupgrade Tasks
  After you have upgraded to the new version of Adaptive Server, perform these tasks to make sure your new Adaptive Server is up and running.
• Reenabling Replication Server After the Dataserver Upgrade
  If you disabled replication before the upgrade, you must reenable replication.
• Reenabling Auditing
  If the server you are upgrading from was configured for auditing, reenable auditing in the upgraded server.
• Upgrading Backup and Monitor Servers
  Before you can upgrade Backup or Monitor Server, you must upgrade Adaptive Server. The procedures for upgrading Backup Server and Monitor Server are similar. XP Server does not have a formal upgrade process.
• Upgrading Java in the Database
  You must run installpcidb script if the Java in the database functionality is currently enabled. This script creates tables and stored procedures in the sybpcidb database.
• Upgrading Job Scheduler
  After upgrading to the new Adaptive Server, perform the following steps to upgrade Job Scheduler.
• Upgrading High Availability and Cluster Support
  There are two ways to upgrade the cluster subsystem.
• Migrating from 32-bit to 64-bit Versions on Different Computers
  To migrate Adaptive Server from the 32-bit to the 64-bit version, first install and configure the 64-bit operating system.
• Upgrading Using Allrows_dss In Parallel
  If you are using the configuration option allrows_dss when upgrading from a 15.0.x version to a 15.0.2 version in parallel mode, the server may stack trace when the optimizer selects a plan that requires tempdb, which has not yet been onlined.
• Recovering From a Failed Upgrade
  Follow these steps after you have fixed the underlying problem that caused the failed upgrade.