Perform the following steps to upgrade to Adaptive Server version 15.0 on a new machine that is running IBM AIX 5.2.
Complete the tasks described in “Pre-upgrade tasks” for upgrading Adaptive Server release 12.x
This document refers to the Adaptive Server release 12.x release area as “OLDSYBASE”, and the Adaptive Server version 15.0 release area as “NEWSYBASE”.
Make sure the new AIX 5.2 machine has the necessary patches, as described in “System requirements”.
Install the 64-bit Adaptive Server version 15.0 for AIX 5.2 along with appropriate languages on the new machine, following the instructions in this installation guide.
Setup your environment by running SYBASE.csh or SYBASE.sh from NEWSYBASE.
Copy the 12.x server interfaces definition from the interfaces file in OLDSYBASE to the interfaces file in NEWSYBASE.
Run installupgrade on the 12.x Adaptive Server using the following command:
isql -Usa – P <sa_password> -S <12.x_server_name> -i $NEWSYBASE/ASE-15_0/scripts/installupgrade
Run a reserve words check using sp_checkreswords installed on the release 12.x Adaptive Server, and resolve any conflicts it reports. Enter the following to run the reserve words check:
isql -Usa – P<sa_password> -S <12.x_servername> sp_checkreswords
See “Pre-upgrade tasks” for more information.
Run the $NEWSYBASE/ASE-15_0/bin/preupgrade binary. preupgrade reports the necessary modifications to the 12.x Adaptive Server for a successful upgrade to 15.0:
$NEWSYBASE/ASE-15_0/upgrade/preupgrade -U sa -P<sa_password> -S <12.x_servername>
You must make these changes to successfully upgrade to 15.0.
Move the physical database devices from the 12.x IBM 4.3.3 machine to the IBM 5.2 machine. Change the physical paths of logical devices in the master database of the 12.x server so they point to new paths on the AIX 5.2 machine.
Checkpoint all the databases and shutdown the 12.x server.
Copy the following files to the new AIX 5.2 machine:
All the devices that constitute the database devices in the 12.x server to new paths, as reflected in step 9.
$OLDSYBASE/ASE-12_5/install/RUN_SERVER file. Make the necessary modifications to the entry to reflect the new path names for the master device, dataserver binary, configuration file, error log file, and so on.
The interfaces file (typically resides in OLDSYBASE). Make sure these entries are updated to reflect the new machine name, port, and so on.
$OLDSYBASE/ASE-12_5/install/SERVER.log (to keep the history).
$OLDSYBASE/ASE-12_5/SERVER.cfg – configuration file for the Adaptive Server.
Any other configuration file (for example, libtcl.cfg).
Start the release 15.0 Adaptive Server on the new AIX 5.2 machine using the modified RUN_SERVER file.
Run the upgrade binary:
$NEWSYBASE/ASE-15_0/upgrade/upgrade -U sa -P<sa_password> -S<15.0_servername>
After the upgrade, shutdown and then reboot the 15.0 version of Adaptive Server.
Install the following scripts to the release 15.0 Adaptive Server:
installmaster
installmsgs
installsecurity (if you installed auditing)
installhasvss (if you installed high availability)
installdbccdb (if you configured dbccdb)
See the System Administration Guide for information about installing these scripts.
Upgrade any compiled objects (described in “Upgrading Sybase Servers” chapter of the Adaptive Server Installation Guide).
Complete all post-upgrade tasks, as defined “Post-upgrade tasks”.
If you are using languages other than the default, perform the steps described in “Installation methods” to configure these languages. You must run the sqlloc utility to upgrade these languages.
Complete any additional post upgrade tasks defined in the Release Bulletin for IBM AIX.