Upgrading Adaptive Server configured with high availability

To upgrade high-availability-enabled Adaptive Server in an active-active configuration:

Drop the high availability companionship.
- Asymmetric configuration – on the secondary server, use isql:
```
sp_companion <primary-server-name>, "drop"
go
```
- Symmetric configuration – run the same command as above on both servers.
  
  Use isql to verify that both servers are in single-server mode:
```
sp_companion
go
```
Use the appropriate command for your cluster system to stop monitoring resources associated with Adaptive Server on each cluster node.
Log in to the server using isql. Disable HA by entering:
```
sp_configure 'enable HA', 0 
go 
```
To complete the change, shut down and restart the Adaptive Server.
Upgrade each Adaptive Server Enterprise separately, following the instructions in the appropriate upgrade chapter of the installation guide for your platform.
Run the new Adaptive Server Enterprise installmaster script against the newly upgraded Adaptive Servers.
Enable the ASE HA property on the new server. Log in to the server using isql and configure the server to enable HA by entering:
```
> sp_configure 'enable HA', 1 
> go 
```
To complete the change, shut down and restart the Adaptive Server.
Run the new Adaptive Server Enterprise installhasvss script against the newly upgraded Adaptive Servers.
Follow the instructions in Using Sybase Failover in a High Availability System to configure the permission and ownership for $SYBASE/$SYBASE_ASE/bin/sybha and $SYBASE/$SYBASE_ASE/install/sybhauser.
Modify high-availability related files such as the RUN_server_file, and the SYBASE.csh and SYBASE.sh files, if those files are required on the cluster platform.
Reconfigure each resource associated with Adaptive Server Enterprise, depending on platform-specific requirements. For example, on Veritas Cluster, update the HAase resource properties, the RUN_server_file, and Sybase_home.
Manually restart Adaptive Server Enterprise on each cluster node using trace flag 2209. Use the Adaptive Server Enterprise command line option -T2209.

WARNING! Do not use trace flag 2209 after the Adaptive Server Enterprise companionship is reestablished.
Use the appropriate command for your cluster system to restart monitoring resources associated with Adaptive Server Enterprise on each cluster node.
Reestablish companionship by using isql to issue:
```
sp_companion <primary-server-name>, configure
go
```
If user databases exist on the secondary server, you may see one or more warning messages. You can safely ignore these messages, which look similar to:

Msg 18739, Level 16, State 1: Server 'svr2', Procedure 'sp_hacmpcfgvrfy', Line 102: Database 'svr2_db1': a user database exists. Drop this database and retry the configuration again.
Use the appropriate cluster command to take offline, then bring back online, each resource group associated with Adaptive Server Enterprise. Use isql to connect to each Adaptive Server Enterprise and verify the correct server companionship:
```
sp_companion 
go
```
The output you see on the primary server is similar to the following:
```
Server 'svr1' is alive and cluster configured.
Server 'svr1' is configured for HA services.
Server 'svr1' is currently in 'Primary normal' mode.
(return status = 0)
```
The output you see on the secondary server is similar to the following:
```
Server 'svr2' is alive and cluster configured.
Server 'svr2' is configured for HA services.
Server 'svr2' is currently in 'Secondary normal'
mode.
(return status = 0)
```

To upgrade high-availability-enabled Adaptive Servers in an active-passive configuration:

Use the appropriate cluster system command to take Adaptive Server Enterprise offline.
Use the appropriate cluster system command to stop monitoring resources associated with Adaptive Server Enterprise.
Disable the HA on the server by entering:
```
sp_configure 'enable HA', 0 
go 
```
To complete the change, shut down and restart the Adaptive Server.
Follow the steps in the appropriate upgrade chapter of the installation guide for your platform.
Run the new Adaptive Server Enterprise installmaster script against the newly upgraded Adaptive Server Enterprise.
Log in to the server using isql and configure the server to enable HA by entering:
```
sp_configure 'enable HA', 1 
go 
```
To complete the change, shut down and restart the Adaptive Server.
Modify the high-availability related files such as the RUN_server_file, and the SYBASE.csh and SYBASE.sh files, if those files are required on the cluster platform you are using.
Use the appropriate cluster system command to reconfigure resource properties to reflect the new Adaptive Server Enterprise installation location.
Manually restart Adaptive Server Enterprise.
Use the appropriate cluster system command to restart monitoring resource associated with Adaptive Server Enterprise.
Use the appropriate cluster command to take resources associated with Adaptive Server Enterprise offline on the same node, then bring them back online. Use the cluster command to switch resources associated with Adaptive Server Enterprise to another node and then switch back.