Verifying the Sun Cluster HA for Sybase ASE Installation

Perform the following verification tests to make sure that you have correctly installed and configured the Sun Cluster HA for Sybase ASE data service.

These sanity checks make sure that all nodes that run the Sun Cluster HA for Sybase ASE data service can start the Sybase ASE data server. These checks also ensure that other nodes in the configuration can access the Sybase ASE data server. Perform these sanity checks to isolate any problems with starting the Sybase ASE software from the Sun Cluster HA for Sybase ASE data service.

How to Verify the Sun Cluster HA for Sybase ASE Installation

1. Log in to the node monitoring the Sybase ASE resource group.

2. Set the Sybase ASE environment variables.

   The environment variables are the variables you specify with the Environment_file extension property. You typically name these variables SYBASE.sh.

3. Verify that the Sun Cluster HA for Sybase ASE resource is online.

   # scstat -g

4. Inspect the Sybase ASE logs to determine the cause of any errors that have occurred.

5. Confirm that you can connect to the data server and execute the following test command.

   # isql -S adaptive-server -U sa isql> sp_help isql> go isql> quit

6. Kill the process for the Sybase ASE data server.

   The Sun Cluster software restarts the process.

7. Switch the resource group that contains the Sybase ASE resource to another cluster member.

   # scswitch -z -g resource-group -h node

8. Log in to the node that now contains the resource group.

9. Repeat Step 3 and Step 5.

   ---

   Note -

   Sybase ASE client connections cannot survive a Sun Cluster HA for Sybase ASE switchover. If a switchover occurs, the existing client connections to Sybase ASE terminate, and clients must reestablish their connections. After a switchover, the time that is required to replay the Sybase ASE transaction log determines Sun Cluster HA for Sybase ASE recovery time.

   ---