QHASM.CRG_INFO table function
- Brian Nordland
The CRG_INFO table function returns details about a cluster resource group.
Authorization
The authorization ID of the statement must include the following privileges:
Authorization as required by PowerHA product functionality.
Input/output system configuration (*IOSYSCFG) special authority.
Allows access to the object attributes and use of the object(*USE) to the CRG object.
Parameters
QHASM.CRG_INFO ( CLUSTER_RESOURCE_GROUP => cluster-resource-group-name )The schema is QHASM.
cluster-resource-group-name
Specifies the name of the cluster resource group.
Result Table
The result of the function is a table containing a single row for the CRG with the format shown in the following table.
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. |
CRG_TYPE | VARCHAR(5) | The type of the cluster resource group. *APP The cluster resource group is an application cluster resource group. *DATA The cluster resource group is a data cluster resource group. *DEV The cluster resource group is a device cluster resource group. *PEER The cluster resource group is a peer cluster resource group. |
CRG_STATUS | VARCHAR(30) | The status of the cluster resource group. ACTIVE The resources managed by the cluster resource group are currently resilient. INACTIVE The resources managed by the cluster resource group are not currently resilient. INDOUBT The information contained within the cluster resource group object may not be accurate. This status occurs when an exit program is called with an action code of Undo and fails to complete successfully. RESTORED The cluster resource group object was restored on this node and has not been copied to the other nodes in the recovery domain. When Cluster Resource Services is started on this node, the cluster resource group will be synchronized with the other nodes in the recovery domain and its status set to Inactive. ADD PENDING A new node is in the process of being added to the recovery domain of a cluster resource group. If the exit program is successful the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. DELETE PENDING Cluster resource group object is in the process of being deleted. When the exit program completes the cluster resource group is deleted from all nodes in the recovery domain. CHANGE PENDING The cluster resource group is in the process of being changed. If the exit program is successful the status is reset to the value at the time the command was called. If the exit program fails and the original state cannot be recovered, status is set to Indoubt. END PENDING Resilience for the cluster resource group is in the process of ending. If the exit program is successful, the status is set to Inactive. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. INITIALIZE PENDING A cluster resource group is being created and is in the process of being initialized. If the exit program is successful, the status is set to Inactive. If the exit program fails, the cluster resource group will be deleted from all nodes. REMOVE PENDING A node is in the process of being removed from the recovery domain of the cluster resource group. If the exit program is successful, the status is reset to the value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. START PENDING Resilience is in the process of starting for the cluster resource group. If the exit program is successful, the status is set to Active. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. SWITCHOVER PENDING The Change Cluster Resource Group Primary (CHGCRGPRI) command was called, a failure of a cluster resource group occurred, or a node failed, causing a switchover or failure to begin. The first backup node is in the process of becoming the primary node. If the exit program is successful, the status is set to Active. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. DELETE PENDING Cluster resource group object is being deleted by the Delete Cluster Resource Group (DLTCRG) command. The Cluster resource group object is only removed from the node running the command. This is not a distributed request. At the completion of the command, the cluster resource group is deleted from the node. ADD DEVICE PENDING A device entry is being added to a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. REMOVE DEVICE PENDING A device entry is being removed from a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. CHANGE DEVICE PENDING A device entry is being changed in a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. CHANGE STATUS PENDING The status of a node in the cluster resource group's current recovery domain is being changed. If the change is successful, the status is reset to its value at the time the Change Cluster Node Entry (CHGCLUNODE) command was called. Failure of the exit program causes the status of the cluster resource group to be set to Indoubt. If a backup node is reassigned as the primary node for a resilient device cluster resource group and the ownership of the device cannot be transferred to the new primary node, the status is set to Indoubt. EXIT POINT OPERATION PENDING An exit point operation is in progress. |
PREVIOUS_CRG_STATUS | VARCHAR(30) | Indicates the status of this cluster resource group before the current request was executed. ACTIVE The resources managed by the cluster resource group are currently resilient. INACTIVE The resources managed by the cluster resource group are not currently resilient. INDOUBT The information contained within the cluster resource group object may not be accurate. This status occurs when an exit program is called with an action code of Undo and fails to complete successfully. RESTORED The cluster resource group object was restored on this node and has not been copied to the other nodes in the recovery domain. When Cluster Resource Services is started on this node, the cluster resource group will be synchronized with the other nodes in the recovery domain and its status set to Inactive. ADD PENDING A new node is in the process of being added to the recovery domain of a cluster resource group. If the exit program is successful the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. DELETE PENDING Cluster resource group object is in the process of being deleted. When the exit program completes the cluster resource group is deleted from all nodes in the recovery domain. CHANGE PENDING The cluster resource group is in the process of being changed. If the exit program is successful the status is reset to the value at the time the command was called. If the exit program fails and the original state cannot be recovered, status is set to Indoubt. END PENDING Resilience for the cluster resource group is in the process of ending. If the exit program is successful, the status is set to Inactive. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. INITIALIZE PENDING A cluster resource group is being created and is in the process of being initialized. If the exit program is successful, the status is set to Inactive. If the exit program fails, the cluster resource group will be deleted from all nodes. REMOVE PENDING A node is in the process of being removed from the recovery domain of the cluster resource group. If the exit program is successful, the status is reset to the value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. START PENDING Resilience is in the process of starting for the cluster resource group. If the exit program is successful, the status is set to Active. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. SWITCHOVER PENDING The Change Cluster Resource Group Primary (CHGCRGPRI) command was called, a failure of a cluster resource group occurred, or a node failed, causing a switchover or failure to begin. The first backup node is in the process of becoming the primary node. If the exit program is successful, the status is set to Active. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. DELETE PENDING Cluster resource group object is being deleted by the Delete Cluster Resource Group (DLTCRG) command. The Cluster resource group object is only removed from the node running the command. This is not a distributed request. At the completion of the command, the cluster resource group is deleted from the node. ADD DEVICE PENDING A device entry is being added to a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. REMOVE DEVICE PENDING A device entry is being removed from a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. CHANGE DEVICE PENDING A device entry is being changed in a cluster resource group. If the exit program is successful, the status is reset to its value at the time the command was called. If the exit program fails and the original state cannot be recovered, the status is set to Indoubt. CHANGE STATUS PENDING The status of a node in the cluster resource group's current recovery domain is being changed. If the change is successful, the status is reset to its value at the time the Change Cluster Node Entry (CHGCLUNODE) command was called. Failure of the exit program causes the status of the cluster resource group to be set to Indoubt. If a backup node is reassigned as the primary node for a resilient device cluster resource group and the ownership of the device cannot be transferred to the new primary node, the status is set to Indoubt. EXIT POINT OPERATION PENDING An exit point operation is in progress. |
EXIT_PROGRAM | VARCHAR(10) | The name of the user provided exit program. Contains the null value if no exit program is specified for the cluster resource group. |
EXIT_PROGRAM_LIBRARY | VARCHAR(10) | The name of the library that contains the exit program for the cluster resource group. Contains the null value if no exit program is specified for the cluster resource group. |
EXIT_PROGRAM_JOB_NAME | VARCHAR(10) | The name given the batch job that is submitted to invoke the cluster resource group exit program. Valid special values for this field are: *JOBD The job name is determined from the job description specified in the user profile for the cluster resource group exit program. Contains the null value if no exit program is specified for the cluster resource group. |
EXIT_PROGRAM_FORMAT | VARCHAR(8) | Indicates which format should be used for the Information Given To User parameter on the cluster resource group exit program when it is called. Contains the null value if no exit program is specified for the cluster resource group. |
EXIT_PROGRAM_DATA | BINARY(256) | 256 bytes of data which is passed to the cluster resource group exit program when it is called. Contains the null value if no exit program is specified for the cluster resource group. |
USER_PROFILE | VARCHAR(10) | The name of the user profile under which the cluster resource group exit program is run. Contains the null value if no exit program is specified for the cluster resource group. |
TEXT | VARCHAR(50) | The text description associated with the cluster resource group object. Contains the null value if there is no text description for the cluster resource group. |
DISTRIBUTED_INFORMATION_QUEUE | VARCHAR(10) | The name of the user queue to receive distributed information from the Distribute Information (QcstDistributeInformation) API. Contains the null value if no user queue is specified for the cluster resource group. |
DISTRIBUTED_INFORMATION_QUEUE_LIBRARY | VARCHAR(10) | The name of the library that contains the user queue to receive distributed information. Contains the null value if no user queue is specified for the cluster resource group. |
FAILOVER_MESSAGE_QUEUE | VARCHAR(10) | The name of the message queue to receive messages dealing with failover. Contains the null value if no message queue is specified for the cluster resource group. |
FAILOVER_MESSAGE_QUEUE_LIBRARY | VARCHAR(10) | Specifies the name of the library that contains the cluster message queue. Contains the null value if no message queue is specified. |
FAILOVER_WAIT_TIME | INTEGER | Number of minutes to wait for a reply to the failover message that was enqueued on the cluster message queue. -1 Wait forever until a reply is given to the failover inquiry message. 0 Proceed without user intervention. >=1 Number of minutes to wait for a reply to the failover message. If no reply is received in the specified number of minutes, the failover default action field will be looked at to decide how to proceed. |
FAILOVER_DEFAULT_ACTION | VARCHAR(8) | Indicates what clustering should do when a reply to the failover message on the cluster message queue is not received within the time limit specified for the failover wait time parameter. *PROCEED Proceed with failover. *CANCEL Do NOT attempt failover. |
APPLICATION_IDENTIFIER | VARCHAR(20) | This identifies the purpose of the cluster resource group. Contains the null value if there is no application identifier. |
TAKEOVER_IP_ADDRESS | VARCHAR(45) | The internet interface address that is to be associated with an application. This is the takeover IP address that will be switched between systems. The takeover IP address may be an IPv4 address (for any cluster version) or IPv6 address (if current cluster version is 7 or greater). Contains the null value if this is not an application CRG. |
TAKEOVER_IP_ADDRESS_RESPONSIBILITY | VARCHAR(4) | Indicates who is responsible for configuring (adding and removing) the takeover IP address. This does not affect the starting and ending of the takeover IP address, Cluster Resource Services will perform this function. *CRS Cluster Resource Services is responsible for configuring the takeover IP address. The takeover IP address must not exist on any of the nodes in the recovery domain prior to creating the cluster resource group. The takeover IP address will be removed when the cluster resource group is deleted. *USR User is responsible for configuring the takeover IP address. The takeover IP address must be added on all nodes in the recovery domain except replicates prior to starting the cluster resource group. Contains the null value if this is not an application CRG. |
ALLOW_ACTIVE_IP_ADDRESS | VARCHAR(4) | Indicates whether or not a takeover IP address can be active when starting an application cluster resource group. *YES Do not allow the takeover IP address to already be active when starting the cluster resource group. *NO Allow the takeover IP address to already be active when starting the cluster resource group. Contains the null value if this is not an application CRG. |
ALLOW_APPLICATION_RESTART | VARCHAR(4) | Indicates whether or not to restart an application if the cluster resource group exit program fails. *YES Do not attempt to restart the application. The cluster resource group exit program is called with an action code of Failover. *NO Attempt to restart the application on the same node. The cluster resource group exit program will be called with an action code of Restart. If the application cannot be restarted in the specified maximum number of attempts, the cluster resource group exit program will be called with an action code of Failover. Contains the null value if this is not an application CRG. |
NUMBER_OF_APPLICATION_RESTARTS | INTEGER | Indicates the number of times a cluster resource group exit program can be called on a same node before failure occurs. Maximum number of restarts is 3. If the cluster resource group is currently active, any change does not take affect until failover occurs or the cluster resource group exit program job ends. Contains the null value if this is not an application CRG. |
CONTAINER | VARCHAR(10) | The container managing this cluster resource group (CRG). Contains the null value if this is a stand-alone CRG that is not managed by a container. This column is not supported on IBM i 7.2 or IBM i 7.3 |
Examples
Example 1 - Get the name and text description for every cluster resource group in the cluster
This example gets the name and text description for every CRG in the cluster.
SELECT CRGINFO.CLUSTER_RESOURCE_GROUP, CRGINFO.TEXT
FROM QHASM.CRG_LIST LIST,
TABLE(QHASM.CRG_INFO(CLUSTER_RESOURCE_GROUP => LIST.CLUSTER_RESOURCE_GROUP)) CRGINFO;Example 1 - Sample Output
CLUSTER_RESOURCE_GROUP | TEXT DESCRIPTION |
|---|---|
ERP01 | ERP Application CRG |
GMIRCRG | Global Mirror Device CRG |
SQLSTATE Values
Errors and warnings returned by this function are returned as SQL state values. Possible SQLSTATE values returned by this view are:
SQLSTATE | Message |
|---|---|
22023 | INVALID VALUE SPECIFIED FOR PARAMETER &1: &2 |
42501 | NOT AUTHORIZED TO LIBRARY &1 |
42501 | NOT AUTHORIZED TO OBJECT &1 IN &2 |
42502 | CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY |
42704 | CLUSTER DOES NOT EXIST |
42704 | CLUSTER RESOURCE GROUP &1 DOES NOT EXIST |
560CR | NO VALID LICENSE FOR IBM POWERHA FOR I FOUND |
560CR | POWERHA FOR I ENTERPRISE EDITION NOT INSTALLED ON NODE &1 |
560CR | GRACE PERIOD EXPIRED FOR POWERHA FOR I ENTERPRISE EDITION ON NODE &1 |
560CR | USAGE LIMIT EXCEEDED FOR POWERHA FOR I ENTERPRISE EDITION ON NODE &1 |
560CR | POWERHA FOR I STANDARD EDITION NOT INSTALLED ON NODE &1 |
560CR | GRACE PERIOD EXPIRED FOR POWERHA FOR I STANDARD EDITION ON NODE &1 |
560CR | USAGE LIMIT EXCEEDED FOR POWERHA FOR I STANDARD EDITION ON NODE &1 |
560CR | POWERHA FOR I STANDARD EXPRESS NOT INSTALLED ON NODE &1 |
560CR | GRACE PERIOD EXPIRED FOR POWERHA FOR I STANDARD EXPRESS ON NODE &1 |
560CR | USAGE LIMIT EXCEEDED FOR POWERHA FOR I STANDARD EXPRESS ON NODE &1 |
57012 | CLUSTER RESOURCE SERVICES NOT ACTIVE OR NOT RESPONDING |
57012 | INFORMATION FOR CLUSTER RESOURCE GROUP &1 NOT AVAILABLE |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.