OCF_HEARTBEAT_DB2(7)						OCF resource agents					      OCF_HEARTBEAT_DB2(7)

NAME

       ocf_heartbeat_db2 - Resource Agent that manages an IBM DB2 LUW databases in Standard role as primitive or in HADR roles as master/slave
       configuration. Multiple partitions are supported.

SYNOPSIS

       db2 [start | stop | monitor | promote | demote | meta-data | validate-all]

DESCRIPTION

       Resource Agent that manages an IBM DB2 LUW databases in Standard role as primitive or in HADR roles in master/slave configuration. Multiple
       partitions are supported.

       Standard mode:

       An instance including all or selected databases is made highly available. Configure each partition as a separate primitive resource.

       HADR mode:

       A single database in HADR configuration is made highly available by automating takeover operations. Configure a master / slave resource
       with notifications enabled and an additional monitoring operation with role "Master".

       In case of HADR be very deliberate in specifying intervals/timeouts. The detection of a failure including promote must complete within
       HADR_PEER_WINDOW.

       In addition to honoring requirements for crash recovery etc. for your specific database use the following relations as guidance:

       "monitor interval" < HADR_PEER_WINDOW - (appr 30 sec)

       "promote timeout" < HADR_PEER_WINDOW + (appr 20 sec)

       For further information and examples consult http://www.linux-ha.org/wiki/db2_(resource_agent)

SUPPORTED PARAMETERS

       instance
	   The instance of the database(s).  (unique, required, string, no default)

       dblist
	   List of databases to be managed, e.g "db1 db2". Defaults to all databases in the instance. Specify one db for HADR mode.  (optional,
	   string, no default)

       admin
	   DEPRECATED: The admin user of the instance.	(optional, string, no default)

       dbpartitionnum
	   The number of the partion (DBPARTITIONNUM) to be managed.  (optional, string, default 0)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 120.

       stop
	   Stops the resource. Suggested minimum timeout: 120.

       promote
	   Promotes the resource to the Master role. Suggested minimum timeout: 120.

       demote
	   Demotes the resource to the Slave role. Suggested minimum timeout: 120.

       notify
	   Suggested minimum timeout: 10.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 20.

       monitor (Master role)
	   Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 22.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a db2 resource using the crm(8) shell:

	   primitive p_db2 ocf:heartbeat:db2 
	     params 
	       instance=string 
	     op monitor depth="0" timeout="60" interval="20" 
	     op monitor depth="0" timeout="60" role="Master" interval="22"

	   ms ms_db2 p_db2 
	     meta notify="true" interleave="true"

SEE ALSO

       http://www.linux-ha.org/wiki/db2_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents UNKNOWN 					    03/09/2014						      OCF_HEARTBEAT_DB2(7)