Skip to Content
Author's profile photo Christian SCHMITT

Business Continuity with SAP ASE – Server Availability Solutions (2/2)

Integration of SAP ASE with Prominent Cluster Solutions

This article is the continuation of  “Business Continuity with SAP ASE –  Server Availability Solutions (1/2)“. It details SAP ASE integration with major vendors cluster solutions.

Symantec Veritas Cluster Server:
Symantec Veritas Cluster Server (VCS) provides cross platform cluster software (for HP-UX, IBM AIX, Linux, Microsoft Windows, Oracle Solaris and VMware).

It has Business Continuity solutions for both SAP ERP  [3]  and SAP ASE.

Symantec ships two agents for SAP ASE with Veritas Cluster Server to monitor/start/stop SAP ASE resources:

  • Agent for SQL Server- Sybase
  • Agent for Backup Server- SybaseBK

A quick overview of Symantec Veritas Cluster Server for SAP ASE is given in [3a]

  • Following diagram depicts a single SAP ASE database server sample configuration with Symantec Veritas Cluster Server. It shows the resource types, resources, and resource dependencies within the service group.
  • Each ellipse stands for a resource type (DiskGroup, Volume, Mount, NIC, IP, Sybase and SybaseBK).
    Each ellipse is tagged with a resource name in bold (dgres, nicres, sybasedg_vol, …).
  • The resource dependencies are represented with dependence lines; dependencies dictate the start and stop sequence for all resources in the service group.



The resource dependencies define the order of starting (or stopping) the resources inside a service group.

To start the Sybase database service a bottom-up order is used. The first resource to be started is the dgres resource (of “DiskGroup” resource type). Then several logical volumes are started (sybasedg_vol for data and log devices of the database server and for the SAP ASE distribution). The network interface for the SAP ASE database server is started via nicres and ipres resources. Then file systems are mounted via several “Mount” resource types. Once all the resources are brought online, the database server can be started. The Backup Server is started after the datasever is started.
Stopping the resource for a graceful shutdown or a planned failover uses a top-down order.

Configuration steps:
Setting up the cluster configuration can be done with a GUI (Cluster Manager, Java console) or using the command line. Using the command line, you have to:

  1. Edit the /etc/VRTSvcs/conf/config/ file.
    Create a SYBASE service group.
    Create the SYBASE and SybaseBk resources.
    Edit the default attributes to match the parameters in your configuration.
    Assign dependencies to the newly created resources.
  2. Verify the syntax of the file /etc/VRTSvcs/conf/config/
    # cd /etc/VRTSvcs/conf/config
    # hacf -verify .
  3. Start VCS on the local node.
    # hastart

Failover/failback processes:
A failover process can be a planned event or triggered by an outage. In case of a planned failover, the administrator (DBA or system administrator) chooses to move the SAP ASE service from a physical node onto another. Following graceful procedure is executed:

  1. The SAP ASE instance is shut down.
  2. The virtual IP address is removed from its network interface.
  3. The files systems are unmounted.
  4. The disk group containing the files systems is deported.

On the target node (the node chosen by the administrator to host the failover database), the above sequence is reversed.

For unplanned failover events, the same sequence occurs. Nevertheless, in case of a sudden failure there are noticeable differences:

  • The cluster layer triggers the failover process (not the DBA).
  • Depending on the failure, resources may be stopped abruptly, and may not be brought down gracefully.
  • Subsequent starting of resources on the next node may be longer due to additional tasks involved (like extra file systems checks and longer database recovery).

Failling back to the original node is a planned process and follows the planned failover process.

Symantec provides a lot of documentation for VCS (generic and platform specific). For instance, implementation example of VCS for SAP ASE on AIX can be downloaded at [4] and [5].

