Upgrading during a high availability configuration

After you have enabled high availability (HA), follow the instructions in upgrade chapter in the Adaptive Server installation guide for your platform.

The instructions in this section supplement those in the Installation Guide.

StepsReinstalling system stored procedures

  1. Disable HA in the primary server:

    sp_companion secondary-server-name, 'drop' 
    sp_configure 'enable HA', 0
    
  2. Disable HA in the secondary server:

    sp_configure 'enable HA', 0
    
  3. Restart the servers.

  4. Run the installmaster script on both servers.

  5. Enable the HA property on both servers:

    sp_configure 'enable HA', 1
    
  6. Restart both servers.

  7. Run the installhasvss script on both servers. This script is located in $SYBASE/$SYBASE_ASE/scripts.

  8. Reestablish companionship:

    sp_companion [companion_server_name], configure 	[, with_proxydb]