The CRG_RECOVERY_DOMAIN table function returns details about about nodes in a cluster resource group recovery domain.
...
Column Name | Data Type | Description |
|---|---|---|
CLUSTER_RESOURCE_GROUP | VARCHAR(10) | The name of the cluster resource group |
CONSISTENT_INFORMATION | VARCHAR(3) | Indicates whether or not the displayed information is consistent with other nodes in the cluster. YES The information is consistent for all active nodes in the cluster. NO The information retrieved from the node running the command may not be consistent with all the active nodes in the cluster. In order to obtain consistent information run the command on an active node, or start this node and run the command again. |
NODE | VARCHAR(8) | A valid simple name that uniquely identifies a node. |
NODE_STATUS | VARCHAR(20) | The cluster resource group membership status for the node. ACTIVE The node is an active member of the cluster resource group membership. INACTIVE The node is not an active member of the administrative domain cluster resource group membership. Cluster Resource Services may not be active on the node or the cluster resource group job could be ended on the node. PARTITION The node is partitioned from the other members of the cluster resource group. INELIGIBLE The node is an active member of the cluster resource group membership but not eligible to become the cluster resource group primary node. This could be because replication is not properly configured or not currently active. UNKNOWN The node this command is being run on is not an active member of the cluster so the status of other nodes cannot be determined. |
CURRENT_NODE_ROLE | INTEGER | The current role the node has in the current recovery domain. For primary-backup model cluster resource groups a node can have one of three roles: primary, backup, or replicate. Only one node can be designated as the primary. Backup nodes are assigned a backup order. One indicates the first backup, two the second backup, and so on. Replicates are not ordered and cannot become a primary or backup node. For peer model cluster resource groups a node can have one of two roles: peer or replicate. Any number of nodes can be designated as the peer or replicate. Peer nodes are not ordered and can be an active access point for the cluster resources. 0 Primary node. Only one node can have this value. >=1 Backup node. The backup order is designated by increasing value. -1 Replicate node. All replicates have this value. -4 Peer node. All peers have this value. |
PREFERRED_NODE_ROLE | INTEGER | The preferred role the node has in the recovery domain. For primary-backup model cluster resource groups a node can have one of three roles: primary, backup, or replicate. Only one node can be designated as the primary. Backup nodes are assigned a backup order. One indicates the first backup, two the second backup, and so on. Replicates are not ordered and cannot become a primary or backup node. For peer model cluster resource groups a node can have one of two roles: peer or replicate. Any number of nodes can be designated as the peer or replicate. Peer nodes are not ordered and can be an active access point for the cluster resources. 0 Primary node. Only one node can have this value. >=1 Backup node. The backup order is designated by increasing value. -1 Replicate node. All replicates have this value. -4 Peer node. All peers have this value. |
SITE_NAME | VARCHAR(8) | A site contains a subset of recovery domain nodes in the same physical location. All nodes at a site have access to the same copy of the auxiliary storage pool. Contains the null value if no site is defined for the node. |
DATA_PORT_IP1 | VARCHAR(45) | A data port IP address is used to send updates from a source node that owns the production copy of auxiliary storage pool to a target node that owns the mirror copy of the auxiliary storage pool. Contains the null value if no data port IP addresses are defined for the node. |
DATA_PORT_IP2 | VARCHAR(45) | A data port IP address is used to send updates from a source node that owns the production copy of auxiliary storage pool to a target node that owns the mirror copy of the auxiliary storage pool. Contains the null value if less than two data port IP addresses are defined for the node. |
DATA_PORT_IP3 | VARCHAR(45) | A data port IP address is used to send updates from a source node that owns the production copy of auxiliary storage pool to a target node that owns the mirror copy of the auxiliary storage pool. Contains the null value if less than three data port IP addresses are defined for the node. |
DATA_PORT_IP4 | VARCHAR(45) | A data port IP address is used to send updates from a source node that owns the production copy of auxiliary storage pool to a target node that owns the mirror copy of the auxiliary storage pool. Contains the null value if less than four data port IP addresses are defined for the node. |
Examples
Example 1 - Get the recovery domain for a CRG
This example gets the current recovery domain for a CRG named MYCRG ordered by node role so that the primary node is first.
| Code Block | ||
|---|---|---|
| ||
SELECT NODE, NODE_STATUS, CURRENT_NODE_ROLE FROM TABLE(QHASM.CRG_RECOVERY_DOMAIN(CLUSTER_RESOURCE_GROUP => 'DSMMCRG')) RCYDMN ORDER BY CURRENT_NODE_ROLE; |
Example 1 - Sample Output
NODE | NODE_STATUS | CURRENT_NODE_ROLE |
|---|---|---|
PROD | ACTIVE | 0 |
HA | ACTIVE | 1 |
DR | ACTIVE | 2 |
SQLSTATE Values
Errors and warnings returned by this function are returned as SQL state values. Possible SQLSTATE values returned by this view are:
...