The Cluster Administrator utility is a graphical user interface that walks you through the configuration process. The section assumes that the Microsoft Cluster Server is installed on your system. Install the new resource type “Sybase Companion Server” and Cluster Administrator extensions with the following command on each node of the cluster:
%SYBASE%\ASE-12_5\bin\sybcpnin.exe -s
(%SYBASE% is the release directory for ASE executable.)
The example shows the console output from running the above command:
Installed Resource Type 'Sybase Companion Server' using resource DLL 'sybcpnrs.dll' on the cluster Installed Admin Extension DLL 'sybcpnae.dll' with MSCS and COM Successful installation complete SI_SUCCESS
Perform the following steps to configure ASE HA on Microsoft Cluster Server:
Create a cluster group. See you Microsoft Cluster Server documentation for information.
Move the dedicated shared disks for the companion you are configuring into the cluster group you created in step 1. See your Microsoft Cluster Server documentation for information.
Select | Administrative Tools | Cluster Administrator.
Select File | Resource | New Resource.
On the New Resource screen enter:
Name – the name of the package you are configuring.
Description – a brief description of the package. This field is not required.
Resource type – select Sybase Companion Server
Group – group in which you want this cluster included. This field is not required
Click OK to create this group.
You may not find the resource type “Sybase Companion Server” in the list box if the command at the beginning of this section is not run: %SYBASE%\ASE-12_5\bin\sybcpnin.exe -s
Select Change Group then select the name of the group to move the physical disk resources (data and log devices) of the primary companion to this new group. Click OK. You see the Possible Owners screen.
The Possible Owners screen specifies the nodes on which this resource can be brought online. Both nodes must be listed as possible owners in the right-hand window of this screen. If the list is not correct, use Add or Remove to correct it. Select Next.
The Dependencies screen lists the services that must be brought online first before starting this resource. Make sure the shared disk device is listed as a dependency. Select Next.
You may only find the Finish button at this step and can not perform the following step 9 through 13 if the command at the beginning of this section is not run: %SYBASE%\ASE-12_5\bin\sybcpnin.exe -s
On the ASE Server Information screen enter:
The name of the Adaptive Server you are configuring as the primary companion.
The System Administrator login for this companion (this must be “sa”
The System Administrator password for this login.
A password check to make sure the password you entered is correct.
Select Next.
Enter the name of the Adaptive Server that is to be the secondary companion in the Companion Server Information field.
To configure the companions in a symmetric setup, select symmetric.
Select Next.
On the Cluster Parameters screen, select Use System Generated Cluster Login. This provides a system-generated setup log that is used when the cluster logs into the Adaptive Server. Select Next. (Alternatively, you can create the login on the primary companion, assign it both the sa_role and ha_role before you perform this step.)
(Optional) On the Setup Options screen, enter the path to the error log that records the steps made during this configuration (this log is very helpful if you need to call Technical Support). Select Finish.
The next screen lists the configuration that you have selected for this cluster configuration.Select Back and re-enter the appropriate data to change any information. When the configuration is correct, select Next to configure this cluster resource.
You see a series of messages as the two Adaptive Servers are configured. If any error messages appear, address the issues and select Next. You do not have to start over again.
When the configuration is complete, the companions are in normal companion mode in either an asymmetric or symmetric setup, depending on what you specified in the Companion Server Information screen.