Verifying the Solaris Cluster HA for Sybase ASE Installation and Configuration

These checks ensure that all of the nodes that run Solaris Cluster HA for Sybase ASE 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 checks to isolate any problems with starting the Sybase ASE software from Solaris Cluster HA for Sybase ASE.

How to Verify the Solaris Cluster HA for Sybase ASE Installation and Configuration

1. Log in to the node that masters the Sybase ASE resource group.
2. Set the Sybase ASE environment variables.

   The environment variables are the variables that you specify with the Environment_file extension property. For information about setting these environment variables, see Appendix A, Solaris Cluster HA for Sybase ASE Extension Properties.

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

   # clresource status

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 -P password
   
   isql> sp_help
   isql> go
   isql> quit

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

   The Oracle Solaris Cluster software restarts the process.

7. Switch the resource group that contains the Sybase ASE resource to another cluster node or zone.

   # clresourcegroup switch -n node[:zone] resource-group

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 Solaris 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 Solaris Cluster HA for Sybase ASE recovery time.

   ---

Location of Solaris Cluster HA for Sybase ASE Log Files

Each instance of the Solaris Cluster HA for Sybase ASE data service maintains log files in the /opt/SUNWscsyb/log directory.

These files contain information about actions that the Solaris Cluster HA for Sybase ASE data service performs. Refer to these files to obtain diagnostic information for troubleshooting your configuration or to monitor the behavior of the Solaris Cluster HA for Sybase ASE data service.

See also Solaris Cluster HA for Sybase ASE Logging Issues.