HP Serviceguard:
HP Serviceguard is available on HP-UX and Linux. SAP ASE can be integrated with HP Serviceguard in two ways:

  • SAP ASE as database server for SAP application environments.
    HP Serviceguard Extension for SAP (SGeSAP) on HP-UX, extends HP Serviceguard’s failover cluster capabilities to SAP application environments. It is intended to be used in conjunction with the HP Serviceguard product. SGeSAP provides a single, uniform interface to cluster ABAP-only, JAVA-only, double-stack and split-stack installations of SAP Netweaver based SAP applications. SGeSAP B.05.10 requires the installation of HP Serviceguard A.11.20 and can be used on HP-UX 11i v3 with SYBASE ASE 15.7 and later. Serviceguard extension for SAP is available on Linux (RHEL, SLES) with SAP SYBASE 15.7. HP provides comprehensive documentation to set up and manage SGeSAP and the SAP SYBASE integration [7].
  • SAP ASE as standalone database server
    SAP ASE can be integrated to a HP Serviceguard cluster as a package (a resource group). HP offers a toolkit to manage SAP SYBASE database servers with HP Serviceguard cluster. The Sybase ASE Toolkit for Serviceguard can be used with recent versions of HP Serviceguard ( A.11.19, A.11.20) on HP-UX (11i v2 and HP-UX 11i v3) with SAP ASE 15.0.2 and later.

Configuration steps for standalone database server:
The Sybase ASE Toolkit for Serviceguard consists of a shell script that is used to start, stop, and monitor a single-instance of Sybase ASE. SAP ASE binaries should be installed on a shared directory accessible by all nodes.
Registering of SAP ASE as an HP Serviceguard package is done via command line.

  1. Fill Attribute Definition File with SYBASE information (like start script, monitoring login/password, …)
  2. Create a shared directory for data and symbolic links
  3. Test if ASE is able to start on all nodes
  4. Create a package configuration file
  5. Following command will create a configuration file for ASE0 dataserver with given Attribute Definition File.
    cmmackepkg –m ASE0.conf
  6. Add database package to the cluster.

Following commands will register ASE0 database server configuration in the cluster; enable ASE0 on physical nodes (here node1 and node2) and start the database server.
cmapplyconf –p ASE0.conf
cmmodpkg –e –n node1 –n node2 ASE0
cmmodpkg –e ASE0
Check [8] for more information.

Failover/failback processes:
For a planned failover, run following:

  1. Before you move a failover package to a new node, check package dependencies, be sure they can be met on the new node.
    cmviewcl -v -l <database package name>
  2. Halt the package on its node.
    cmhaltpkg <database package name>
  3. Run the package on the new node
    cmrunpkg <database package name>

IBM PowerHA SystemMirror:
PowerHA SystemMirror is the Business Continuity solution from IBM. It was previously known as IBM HACMP. IBM PowerHA SystemMirror does not provide specific agent (Smart Assist) for SAP ASE yet.  SAP ASE can be integrated into a IBM PowerHA cluster as an application resource. PowerHA SystemMirror uses the term “application server” for application resource like database server.
The administration of cluster resources is done with AIX smitty utility.
For instance, in order to register a SAP ASE database server use “Configuration–>HACMP Extended Resources Configuration–> Configure HACMP Application Servers–>Add an Application Server” menu of smitty.
See documentation [10] and [11].

Microsoft Cluster Server:
Installation of SAP ASE with Microsoft Cluster Server is described in SAP Note 1651052 – SYB: MS Cluster: DB instance for failover. SAP installations for SAP ASE provide installation options for a Microsoft Cluster environment as of Software Logistics Toolset 1.0 SPS 06.

SUN Cluster uses cluster agents to start/stop/monitor application resources. You can use the SYBASE cluster agents provided by ORACLE or your custom agents for ASE. Custom agents are known as Generic Data Services (GDS).
Availability of ORACLE SUN agents for SYBASE ASE depends on the version of SUN Cluster:

  • With SUN Cluster 3.5, ORACLE provides an agent for SYBASE ASE 15. This resource type is named “SUNW.sybase” (See [12]). You can also use your own custom agent and integrate it with GDS interface.
  • With new SUN Cluster 4.1, there is no ASE agent available yet. The only choice is to use a GDS agent (See [13]). To define a GDS for SAP ASE, you have to provide scripts to stop/start/check the database server.

Configuration steps:
I have seen both types of agents on customer sites. Both resource types rely on other cluster resources that can be imported/exported by all the nodes of the cluster:

  • Highly available IP address resource
  • Highly available volumes group resources (named HAStoragePlus)
    They are registered in the same way with the “clresource create” Solaris command. Properties of the commands are different depending of the resource types.

For example, below are the steps for registering a database server with the provided agent “SUNW.sybase”. Database server corresponds to ASE-resource-name resource and  belongs to a resource-group-name resource group.

