Perform the following steps to upgrade to Adaptive Server release 12.5.1 on a new machine that is running IBM AIX 5.1.
Complete the tasks described in the pre-upgrade section in the Adaptive Server Installation Guide for upgrading Adaptive Server release 12.0.x.
This document refers to the Adaptive Server release 12.0.x release area as “OLDSYBASE,” and the Adaptive Server release 12.5.1 release area as “NEWSYBASE.”
Make sure the new AIX 5.1 machine has the necessary patches, as described operating system requirements section of the Adaptive Server Installation Guide.
Install the 64-bit Adaptive Server version 12.5.1 for AIX 5.1 along with appropriate languages on the new machine, following the instructions in the Adaptive Server Installation Guide.
Setup your environment by running SYBASE.csh or SYBASE.sh from NEWSYBASE (described Adaptive Server Installation Guide.
Copy the 12.0.x server interfaces definition from the interfaces file in OLDSYBASE to the interfaces file in NEWSYBASE.
Run installupgrade on the 12.0.X ASE server using the following command:
isql -Usa – P <sa password> -S <12.0.x server name> -i $NEWSYBASE/ASE-12_5/scripts/installupgrade
Run a reserve words check using sp_checkreswords installed on the release 12.0.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.0.x server name> sp_checkreswords
See the pre-upgrade section in the release 12.0.x Adaptive Server Installation Guide for more information.
Run the $NEWSYBASE/ASE-12_5/bin/preupgrade binary. preupgrade reports the necessary modifications to the 12.0.x Adaptive Server for a successful upgrade to 12.5.x:
$NEWSYBASE/ASE-12_5/upgrade/preupgrade -U sa -P<sa password> -S <12.0.x server name>
You must make these changes to successfully upgrade to 12.5.x
Move the physical database devices from the 12.0.x IBM 4.3.3 machine to the IBM 5.1 machine. Change the physical paths of logical devices in the master database of the 12.0.x server so they point to new paths on the AIX 5.1 machine.
Checkpoint all the databases and shutdown the 12.0.x server.
Copy the following files to the new AIX 5.1 machine:
All the devices that constitute the database devices in the 12.0.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 12.5.1Adaptive Server on the new AIX 5.1 machine using the modified RUN_SERVER file.
Run the upgrade binary:
$NEWSYBASE/ASE-12_5/upgrade/upgrade -U sa -P<sa password> -S <12.5.1servername>
After the upgrade, shutdown and then reboot the release 12.5.1 Adaptive Server.
Install the following scripts to the release 12.5.1 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 the “Upgrading Sybase Servers” chapter of the Adaptive Server Installation Guide.
If you are using languages other than the default, perform the steps described in “Custom Installation” of the Adaptive Server Installation Guide to configure these languages. You must run the sqlloc utility to upgrade these languages.
Complete any additional post upgrade tasks defined in the AIX 5.1-64 bit Release Bulletin.
