The ADMIN_DOMAIN_NODES table function returns information about the nodes in an administrative domain.

Authorization

The authorization ID of the statement must include the following privileges:

Authorization as required by PowerHA product functionality.
*USE authority to the Administrative Domain Cluster Resource Group Object.
Input/output system configuration (*IOSYSCFG) special authority.

Parameters

QHASM.ADMIN_DOMAIN_NODES ( ADMINISTRATIVE_DOMAIN => administrative-domain-name )

The schema is QHASM.

administrative-domain-name

Specifies the cluster administrative domain that is monitoring resources.

The following special values are allowed for administrative-domain-name:

*

The name of the cluster administrative domain the local cluster node is a part of is used. This is the default value if the ADMINISTRATIVE_DOMAIN parameter is not specified.

Result Table

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

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

SELECT NODE,NODE_STATUS
  FROM table(QHASM.ADMIN_DOMAIN_NODES())
  WHERE NODE_STATUS != 'ACTIVE';

Example 1 - Sample Output

NODE	NODE_STATUS

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

SELECT NODE,NODE_STATUS
  FROM table(QHASM.ADMIN_DOMAIN_NODES(ADMINISTRATIVE_DOMAIN => 'ADMDMN'))
  WHERE NODE_STATUS != 'ACTIVE';

Example 2 - Sample Output

NODE	NODE_STATUS

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

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

IBM Partnership

QHASM.ADMIN_DOMAIN_NODES table function