Enabling the Informix Instances to Run in a Cluster

This section contains the procedure that you need to verify the Informix installation.

How to Enable the Informix Instances to Run in a Cluster

Use this procedure to verify the Informix instance. Perform the following steps on a node or zone on which the Informix instance can run.

1. Log in to the cluster node or zone on which you installed the Informix software.
2. Shut down the Informix instance.

   For more information about how to start or stop Informix, see http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp

3. Mount the highly available local file system if used.
4. Create the failover resource group to hold the network and application resources.

   # clresourcegroup create ids-rg

   ---

   Note - Use the -n option to the clresourcegroup command to select the set of nodes or zones on which the Informix application can run.

   # clresourcegroup create ids-rg [-n node-zone-list]

   ---

5. Verify that you have added to your name service database all the network resources that you use.
6. Add a network resource (logical hostname) to the failover resource group.

   # clreslogicalhostname create -g ids-rg [-h lhost[,...]] [-d] ids-lh

7. Edit the $INFORMIXDIR/etc/sqlhosts.$INFORMIXSERVER file and update the hostname to reflect the logical host.
8. Add the HAStoragePlus resource to the resource group for the failover application.

   # clresource register SUNW.HAStoragePlus
   # clresource create -g ids-rg \
   -t SUNW.HAStoragePlus \
   -p filesystemmountpoints=mountpoint,... ids-has

   The resource is created in the enabled state.

   ---

   Tip - This HAStoragePlus resource is used for the $INFORMIXSERVER file.

   ---

   For more information on how to set up an HAStoragePlus resource, see “Enabling Highly Available Local File Systems” in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

9. Enable the resource group.

   Run the clresourcegroup(1CL) command to move the resource group into a managed state and bring the resource group online.

   # clresourcegroup online -M ids-rg

10. Start the Informix database on a node where the resource group is online.

    Ensure that the Informix database starts smoothly by connecting to the database by using the logical hostname.

11. Shut down the Informix database.
12. As user root, switch the Informix database resource group to another cluster member.

    # clresourcegroup switch -n node[:zone] ids-rg

13. Start the Informix database.

    Ensure that the Informix database starts smoothly by connecting to the database by using the logical hostname.

14. Ensure that you switch the Informix resource group to all the nodes in the resource group's nodelist and also ensure that you can start Informix on all the nodes of the cluster.