You need the master and system procedures files to upgrade the server. By default, the master (master.dat)
and system procedures device (sybsytemprocs.dat)
files are installed in the
$SYBASE/data directory.
Note: 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.
Ensure that the directory to which your TEMP environment
variable points exists. The installation program uses the directory
to write files temporarily during the installation, which it locates
through the TEMP environment variable.
Verify the name and location of the runserver file.
Verify that the runserver file is
renamed RUN_servername, where servername is
the name of the old server.
The servername must
appear exactly as it appears in the interfaces file. The RUN_servername file
for a server SYBASE is called RUN_SYBASE.
If the RUN_servername file for your
current server is named differently, change the
name during the upgrade process.
To upgrade
stored procedures, the stored procedure text must be available in syscomments. Do one of the following:
Reinstall the procedures with text.
Remove them and reinstall them after the upgrade.
Set the password policy
option 'allow password downgrade' to 1. Then passwords
are encrypted with old and new algorithms aiding in transition should
you ever downgrade to an earlier version.
Reserved words are resolved using quoted identifiers.
Verify that users are logged off.
Check database integrity.
Back up databases.
Dump the transaction log.
Make sure that master is the default database for the “sa” user.
Prepare the database and devices for upgrade using the preupgrade utility.
Create a sybsystemdb database
if it does not already exist.
Disable auditing using the command:
sp_configure 'auditing', 0
Save the current audit settings for the pre-15.5 Adaptive
Server using the command:
sp_displayaudit
Disable disk mirroring.
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.
Disable Job Scheduler.
Ensure that the procedure cache size is at a minimum
of 150 percent of the default procedure cache size, or between 53248
and 2147483647 2K pages.
Copy the following files from earlier versions of the server to their corresponding Adaptive Server 15.x installation location.
$SYBASE/interfaces
$SYBASE/$SYBASE_ASE/<servername>.cfg
$SYBASE/$SYBASE_OCS/config/libtcl.cfg
$SYBASE/SYSAM-2_0/licenses/license.lic
If the Java in the database feature is enabled, create the sybpcidb database.
The sybpcidb database stores configuration information
for the Pluggable Component Interface (PCI) and all Pluggable Component
Adapter (PCA) components. This database is used by installpcidb script.
For example:
1> disk init
2> name = “sybpcidb_dev”,
3> physname = “${SYBASE}/data/sybpcidb_dev.dat”,
4> size = '24MB'
5> go
1> create database sybpcidb on sybpcidb_dev = 24
2> go
Set the environment variables by sourcing the SYBASE.[csh,
sh, env]. file.
Running the environment variable script multiple
times can cause problems. Only run it once.