Manually upgrading to the Cluster Edition

Start the Cluster Edition in a single instance until the upgrade is complete.

Back up all old databases.

Start the earlier version of Adaptive Server:

Move to the old $SYBASE directory
```
cd $SYBASE
```
Source SYBASE.sh (Bourne shell) or SYBASE.csh (C shell).
```
source SYBASE.csh
```

Execute the runserver file:

$SYBASE/$SYBASE_ASE/install/RUN_server_name

In another window, change to the new $SYBASE directory

Source SYBASE.sh (Bourne shell) or SYBASE.csh (C shell) in the new $SYBASE directory:

source SYBASE.csh

Run the preupgrade test on the old server using the preupgrade utility, located at $SYBASE/ASE-15_0/upgrade. The server configuration resides in $SYBASE/$SYBASE_ASE in the old release directory.

Do not change the default packet size from 512 to 2048 until after the upgrade is complete.

If during pre-upgrade the default network packet size is set to 2048 then you cannot login to finish the pre-upgrade on a 12.5.x server because there is no way to tell preupgrade to use 2048 bytes as a packet size.

Execute the following, where password is the system administrator’s password:
```
$SYBASE_ASE/upgrade/preupgrade -Sserver_name -Ppassword
```
Correct all errors from the output of the preupgrade test. Re-run preupgrade until it succeeds without errors.
Restart the old Adaptive Server, if required.

Run the reserved word check on the Cluster Edition:

Install the Cluster Edition version of installupgrade:

isql -Usa -Ppassword -Sserver_name 
-i$SYBASE/$SYBASE_ASE/scripts/installupgrade

Install the Cluster Edition version of usage.sql:

isql -Usa -Ppassword -Sserver_name 
-i$SYBASE/$SYBASE_ASE/upgrade/usage.sql

Log in to the old Adaptive Server and execute sp_checkreswords on all databases:
```
use sybsystemprocs
go
sp_checkreswords
go
```
Correct any errors the reserved word check reveals.

Shut down the old Adaptive Server.

Create the cluster input file. For example the file 'mycluster.inp':

[cluster]
name = mycluster
max instances = 2
master device = /dev/raw/raw101
config file = /sybase/mycluster.cfg
interfaces path =
traceflags =
primary protocol = udp
secondary protocol = udp

[management nodes]
hostname = blade1
hostname = blade2

[instance]
id = 1
name = ase1
node = blade1
primary address = blade1
primary port start = 38456
secondary address = blade1
secondary port start = 38466
errorlog = /sybase/install/mycluster_ase1.log
interfaces path = /sybase/
traceflags =
additional run parameters =

For an example of what this input file must contain, see “Creating the cluster input file” for more information.

Copy the old Adaptive Server configuration file (server_name.cfg) from the old $SYBASE directory to the new $SYBASE directory
Add an additional entry to the interfaces file for each of the instances in your cluster input file (described in Step 9). See “Configuring the interfaces file” for more information.
Determine the raw device used for the quorum device. For the version of the Cluster Edition, use a raw device on shared disks. Do not use a file- system device.
Create the quorum device and start the new instance with the old master device:
```
$SYBASE/$SYBASE_ASE/bin/dataserver\
--instance=ase1\
--cluster_input=mycluster.inp\
--quorum_dev=/dev/raw/raw101
--buildquorum
```
The instance_name you indicate with the --instance parameter must be the name of one of the instances in the new cluster, and the interfaces file must contain an entry for this instance. Any additional options such as -M must be present in the RUN_FILE as dataserver won’t read them from the quorum. For complete dataserver documentation see the Users Guide.
Run the upgrade utility:
```
$SYBASE/$SYBASE_ASE/upgrade/upgrade -S instance_name -Ppassword
```
The instance you include with the --instance parameter is the name of the instance in your cluster that was started in step 13.
Log in to the instance. Create the local system temporary database devices and local system temporary databases for each of the instances in your cluster. The syntax is:
```
create system temporary database database_name for instance instance_name on device_name = size
```
See “Setting up local system temporary databases” for more detailed information.
Shut down the instance. Log in to the instance with isql and issue:
```
shutdown instance_name
```
Restart the cluster. $SYBASE/$SYBASE_ASE/bin/dataserver \ --instance=ase1\ --quorum_dev=/dev/raw/raw101\
Log in to the Cluster Edition and execute sp_checkreswords on all of databases. For example, log in to the instance and execute:
```
use sybsystemprocs
go
sp_checkreswords
go
```
Correct any errors from the reserved word check.
Copy and modify the old run_server file to new directory. You must edit it to point to binaries in the correct $SYBASE directories:
- Add this argument to the run_server file:
  
  --quorum_dev=<path to the quorum device>
- Remove these options, as the information is now stored in the quorum device.
  - -c
  - -i
  - -e
See “Creating the runserver files” for more information.

Start the instance:

cd $SYBASE/$SYBASE_ASE/install
startserver -fRUN_server_name

Install the system procedures:

isql -Usa -Ppassword -Sserver_name
-i$SYBASE/$SYBASE_ASE/scripts/installmaster

If Adaptive Server includes auditing, run installsecurity:

isql -Usa -P password -S server_name 
-i$SYBASE/$SYBASE_ASE/scripts/installsecurity

Run installcommit:

isql -Usa -Ppassword -Sserver_name
-i$SYBASE/$SYBASE_ASE/scripts/installcommit