You must perform these upgrade steps on the current ASE 12.0.x server running IBM AIX-4.3.3 before upgrading the operating system to IBM-AIX 5.1:
Download the following files from the Sybase web (http://www.sybase.com) to a work directory (this directory is refered to as WORKDIR for the remainder of the steps):
Installupgrade-12.5.1
Preupgrade-12.5.1
Make sure you have performed all the pre-upgrade steps described in the “Upgrading Sybase Servers” chapter of the Adaptive Server Installation Guide, and the release 12.0.x Adaptive Server is running.
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.”
Run installupgrade on the release 12.0.X Adaptive Server:
isql -Usa – P <sa password> -S <12.0.x server name> -i $WORKDIR/installupgrade-12.5.1
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 $WORKDIR/preupgrade-12.5.1 binary. This binary suggests the necessary modifications for the 12.0.x server to successfully upgrade to release 12.5.x:
$WORKDIR/ASE-12_5/upgrade/preupgrade -U sa -P<sa password> -S <12.0.x servername>
Make modifications to the release 12.0.x Adaptive Server as suggested until this pre-upgrade check is successful.
Checkpoint all the databases and shutdown the 12.0.x server.
Upgrade the machine to IBM AIX 5.1, and make sure the new AIX 5.1 machine has the necessary patches described in the “Operating System Requirements” section of the Adaptive Server Installation Guide.
Install the 64-bit Adaptive Server release 12.5.1 for AIX 5.1, along with appropriate languages, using 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.
Copy the following files to the new AIX 5.1 machine:
· $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.
