Sybase 15.0.2 manual Pre-upgrade tasks

Pre-upgrade tasks

Pre-upgrade tasks

Note Before you begin the upgrade process, install Adaptive Server 15.0.2 onto your system.

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.

1Check system and upgrade requirements.

2Check RUN_server file location.

3If 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.

4Stored procedure text in the syscomments table is required for upgrade.

5Reserved words are resolved using quoted identifiers.

6Verify that users are logged off.

7Check database integrity.

8Back up databases.

9Dump transaction log.

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

11Prepare the database and devices for upgrade using the preupgrade utility.

•Create a sybsystemdb database.

•Disable auditing using the command:

sp_configure 'auditing', 0

Save the current audit settings for the pre-15.0.2 Adaptive Server using the command:

sp_displayaudit

•Disable disk mirroring.

•Verify that your SYBASE environment variable points to the location of the new Adaptive Server software files you just unloaded.

62 Adaptive Server Enterprise