HP Enterprise Cluster Master Toolkit User Guide (5900-2131, December 2011)

do for setting up a single-instance of ASE for failover in a Serviceguard cluster. Consult Sybase
ASE documentation for a detailed description on how to setup ASE in a cluster.
• Sybase ASE interfaces file
For setting up a single-instance of ASE in a Serviceguard cluster, the ASE instance should be
available at the same IP address across all nodes in the cluster. To achieve this, the interfaces
file of the ASE instance, available at the $SYBASE directory of that instance, should be edited.
For example, a default setup of ASE would have an interface entry for the dataserver as:
MIG29
master tcp ether mig29 5000
query tcp ether mig29 5000
This needs to be edited to have the re-locatable IP-address, as follows:
MIG29
master tcp ether 192.168.10.1 5000
query tcp ether 192.168.10.1 5000
If user requires a re-locatable hostname to be associated with this re-locatable IP-address,
there are two important things to be taken care of:
1. Use the re-locatable hostname in the srvbuild.adaptive_server.rs and similar files for all
the other 'server' processes and use srvbuildres utility to configure the servers.
2. Make the (relocatable_,P relocatable_hostname) pairs entry in the /etc/hosts (and also
in the nameserver, if necessary). The /etc/hosts, should then contain the <IP-address,
hostname> associated with each ASE instance along with the physical IP-address and
corresponding physical hostname entries.
- /etc/hosts
Ensure that the entries mentioned above are present in the /etc/hosts file before an
attempt is made to bring up the ASE processes.
For example, assume that the IP 192.168.10.1 is the associated IP and sybase0 is the
associated hostname with the ASE instance SYBASE0. The entry required in /etc/hosts
is:
192.168.10.1 sybase0
And in the adaptive server configuration file, the re-locatable hostname sybase0 should
be put in place of the hostname:
sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
as -
sqlsrv.network_hostname_list: sybase0
NOTE: If user does not wish to use a re-locatable hostname with the ASE instance, the
/etc/hosts file on each node should contain the re-locatable IP-address associated
with the physical hostname of that node. For example, if node1_hostname and
node2_hostname are the physical hostnames of two nodes in the cluster, and if
192.168.10.1 is the re-locatable IP-address for the ASE instance, then the /etc/hosts of
node1 should have an entry like: 192.168.10.1 node1_hostname
And the /etc/hosts file of node2 should have an entry like: 192.168.10.1
node2_hostname.
Database Maintenance
There might be situations, when the Sybase ASE database has to be taken down for maintenance
purposes like changing configuration, without having the instance to migrate to standby node. The
Database Maintenance 69