Sybase Adaptive Server 15.0.2, Installation Manual

Page: 76 / 160

Pre-upgrade tasks
62
Adaptive Server Enterprise
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.
1 Check system and upgrade requirements.
2 Check RUN_server file location.
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 Stored procedure text in the
syscomments
table is required for upgrade.
5 Reserved words are resolved using quoted identifiers.
6 Verify that users are logged off.
7 Check database integrity.
8 Back up databases.
9 Dump transaction log.
10 Make sure that master is the default database for the “sa” user.
11 Prepare 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.