Before you begin the upgrade process, install Adaptive
Server 15.0.3 onto your system.
If your server has replicated databases, consult “Upgrading Servers with Replicated Databases,” before
starting the pre-upgrade tasks.
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.
Check system and upgrade requirements.
Check RUN_server file location.
Read the password encryption algorithm documentation for 15.0.2 in the Adaptive Server Enterprise New Features Guide for 15.0.2. You should 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.
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.
Stored procedure text in the syscomments table is required for upgrade.
Reserved words are resolved using quoted identifiers.
Verify that users are logged off.
Check database integrity.
Back up databases.
Dump 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.0.3 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 installed.
You also can set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment variable to the location of the server you are upgrading, to avoid having to type this path when you run syconfig.exe.
Disable Job Scheduler.
If you do not disable Job Scheduler the path for Windows platforms must be specified in detail:
Copy %OLDSYBASE%\%OLDSYBASE_OCS\ini\libtcl.cfg to %SYBASE%\%SYBASE_OCS\ini\libtcl.cfg.
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 Adaptive Server to their corresponding Adaptive Server 15.x installation.
For Windows platforms:
%SYBASE%\ini\sql.ini
%SYBASE%\SYBASE_ASE\<servername>.cfg
%SYBASE%\%SYBASE_OCS%\ini directory
%SYBASE%\ini\libtcl.cfg
If the Java in database feature is enabled, create 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
