To ensure that you have properly configured high availability on the Sun Cluster, perform the verification tests in this section.
The following steps assume that you have configured two Adaptive Server resource groups in asymmetric mode.
Log in to the primary node for the Adaptive Server resource group.
Set the Adaptive Server environment variables: SYBASE, SYBASE_ASE, SYBASE_OCS, and so on. Use the Environment_file extension property to specify environment variables.
Verify the Adaptive Server resource group is online:
scstat -g
Use isql to connect to the primary data server:
isql -Usa -Ppassword -Sprimary-server-name >select name from sysdatabases >go >quit
Switch the primary resource group to the secondary node. This is a simulated fail over.
scswitch -z -g primary-resource-group -h secondary-host
Use isql to connect to the secondary data server and confirm that the databases in the primary data server have been taken over by the secondary data server and can be accessed.
isql -Usa -Ppassword -Ssecondary-server-name >select name from sysdatabases >go >quit
Follow the instructions in “Failing back to the primary companion” to fail back the primary resource group.
Use isql to connect to the primary data server and verify that databases in the primary data server have been taken over by the primary data server and can be accessed.
isql -Usa -Ppassword -Sprimary-server-name >select name from sysdatabases >go >quit
