...
Authorization as required by PowerHA product functionality.
*USE authority to the Administrative Domain Cluster Resource Group Object.
Input/output system configuration (*IOSYSCFG) special authority.
...
The result of the function is a table containing a row for each monitored resource with the format shown in the following table.
Column Name | Data Type | Description |
|---|---|---|
ADMINISTRATIVE_DOMAIN | VARCHAR(10) | The name of an administrative domain. |
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 status of the node in the cluster. ACTIVE The node is an active member of the administrative domain membership. INACTIVE The node is not an active member of the administrative domain membership. Cluster Resource Services may not be active on the node or the administrative domain job could be ended on the node. PARTITION The node is partitioned from the other members of the administrative domain. 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. |
Examples
Example 1 - Get the list of nodes in the local administrative domain that do not have a status of active
...
Example 1 - Sample Output
NODE | NODE_STATUS |
|---|---|
NODEA | INACTIVE |
NODEB | INACTIVE |
Example 2 - Get the list of nodes in the the administrative domain ADMDMN that do not have a status of active
| Code Block | ||
|---|---|---|
| ||
SELECT NODE,NODE_STATUS FROM table(QHASM.ADMIN_DOMAIN_NODES(ADMINISTRATIVE_DOMAIN => 'ADMDMN')) WHERE NODE_STATUS != 'ACTIVE'; |
Example 2 - Sample Output
NODE | NODE_STATUS |
|---|---|
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 |
|---|---|
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 ADMINISTRATIVE DOMAIN &1 DOES NOT EXIST |
42704 | CLUSTER DOES NOT EXIST |
42704 | LOCAL NODE NOT PART OF ANY EXISTING CLUSTER ADMINISTRATIVE DOMAIN |
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 ADMINISTRATIVE DOMAIN &1 NOT AVAILABLE |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |