Installation guide

The default RUN_servername file for a server SYBASE is called RUN_SYBASE. If the
RUN_servername file for your current server is named differently, use the actual name
of your server during the upgrade process.
5.
Verify that the text of all stored procedures you upgrade is available in syscomments by
either:
• Reinstalling the procedures with text, or,
• Removing and reinstalling the procedures after the upgrade.
This step can allow you to inspect the stored procedures for any hidden or unwanted text.
6.
Set the 'allow password downgrade' password policy option to 1 to ensure that passwords
are encrypted with both the old and new algorithms, in case you need to downgrade to an
earlier version of Adaptive Server.
7.
Make sure reserved words use quoted identifiers.
8.
Verify that users are logged off.
9.
Use dbcc to check for database integrity.
10.
Back up databases.
11.
Dump the transaction log.
12.
Verify that master is the default database for the "sa" user.
13.
Prepare the database and devices for upgrade using the preupgrade utility:
a) Create a sybsystemdb database if it does not already exist.
b) Disable auditing by running sp_configure 'auditing', 0.
c) Disable Job Scheduler.
d) Obtain the current audit settings for the pre-15.7 Adaptive Server using
sp_displayaudit; you use this saved information to reenable auditing after you
complete the installation. See
Reenabling Auditing on page 90.
e) Disable disk mirroring.
f) Verify that your SYBASE environment variable points to the location of the new server
software files you just installed.
Set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment
variables to the location of the server you are upgrading, to avoid having to type this
path when you run sqlupgrade.
Fix any problems that preupgrade utility reports.
You can safely ignore any warnings Adaptive Server issues about configuration
parameters not being set to the default, as these are only for your information.
14.
Ensure that the procedure cache size is at least 150 percent of the default procedure cache
size, or between 53,248 and 2,147,483,647 2K pages.
15.
Copy these files from earlier versions of the server to their corresponding Adaptive Server
15.x installation locations:
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 75