InfoScale™ 9.0 Cluster Server Agent for Sybase Installation and Configuration Guide - Solaris
- Introducing the Cluster Server for Sybase
- About the Cluster Server for Sybase
- Supported software for the VCS agent for Sybase
- How the agent makes Sybase highly available
- How the Sybase and SybaseBk agents support intelligent resource monitoring
- About the Sybase agent functions
- Monitoring options for the Sybase agent
- Action function for the VCS agent for Sybase
- Typical Sybase configuration in a VCS cluster
- Installing and configuring Sybase
- Installing, upgrading, and removing the agent for Sybase
- Configuring VCS service groups for Sybase
- About configuring service groups for Sybase
- Before configuring the service group for Sybase
- Configuring the service groups for Sybase
- Configuring the service group for Sybase from Cluster Manager (Java console)
- Configuring the service group for Sybase using the command line
- Encrypting passwords for Sybase
- About setting up detail monitoring for the agent for Sybase
- Enabling and disabling intelligent resource monitoring (IMF) for agents
- Administering the AMF kernel driver
- Administering VCS service groups for Sybase
- Appendix A. Resource type definitions for Sybase
- Appendix B. Sample configurations for Sybase
- About the sample configuration for the Sybase agent
- Resource dependency graph for the Sybase agent
- Sample configuration for agent for Sybase on Solaris systems
- Sample main.cf files for Sybase ASE CE configurations
- Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation
- Sample main.cf for a basic Sybase ASE CE cluster configuration with local mount point on VxFS for Sybase binary installation
- Sample main.cf for a primary CVM VVR site
- Sample main.cf for a secondary CVM VVR site
- Sample configuration for the Sybase agent in Solaris zones
Sybase agent functions
The agent for Sybase starts a Sybase ASE dataserver, monitors the server processes, shuts down the server, and restarts the server processes..
The Sybase agent is IMF-aware.
Table: Sybase agent functions lists the Sybase agent for SQL server functions.
Table: Sybase agent functions
Agent function | Description |
|---|---|
Online | Starts the Sybase ASE dataserver by using the following command. startserver -f $SYBASE/$SYBASE_ASE/install/ RUN_$Server where $Server is the instance_name, and If the WaitForRecovery attribute is enabled, the agent waits either till recovery has been completed and all databases that can be made online are brought online. The agent queries the recovery status by connecting to the isql session. The OnlineTimeout attribute must be set to a sufficiently large value so that the recovery completes before the OnlineTimeout is reached. By default, the WaitForRecovery attribute is not enabled. If the interfaces file location is specified using the interfaces_File attribute, agent uses [-I interfaces file] option while connecting to the isql session. When DelayAfterOnline attribute is set, the monitor function is invoked after completion of online function, and after the number of seconds specified in DelayAfterOnline attribute have elapsed. |
Monitor | In the basic monitoring mode, agent scans the process table for the dataserver process. In the detail monitoring mode, agent runs the script that is specified in MonScript as an option. The agent uses the Sybase provided utility, qrmutil, to know if the status of the instance is up or down. If qrmutil reports the status as failure pending, the agent reboots the node and the instance is automatically started again. |
Offline | Stops the Sybase SQL server by using the isql command in the following manner. If interfaces file location is specified using the interfaces_File attribute, agent uses the specified file while connecting to isql session. The agent first executes the shutdown with wait command. Sybase agent uses the timeout option during shutdown of Sybase dataserver if this option is supported. For Sybase ASE Enterprise edition the timeout option for shutdown command is supported for versions 12.5.4 and 15.0.2 onwards. If this timeout option is not supported for Sybase ASE Enterprise edition, the offline script waits in a loop till the dataserver completely stops. The agent waits for up to the OfflineTimeout duration. If the process is still running, the offline script issues a shutdown with nowait command. For Sybase ASE Cluster edition the timeout option for shutdown command is supported from versions 15.5 ESD #1 onwards. If the timeout option is not supported for Sybase ASE Cluster edition, the offline script waits in a loop till the dataserver completely stops. The agent waits for up to the OfflineTimeout duration. If the process is still running, the offline script kills it. When DelayAfterOffline attribute is set, the monitor function is invoked after completion of offline function and after the number of seconds specified in DelayAfterOffline attribute have elapsed. |
imf_init | Initializes the agent to interface with the AMF kernel driver, which is the IMF notification module for Sybase agent. This function runs when the agent starts up. |
imf_register | Registers or unregisters resource entities with the AMF kernel module. This function runs for each resource after the resource goes into steady state (online or offline). |
imf_getnotification | Gets notification about resource state changes. This function runs after the agent initializes with the AMF kernel module. This function continuously waits for notification and takes action on the resource upon notification. |
Clean | Forcefully stops the Sybase SQL server by using the isql command in the following manner. The agent first executes the shutdown with wait command. For Sybase ASE Enterprise edition, if the isql command fails, the clean script executes the shutdown with nowait command. If the process does not respond to the shutdown command, the agent kills the Sybase dataserver process. For Sybase ASE Cluster edition, if the shutdown with wait command does not stop the dataserver, the agent directly proceeds to kill the dataserver process. |
Action | Performs the predefined actions on a resource. |