InfoScale™ 9.0 Cluster Server Agent for Sybase Installation and Configuration Guide - Solaris

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Solaris
  1. Introducing the Cluster Server for Sybase
    1.  
      About the Cluster Server for Sybase
    2.  
      Supported software for the VCS agent for Sybase
    3.  
      How the agent makes Sybase highly available
    4.  
      How the Sybase and SybaseBk agents support intelligent resource monitoring
    5. About the Sybase agent functions
      1.  
        Sybase agent functions
      2.  
        SybaseBk agent functions
      3.  
        Using the IPC Cleanup feature for the Sybase agent
    6. Monitoring options for the Sybase agent
      1.  
        Monitoring Sybase instances running in Solaris Containers
    7.  
      Action function for the VCS agent for Sybase
    8.  
      Typical Sybase configuration in a VCS cluster
  2. Installing and configuring Sybase
    1. VCS requirements for installing Sybase
      1.  
        Sybase installation directory
      2.  
        SYBASE directory on shared disks
      3.  
        System Group and User for Sybase home directory
      4.  
        Database dbspaces
      5.  
        Transparent TCP/IP failover
      6.  
        Language settings for the Sybase agent
    2.  
      Installing Sybase in a VCS environment
    3.  
      Configuring Sybase for detail monitoring
  3. Installing, upgrading, and removing the agent for Sybase
    1.  
      Before you install or upgrade the agent for Sybase
    2.  
      Installing the agent for Sybase
    3.  
      Disabling the agent for Sybase
    4.  
      Removing the agent for Sybase
    5.  
      Upgrading the agent for Sybase
  4. Configuring VCS service groups for Sybase
    1.  
      About configuring service groups for Sybase
    2. Before configuring the service group for Sybase
      1.  
        Importing the SybaseTypes.cf file
    3.  
      Configuring the service groups for Sybase
    4.  
      Configuring the service group for Sybase from Cluster Manager (Java console)
    5.  
      Configuring the service group for Sybase using the command line
    6.  
      Encrypting passwords for Sybase
    7. About setting up detail monitoring for the agent for Sybase
      1.  
        Enabling detail monitoring for the agent for Sybase
      2.  
        Disabling detail monitoring for the agent for Sybase
    8.  
      Enabling and disabling intelligent resource monitoring (IMF) for agents
    9.  
      Administering the AMF kernel driver
  5. Administering VCS service groups for Sybase
    1.  
      About administering service groups for Sybase
    2.  
      Bringing the Sybase service group online
    3.  
      Taking the Sybase service group offline
    4.  
      Switching the Sybase service group
    5.  
      Modifying the Sybase service group configuration
    6.  
      Viewing the agent log for Sybase
  6. Appendix A. Resource type definitions for Sybase
    1.  
      About the resource type and attribute definitions for Sybase
    2. Sybase resource type
      1.  
        Type definition for the Sybase agent
      2.  
        Attribute definitions for the Sybase agent
    3. SybaseBk resource type
      1.  
        Type definition for the SybaseBk agent
      2.  
        Attribute definitions for the SybaseBk agent
  7. Appendix B. Sample configurations for Sybase
    1.  
      About the sample configuration for the Sybase agent
    2. Resource dependency graph for the Sybase agent
      1.  
        Resource dependency for Sybase configured in Solaris zones
    3.  
      Sample configuration for agent for Sybase on Solaris systems
    4. Sample main.cf files for Sybase ASE CE configurations
      1.  
        Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation
      2.  
        Sample main.cf for a basic Sybase ASE CE cluster configuration with local mount point on VxFS for Sybase binary installation
      3.  
        Sample main.cf for a primary CVM VVR site
      4.  
        Sample main.cf for a secondary CVM VVR site
    5.  
      Sample configuration for the Sybase agent in Solaris zones

Monitoring options for the Sybase agent

The VCS agent for Sybase provides two levels of application monitoring: basic and detail.

In the basic monitoring mode, the agent for Sybase monitors the Sybase dataserver processes to verify whether they are running.

For Sybase cluster edition, the agent uses qrmutil utility that Sybase provides to get the status of the Sybase instance. If the state returned by qrmutil utility is 'failure pending', the agent panics the node. When the Sybase agent detects that the configured Sybase server is not running on a system, based on the value of the OnlineRetryLimit attribute of the Sybase service group, the service group is restarted on the same system on which the group faulted.

For example:

# qrmutil --quorum_dev=/quorum/quorum.dat --monitor=ase1
Executing 'monitor' command for instance 'ase1'
Instance 'ase1' has a failure pending.
# echo $?
99

In this example instance 'ase1' has a failure pending state. The agent will panic the node running the instance 'ase1'. The node will automatically rejoin the cluster after reboot.

In the detail monitoring mode, the agent performs a transaction on a test table in the database to ensure that Sybase server is functioning properly. The test table should be created by the user, and the table is specified in the attribute Table for the Sybase agent. The agent uses this test table for internal purposes. Arctera recommends that you do not perform any other transaction on the test table.

For the Sybase ASE Enterprise edition, when the agent detects that the configured Sybase server is not running on a system, the Sybase service group is failed over to the next available system in the service group's SystemList. The configured Sybase servers are started on the new system, thus ensuring high availability for the Sybase server and data.