# clresource create -g resource-group-name
-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_offline_restart=storageplus-resource
-p Wait_for_Online=TRUE
-p DB_Wait_List=db1, db2, …
-p Custom_action_file=filepath ASE-resource-name

Below is the equivalent method for registering a database server resource via GDS. Database server corresponds to ASE-resource-name resource and  belongs to a resource-group-name resource group.

clresource create -g resource-group-name
-t SUNW.gds
-p Validate_command=”validate-file-path”
-p Scalable=false -p Start_timeout=120
-p Stop_timeout=120 -p Probe_timeout=120
-p Port_list=”2222/tcp”
-p Start_command=”start-file-path”
-p Stop_command=”stop-file-path”
-p Probe_command=”monitor-file-path”
-p Child_mon_level=0 -p Network_resources_used=logical_node
-p Failover_enabled=TRUE -p Stop_signal=9 ASE-resource-name

Failover/failback processes:
To failover a database server resource, the entire resource group to which it belongs to must be switched.  “clresourcegroup switch” Solaris command is used for failover/failback purposes. It does the following:

  1. Shutdown of all resources of the resource group on the current node
  2. Deport of logical IP address, volumes groups
  3. Import of logical IP address, volumes groups on next node
  4. Starting of the resource group on next node

Red Hat Enterprise Linux with High Availability Add-on:
Red Hat provides an agent for SYBASE ASE for Red Hat Enterprise Linux with High Availability Add-on. The agent is called, “ASEHAagent – Sybase ASE Failover Instance”. A typical “SYBASE” service contains three resources:

  • Floating IP Address
  • A GFS used to store the shared database devices
  • An ASEHAagent

SYBASE ASE service (enable, disable, restart, and relocate) can be executed using a:

  • GUI tool (see next illustration)
  • Web tool “luci”
  • Command line


In collaboration with Red Hat, SAP has started to improve the official integration of SYBASE ASE. For more information check [14] and [15].

SUSE Linux Cluster Solution:
There is no support for Sybase ASE 15.7 yet, but customers can add their own live check scripts for SAP Sybase ASE. In collaboration with Novel, SAP has started to develop the official integration of SAP Sybase ASE. For more information, refer to the white paper, “SAP Made High-Available on SUSE Linux Enterprise Server for SAP Applications” on

In my next post, I will describe SAP ASE with HA option. The SAP ASE with HA option is built on top of the vendor failover cluster solutions outlined in this post. It ensures quicker failover and additional features pertinent to database HA needs.


General information:
[1] “Competitive Landscape: Clustering Software Market, Worldwide” GARTNER December 2012.
[2] “High availability and disaster recovery: concepts, design, implementation”, Klaus SCHMIDT, Springer 2006, ISBN 3540244603, 9783540244608

Symantec Veritas Cluster Server:

[3] Data Sheet: Clustering – Veritas™ Cluster Server for SAP Solutions
[3a] High Availability for Databases Protecting Sybase Databases with Veritas™ Cluster Server
[4] Sample configuration for a Sybase service group on AIX systems Article: HOWTO17258
[5] VCS Sybase agent 6.0 for AIX

HP Serviceguard:
[6] Managing Serviceguard Eighteenth Edition
[7] Managing Serviceguard Extension for SAP Version B.05.10

[8] Using the Sybase ASE Toolkit in a Serviceguard Cluster on HP-UX
[9] HP Serviceguard Enterprise Cluster Master Toolkit User Guide
Using Easy Deployment in Serviceguard and Metrocluster environments on HP-UX 11i v3 – (March 2012)

IBM PowerHA SystemMirror:
[10] IBM PowerHA SystemMirror documentation

[11] PowerHA resource at SCN:

[12] Sun Cluster 3.5 – Data services – Sybase ASE –
[13] Sun Cluster 4.1 – Howto Use Oracle Solaris Cluster Administration Commands to Create a Highly Available ServiceThat Uses the GDS p.187 –

Red Hat Cluster Suite:
[14] Red Hat Enterprise Linux Cluster Admin Guide
[15] Deploying Highly Available SAP Servers using Red Hat Clustering

[16]  SAP Sybase Adaptive Server Enterprise Getting Started with the Sybase Database and the SAP System

[17] 1650511 SYB: High Availability Offerings with Sybase ASE


Stay in the conversation by following SAP Services on SCN

