Sun Cluster Data Service for Sybase ASE Guide for Solaris OS

Registering and Configuring Sun Cluster HA for Sybase ASE

Setting Sun Cluster HA for Sybase ASE Extension Properties

The section that follows contains instructions for registering and configuring resources. These instructions explain how to set only extension properties that Sun Cluster HA for Sybase ASE requires you to set. For information about all Sun Cluster HA for Sybase ASE extension properties, see Sun Cluster HA for Sybase ASE Extension Properties. You can update some extension properties dynamically. You can update other properties, however, only when you create or disable a resource. The Tunable entry indicates when you can update a property.

To set an extension property of a resource, include the following option in the clresource(1CL) command that creates or modifies the resource:

-p property=value

-p property: Identifies the extension property that you are setting
value: Specifies the value to which you are setting the extension property

You can also use the procedures in Chapter 2, Administering Data Service Resources, in Sun Cluster Data Services Planning and Administration Guide for Solaris OS to configure resources after the resources are created.

How to Register and Configure Sun Cluster HA for Sybase ASE

This procedure describes how to use the Sun Cluster maintenance commands to register and configure Sun Cluster HA for Sybase ASE.

This procedure includes creating the SUNW.HAStoragePlus resource type. This resource type synchronizes actions between HAStorage and Sun Cluster HA for Sybase ASE and enables you to use a highly available local file system. Sun Cluster HA for Sybase ASE is disk intensive, and therefore you should configure the SUNW.HAStoragePlus resource type.

For more information about the SUNW.HAStoragePlus resource type, see the following documentation:

Note –

Other options also enable you to register and configure the data service. For details about these options, see Tools for Data Service Resource Administration in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

To perform this procedure, you must have the following information.

The names of the cluster nodes or zones that master the data service.
The network resource that clients use to access the data service. You typically configure the IP address when you install the cluster. For information about planning the Sun Cluster environment and the installation of the Solaris software, see Chapter 1, Planning the Sun Cluster Configuration, in Sun Cluster Software Installation Guide for Solaris OS.
The path to the Sybase ASE application installation.

Note –

Perform the following steps on one cluster node or zone.

On a cluster node or zone, become superuser or assume a role that provides solaris.cluster.modify and solaris.cluster.admin RBAC authorizations.

Run the clresourcetype command to register resource types for Sun Cluster HA for Sybase ASE.
# clresourcetype register SUNW.sybase

Create the resource sybase-hastp-rs of type SUNW.HAStoragePlus.

# clresource create -g sybase-rg -t SUNW.HAStoragePlus \
-p GlobalDevicePaths=sybase-device-group1,/dev/global/dsk/dl \
-p FilesystemMountPoints=/global/sybase-inst \
-p AffinityOn=TRUE sybase-hastp-rs

The resource is created in the enabled state.

Note –

AffinityOn must be set to TRUE and the local file system must reside on global disk groups to be failover.

Run the clresourcegroup command to complete the following tasks and bring the resource group sybase-rg online on a cluster node or zone.
- Moving the resource group into a managed state
- Bringing the resource group online
This node becomes the primary for device group sybase-set1 and raw device /dev/global/dsk/d1. Device groups that are associated with file systems such as /global/sybase-inst are also made primaries on this node.
# clresourcegroup online -M sybase-rg

Create Sybase ASE application resources in the failover resource group.

# clresource create -g resource-group \
-t SUNW.sybase \
-p Environment_File=environment-file-path \
-p Adaptive_Server_Name=adaptive-server-name \
-p Backup_Server_Name=backup-server-name \
-p Text_Server_Name=text-server-name \
-p Monitor_Server_Name=monitor-server-name \
-p Adaptive_Server_Log_File=log-file-path \
-p Stop_File=stop-file-path \
-p Connect_string=user/passwd \
-p resource_dependencies=storageplus-resource \
-p Wait_for_Online=TRUE \
-p DB_Wait_List=db1, db2, ... \
-p Restart_type=RESOURCE_RESTART|RESOURCE_GROUP_RESTART \
-p Custom_action_file=filepath resource

-g resource-group: Specifies the resource group name into which the RGM places the resources.
-t SUNW.sybase: Specifies the resource type to add.
-p Environment_File=environment-file: Sets the name of the environment file.
-p Adaptive_Server_Name=adaptive-server-name: Sets the name of the adaptive server.
-p Backup_Server_Name=backup-server-name: Sets the name of the backup server.
-p Text_Server_Name=text-server-name: Sets the name of the text server.
-p Monitor_Server_Name=monitor-server-name: Sets the name of the monitor server.
-p Adaptive_Server_Log_File=log-file-path: Sets the path to the log file for the adaptive server.
-p Stop_File=stop-file-path: Sets the path to the stop file.
-p Connect_string=user/passwd: Specifies the user name and password that the fault monitor uses to connect to the database.
-p Wait_for_Online=TRUE: Specifies whether the START method has to wait for the database to be brought online before exiting.
-p DB_Wait_List=db1, db2, ...: Specifies the list of databases that need to be online before the resource can be brought online. The valid values are either an empty list (“ ”), ALL, or a list of databases.
-p Restart_type=RESOURCE_RESTART|RESOURCE_GROUP_RESTART: Defines the restart behavior of the resource. If the Restart_type extension property is set to RESOURCE_RESTART, the server fault monitor restarts the database server resource. If the Restart_type extension property is set to RESOURCE_GROUP_RESTART, the server fault monitor restarts the database server resource group. This property was introduced in SUNW.sybase resource type version 5. Prior to and including SUNW.sybase resource type version 5, the server fault monitor restarted the database server resource group.
-p Custom_action_file=filepath: Sets the path to the custom action file that contains the custom fault monitor actions.
resource: Specifies the resource name to add.

The resource is created in the enabled state.

You do not have to specify extension properties that have default values. For more information, see Setting Sun Cluster HA for Sybase ASE Extension Properties.

Next Steps

After you register and configure Sun Cluster HA for Sybase ASE, go to Verifying the Sun Cluster HA for Sybase ASE Installation and Configuration.