QHASM.ADMIN_DOMAIN_LIST View
The administrative domain list view contains information about administrative domains in the cluster.
The values returned for the columns in this view contain information represented differently from the panels of the WRKCLU OPTION(*ADMDMN) CL command.
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/CAD_LIST.
Input/output system configuration (*IOSYSCFG) special authority.
Result Table
The table describes the columns in the view. Here, the system name is CAD_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 the current node and run the command again. |
ADMINISTRATIVE_DOMAIN | ADMDMN | VARCHAR(10) | The name of the cluster administrative domain. |
DOMAIN_STATUS | CADSTS | VARCHAR(30) | The status of the cluster administrative domain. 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. 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. 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. |
SYNC_OPTION | SYNCOPT | VARCHAR(8) | Specifies the synchronization behavior when a node joins a cluster administrative domain. *LASTCHG Last change. The last change that was made before the node joined the cluster administrative domain is processed by all nodes in the active domain. The last change could have been made in the active domain or on the joining node while it was inactive. *ACTDMN Active domain. Only changes made on active nodes in an active cluster administrative domain are processed. Changes made on a node while it was inactive are not passed to the active domain. When a node joins the cluster administrative domain, it will be synchronized with the values from the active domain. Contains the null value if the sync option is unknown. This can happen for example if the local node is not in the administrative domain and clustering is not active on both the local node and at least one node in the administrative domain. |
Examples
Example 1 - Get the list of administrative domains in the cluster that do not have a status of active
To obtain the list of administrative domains in the cluster that are not active, enter this statement:
SELECT ADMINISTRATIVE_DOMAIN,DOMAIN_STATUS
FROM QHASM.ADMIN_DOMAIN_LIST
WHERE DOMAIN_STATUS != 'ACTIVE';Example 1 - Sample Output
List results of administrative domains that are not active:
ADMINISTRATIVE_DOMAIN | DOMAIN_STATUS |
|---|---|
ADMDMN | 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 CAD_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.