Follow along throughout the event on Twitter at  @SAPServices

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Malcolm Yeoman
      Malcolm Yeoman

      Thanks Christian. I am finding your blog series very useful. When do you plan to deliver your next "SAP ASE with HA option" installment? 🙂

      Author's profile photo Christian SCHMITT
      Christian SCHMITT
      Blog Post Author

      Hello Malcolm,

      Thanks for your feedback. I will deliver my next post soon. In my next post, I will describe ASE with HA option concepts, how it is organized and some of the installation steps. Do you have any specific aspect you would like to be described ?

      Regards Christian

      Author's profile photo Malcolm Yeoman
      Malcolm Yeoman

      I think that any information you provide would be great. Specifically I would find it helpful to be able to explain to a customer the advantages of deploying the ASE HA option on top of the 3rd party failover solutions you have described i.e. what additional benefits/functionality does the ASE HA option bring?

      This would be particularly relevant if the customer does not already have the HA option bundled e.g. has a full use ASE license instead of a Business Suite runtime license.

      Regards Malcolm

      Author's profile photo Former Member
      Former Member

      Dear Christian,

      Firstly,Your blogs is good and gives us the idea about HA installation with different vendors but would like add few things which will be helpful to us.

      How to perform the HA installation with Microsoft Windows environement .I have read some notes which says that sap Note 1651052 has to be done but when has to be done??After the installation or before.Secondly the data files assignment ,do we need to assign 90gb of datafile in each drive let say we have assigned 3 drives for data files of 200 gb each or how it should be done,Thirdly CI,DI ASCS ,ERS which nodes we have to install these instances.If you could post any document or installation steps that will be helpful to us.Waiting for your reply.



      Author's profile photo Christian SCHMITT
      Christian SCHMITT
      Blog Post Author

      Hello Asim,

      Thank you for your feedback.
      In order to answer your questions I checked sap Note 1651052 and
      "Installation Guide SAP Systems Based on SAP NetWeaver 7.3 EHP1 Application Server ABAP+Java (for Process Integration) on Windows: Sybase ASE"
      As I do not know your own version, I chose a recent installation guide.

      Regarding Microsoft Cluster Server installation, the clusterware must be installed prior installing SAP software.
      You must be able to failover and failback before installing SAP software.

      Regarding datafile assignment, database data is hosted on shared disk. The documentation states that:
      "In an MSCS cluster, the shared disks that can be accessed by all MSCS nodes via a common bus must be addressed by all nodes with the same drive letters".
      As data is shared between cluster nodes, you only have to provision it once.

      Regarding CI, DI, ASCS, ERS instances, you have to cluster the instances that can be single point of failure (SPOFs).

      SCS instance, ASCS instance (message services and enqueue services),  Database instance are SPOFs as there is only one instance of them.
      Thus you have to include them in MS Cluster Server.
      Application server instances like dialog instances are multiple instances. The documentation states that you may not have to cluster them.

      Please refer to "Installation Guide SAP Systems Based on SAP NetWeaver 7.3 EHP1 Application Server ABAP+Java (for Process Integration) on Windows: Sybase ASE"

      The chapter 8 "High Availability with Microsoft Cluster Service" deals with specific Microsoft Cluster Server installation details.



      Author's profile photo Madhvi Pai
      Madhvi Pai

      Hi Christian,

      In reference to the SUSE Linux Cluster Connector solution for SAP on ASE - this combination seems to be supported per :

      This doc was released in Oct 2012.

      Am I missing something in terms of what has been mentioned in your note above,

      for the SUSE Cluster option?


      Madhvi Pai

      SAP AGS

      Author's profile photo Christian SCHMITT
      Christian SCHMITT
      Blog Post Author

      Hi Mahdvi,

      Thank you for pointing me this out. Actually, I refered to 'SAP Sybase Adaptive Server Enterprise Getting Started with the Sybase Database and the SAP System' where it was stated that there was no cluster support yet for ASE and SLES.

      But, you are right following certification report Certified HA-Interface Partners

      confirms that  SUSE Linux Enterprise high availability platform is a supported Business continuity solution for ASE and Business Suite.

      Thank very much, I will update this article and ask to update 'SAP Sybase Adaptive Server Enterprise Getting Started with the Sybase Database and the SAP System' as well.

      Thank again.

      Regards, Christian

      Author's profile photo Madhvi Pai
      Madhvi Pai

      no problem, Thanks, Christian.