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