Pre-upgrade tasks

Before you begin the upgrade process, install the Cluster Edition onto your system in a new location.

NoteThe upgrade process modifies the sysaudits tables in the sybsecurity database. Sybase recommends that you archive any auditing data and truncate these tables before you upgrade. This reduces the chances of a failed upgrade due to lack of space in the sybsecurity database.

To ensure a successful upgrade, review the following pre-upgrade tasks and perform them as necessary. Depending on the old server configuration, you may not need to perform all pre-upgrade tasks. This list summarizes the preupgrade tasks; there is additional information for some of these tasks in the sections that follow.

  1. Check system and upgrade requirements.

  2. Check the location of the RUN_server file.

  3. If you are upgrading Adaptive Server, the previously installed version of the server must be running. If you are upgrading Backup Server, Historical Server, Monitor Server, or XP Server, those servers must not be running.

  4. Store procedure text in the syscomments table is required for upgrade. See “Procedure text is required for upgrade”.

  5. Resolve reserved words using quoted identifiers. See “Reserved words”.

  6. Verify users are logged off.

  7. Check for database integrity.

  8. Back up the databases.

  9. Dump the transaction log.

  10. Ensure that master is the default database for the “sa” user.

  11. Prepare the database and devices for upgrade.

  12. If the $SYBASE directory is not the same as the old $SYBASE directory, copy the following files from earlier versions of Adaptive Server to their corresponding Cluster Edition installation: