QHASM.Cluster_Nodes View
- Brian Nordland
The QHASM.Cluster_Nodes view shows information about the nodes in the cluster.
The values returned for the columns in this view contain information from the DSPCLUINF CL command but represents them differently.
Authorization
The authorization ID of the statement must include the following privileges:
Authorization as required by PowerHA product functionality.
*OBJOPR and *READ authority on QHASM/NODE_LIST.
Input/output system configuration (*IOSYSCFG) special authority.
Result Table
The table describes the columns in the view. Here, the system name is NODE_LIST and the schema is QHASM.
Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
CLUSTER | CLUSTER | VARCHAR(10) | The name of the cluster |
CONSISTENT_INFORMATION | CLUSTS | 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 | NODE | VARCHAR(8) | A valid simple name that uniquely identifies a node. |
IS_CURRENT_NODE | ISCURNODE | CHAR(1) | Indicates whether or not the node is the local node the query was executed on. Y The query was executed on this node. N The query was executed on a node other than this node. |
NODE_STATUS | NODSTS | VARCHAR(20) | The status of the node in the cluster. NEW A node has been added to the cluster membership list but the Cluster Resource Services has never been started on that node. ACTIVE The node has been started. Cluster Resource Services is active on the node. ACTIVE PENDING The node is in the process of being started. In addition, the node could have previously had a status of Partition and will change to the Active Pending status as a result of the partitions being merged. FAILED A previously active node has failed. A failure is defined to be a system or clustering failure detected by Cluster Resource Services. INACTIVE Cluster Resource Services has been ended on the node as the result of an End Cluster Node (ENDCLUNOD) command call. The node is no longer communicating with other nodes in the cluster. INACTIVE PENDING Cluster Resource Services is in the process of ending on this node as the result of an End Cluster Node (ENDCLUNOD) command call. PARTITION The node is communicating with only a subset of the cluster due to a network failure detected by Cluster Resource Services which has resulted in the loss of communications to one or more nodes in the cluster. Once the partitioned nodes have been merged back into a whole cluster, the node will change to Active status without operator intervention. REMOVE PENDING The node is in the process of being removed from the cluster membership list as the result of a Remove Cluster Node Entry (RMVCLUNODE) command. 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. |
NODE_PRIMARY_IP | NODE_IP1 | VARCHAR(45) | The preferred IP address in IPv4 or IPv6 format for the primary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster. |
NODE_SECONDARY_IP | NODE_IP2 | VARCHAR(45) | A second IP address in IPv4 or IPv6 format for the primary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster. Contains the null value when a second IP address is not configured. |
DEVICE_DOMAIN | DEVDMN | VARCHAR(10) | The name of the device domain that this node belongs to. Contains the null value when this node is not in a device domain. |
POTENTIAL_CLUSTER_VERSION | CLUVER | INTEGER | The version at which the node is capable of communicating with the other nodes in the cluster. This is the value associated with the cluster code installed on the node. It will be used to determine if the node can join a cluster. If communications have not yet been established with the node (status of New), then the potential node version will be reported as 0. |
POTENTIAL_CLUSTER_MODIFICATION | CLUMODLVL | INTEGER | The modification level of the potential node version. The modification level further identifies the version at which the node is capable of communicating with the other nodes in the cluster. It is updated when code changes that impact the version are applied to the system. |
POTENTIAL_POWERHA_VERSION | HAVER | INTEGER Nullable | The version at which the PowerHA product installed on the node in the cluster is capable of communicating with other PowerHA nodes. Contains the null value when the current potential modification level is unknown. |
POTENTIAL_POWERHA_MODIFICATION | HAMODLVL | INTEGER Nullable | The modification level at which the PowerHA product installed on the node in the cluster is capable of communicating with other PowerHA nodes. Contains the null value when the current potential modification level is unknown. |
POTENTIAL_POWERHA_FIX_LEVEL | HAFIXLVL | INTEGER Nullable | The fix level at which the PowerHA product installed on the node in the cluster is capable of communicating with other PowerHA nodes. Contains the null value when the current potential modification level is unknown. |
Examples
Example 1 - Get the list of cluster nodes that do not have a status of active
SELECT NODE,NODE_STATUS FROM QHASM.CLUSTER_NODES WHERE NODE_STATUS != 'ACTIVE';Example 1 - Sample Output
Node | Status |
|---|---|
NODEA | INACTIVE |
NODEC | INACTIVE |
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 |
|---|---|
42501 | Not authorized to object NODE_LIST in QHASM type *FILE |
42501 | NOT AUTHORIZED TO LIBRARY &1 |
42502 | CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY |
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 |
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.