QHASM.ADMIN_DOMAIN_MRE_DETAILS table function
- Brian Nordland
- Shengli Li
The ADMIN_DOMAIN_MRE_DETAILS table function returns details about a monitored resource entry in a cluster 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_MRE_DETAILS (MONITORED_RESOURCE => monitored-resource,
RESOURCE_TYPE => monitored-resource-type,
LIBRARY => monitored-resource-library,
ADMINISTRATIVE_DOMAIN => administrative-domain-name)The schema is QHASM.
monitored-resource
Specifies the name of the monitored resource.
monitored-resource-library
Specifies the library for the monitored resource. For resources that do not reside in a library, this parameter is ignored.
monitored-resource-type
Specifies the type of the monitored resource.
The following values are allowed for monitored-resource-type:
*ASPDEV
Auxiliary storage pool device monitored resources.
*AUTL
Authorization list monitored resources.
*CLS
Class monitored resources.
*ENVVAR
Environment variable monitored resources.
*ETHLIN
Ethernet line description monitored resources.
*JOBD
Job description monitored resources.
*NETA
Network attribute monitored resources.
*NWSCFG
Network server configuration monitored resources.
*NWSD
Network server description monitored resources.
*NWSHDEV
Network server host adapter device description monitored resources.
*NWSSTG
Network server storage monitored resources.
*OPTDEV
Optical device description monitored resources.
*PRTDEV
Printer device description monitored resources.
*SBSD
Subsystem description monitored resources.
*SYSVAL
System value monitored resources.
*TAPDEV
Tape device description monitored resources.
*TCPA
TCP/IP attribute monitored resources.
*USRPRF
User profile monitored resources.
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.
Result Table
The result of the function is a table containing a row for each node 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. |
MONITORED_RESOURCE | VARCHAR(256) | The name of the resource being monitored. |
RESOURCE_TYPE | VARCHAR(10) | The type of the resource being monitored. |
LIBRARY | VARCHAR(10) | The name of the library that contains the resource. Contains the null value if the monitored resource is not an object in a library. |
GLOBAL_STATUS | VARCHAR(15) | The status of the resource across the active cluster administrative domain. *ADDED The monitored resource entry and its attributes have been added to the monitored resource directory in the cluster administrative domain but has not yet been synchronized because the domain is not active. *CONSISTENT The values for all the resource's attributes monitored by the system are the same within the active cluster administrative domain. *ENDED The cluster administrative domain has been ended and synchronization stopped so it is not known whether the resource is consistent or not. *FAILED The resource is no longer being monitored by the cluster administrative domain and the monitored resource entry should be removed. *INCONSISTENT One or more of the monitored attributes for a monitored resource entry are not set to the value known by the cluster administrative domain on one or more nodes in the domain. *PENDING The values of the monitored attributes are in the process of being synchronized across the cluster administrative domain. *UNKNOWN The status for the monitored resource entry could not be determined. |
NODE | VARCHAR(8) | The name of the node in the administrative domain. |
LOCAL_STATUS | VARCHAR(15) | The status of the resource on the local node. CURRENT There are no pending updates for the monitored resource on this node. DELETE FAIL The resource on has been deleted on a node in the cluster and the administrator needs to complete the process. DELETE PENDING The monitored resource has been deleted on a node in the cluster and the process has not fully completed for all nodes. MOVE FAIL The resource has been moved on a node in the cluster and the administrator needs to complete the process. MOVE PENDING The monitored resource has been moved on a node in the cluster and the process has not fully completed for all nodes. RENAME FAIL The resource has been renamed on a node in the cluster and the administrator needs to complete the process. RENAME PENDING The monitored resource has been renamed on a node in the cluster and the process has not fully completed for all nodes. RESTORE FAIL The resource has been restored on a node in the cluster and the administrator needs to complete the process. RESTORE PENDING The monitored resource has been restored on a node in the cluster and the process has not fully completed for all nodes. UPDATE FAIL An update of the resource on this node has failed. UPDATE PENDING There are pending updates for the monitored resource on this node. UNKNOWN The status for the monitored resource entry could not be determined. |
MESSAGE_ID | CHAR(7) | If an error occurred when monitoring or synchronizing this resource, the message identifier of the error is contained in this field. Contains the null value if there is no error. |
MESSAGE_TEXT | VARCHAR(3000) | The message description for the message identifier. Contains the null value if there is no error. |
Examples
Example 1 - MRE Details for a monitored resource
SELECT * FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_DETAILS('MYUSER1', '*USRPRF', 'QSYS'));Example 1 - Sample Output
ADMINISTRATIVE_DOMAIN | CONSISTENT_INFORMATION | RESOURCE | RESOURCE_TYPE | LIBRARY | GLOBA_STATUS | NODE | LOCAL_STATUS | MESSAGE_ID | MESSAGE |
|---|---|---|---|---|---|---|---|---|---|
ADMDMN | YES | MYUSER1 | *USRPRF | QSYS | *CONSISTENT | PROD | CURRENT | ||
ADMDMN | YES | MYUSER1 | *USRPRF | QSYS | *CONSISTENT | DR | CURRENT | ||
ADMDMN | YES | MYUSER1 | *USRPRF | QSYS | *CONSISTENT | BACKUP | CURRENT |
Example 2 - Get the list of inconsistent resources and the reasons the resources are inconsistent
SELECT DETAILS.* FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(GLOBAL_STATUS => '*INCONSISTENT')) LIST,
TABLE(QHASM.ADMIN_DOMAIN_MRE_DETAILS(MONITORED_RESOURCE => LIST.MONITORED_RESOURCE, RESOURCE_TYPE => LIST.RESOURCE_TYPE, LIBRARY => LIST.LIBRARY)) DETAILS
WHERE DETAILS.LOCAL_STATUS != 'CURRENT';Example 2 - Sample Output
ADMINISTRATIVE_DOMAIN | CONSISTENT_INFORMATION | RESOURCE | RESOURCE_TYPE | LIBRARY | GLOBA_STATUS | NODE | LOCAL_STATUS | MESSAGE_ID | MESSAGE |
|---|---|---|---|---|---|---|---|---|---|
ADMDMN | YES | BOB | *USRPRF | QSYS | *INCONSISTENT | DR | UPDATE FAILED | CPF22CE | The UID value 293 is used by another user profile. |
ADMDMN | YES | BOB | *USRPRF | QSYS | *INCONSISTENT | BACKUP | UPDATE FAILED | CPF22CE | The UID value 293 is used by another user profile. |
ADMDMN | YES | MARY | *USRPRF | QSYS | *INCONSISTENT | DR | UPDATE FAILED | CPF22CE | The UID value 529 is used by another user profile. |
In this example, there are two monitored resources that have a status of inconsistent, both are user profiles. User profile Bob is inconsistent on nodes DR and Backup due to the UID value for the user profile conflicting with another profile on nodes DR and Backup. User profile Mary is inconsistent only on node DR due also to the UID value for the user profile conflicting with another profile on node DR.
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 |
42704 | MONITORED RESOURCE ENTRY FOR RESOURCE &1 IN LIBRARY &2 WAS NOT FOUND. THE RESOURCE TYPE IS &3 |
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 |
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.