DB2 10.5 for Linux, UNIX, and Windows

IBM Tivoli System Automation for Multiplatforms (Linux and AIX)

IBM® Tivoli® System Automation for Multiplatforms (SA MP) is cluster managing software that facilitates automatic switching of users, applications, and data from one database system to another in a cluster. Tivoli SA MP automates control of IT resources such as processes, file systems, and IP addresses.

Tivoli SA MP provides a framework to automatically manage the availability of what are known as resources. Here are some examples of resources:

Any piece of software for which start, monitor, and stop scripts can be written to control
Any network interface card (NIC) to which Tivoli SA MP was granted access. That is, Tivoli SA MP manages the availability of any IP address that a user wants to use by floating that IP address among NICs that it has access to.

For example, both a DB2® instance and high availability disaster recovery have start, stop, and monitor commands. Therefore, Tivoli SA MP scripts can be written to automatically manage these resources. Resources that are closely related (for example, ones that collectively run on the same node at the same time) are called a resource group.

DB2 resources

In a single-partition DB2 environment, a single DB2 instance is running on a server. This DB2 instance has local access to data (its own executable image as well as databases owned by the instance). If this DB2 instance is made accessible to remote clients, an unused IP address must be assigned to this DB2 instance.

The DB2 instance, the local data, and the IP address are all considered resources, which must be automated by Tivoli SA MP. Since these resources are closely related (for example, they collectively run on the same node at the same time), they are called a resource group.

The entire resource group is collocated on one node in the cluster. In the case of a failover, the entire resource group is started on another node.

The following dependencies exist between the resources in the group:

The DB2 instance must be started after the local disk
The DB2 instance must be stopped before the local disk
The HA IP address must be collocated with the instance

Disk storage

The DB2 database can use these resources for local data storage:

Raw disk (for example, /dev/sda1)
Logical volume that is managed by Logical Volume Manager (LVM)
File system (for example, ext3, jfs)

DB2 data can be stored either entirely on one or more raw disks, entirely on logical volumes, entirely on file systems, or on a mixture of all three. Any executables need to be on a file system of some sort.

DB2 database requirements for the HA IP address

The DB2 database has no special requirements for the IP address. It is not necessary to define a highly available IP address in order for the instance to be considered highly available. However, it is important to remember that the IP address that is protected (if any) is the client's access point to the data, and as such, this address must be known by all clients. In practice, it is recommended that this IP address be the one that is used by the clients in their CATALOG TCPIP NODE commands.

Tivoli SA MP resource groups

IBM Tivoli System Automation for Multiplatforms is a product that provides high availability by automating resources such as processes, applications, IP addresses, and others in Linux-based clusters. To automate an IT resource (such as an IP address), the resource must be defined to Tivoli SA MP. Furthermore, these resources must all be contained in at least one resource group. If these resources are always required to be hosted on the same machine, they should all be placed in the same resource group.

To be managed and automated with Tivoli SA MP, every application needs to be defined as a resource. Application resources are usually defined in the generic resource class IBM.Application. In this resource class, there are several attributes that define a resource, but at least three of them are application-specific:

StartCommand
StopCommand
MonitorCommand

These commands can be scripts or binary executables.

Setting up Tivoli SA MP with your DB2 environment

For detailed configuration information to help you set up SA MP to work with your DB2 environment, search the IBM Tivoli System Automation for Multiplatforms (SA MP) section of Tivoli documentation central here.