...
The result of the function is a table containing a row for each attribute with the format shown in the following table. Compound attributes, such as object authority, have multiple rows. For example, one row for each authority entry.
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. |
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. |
ATTRIBUTE | VARCHAR(256) | Each resource type has different attributes. Refer to the help for the ADDCADMRE command for the list of attributes for each type of resource. |
ATTRIBUTE_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. |
GLOBAL_VALUE | VARCHAR(8000)Nullable | The value or values of the attribute that is being synchronized across all nodes in the administrative domain. Contains the null value if there are no retrievable values for the attribute. For example, a user profile password contains a NULL value. |
Examples
Example 1 - Retrieve the attributes for a user profile named MYUSER1
| Code Block |
|---|
SELECT * FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_ATTRIBUTES(MONITORED_RESOURCE => 'MYUSER1', RESOURCE_TYPE => '*USRPRF', LIBRARY => 'QSYS','*USRPRF')); |
Example 1 - Sample Output
ADMINISTRATIVE_DOMAIN | RESOURCE | RESOURCE_TYPE | LIBRARY | ATTRIBUTE | GLOBAL_STATUS | GLOBA_VALUE |
|---|---|---|---|---|---|---|
ADMDMN | MYUSER1 | *USRPRF | QSYS | OBJAUTE | *CONSISTENT | *PUBLIC (*EXCLUDE) |
ADMDMN | MYUSER1 | *USRPRF | QSYS | OBJAUTE | *CONSISTENT | MYUSER1 (*OBJOPR *OBJMGT *READ *ADD *UPD *DLT *EXECUTE) |
ADMDMN | MYUSER1 | *USRPRF | QSYS | MAXSTGLRG | *CONSISTENT | *NOMAX |
ADMDMN | MYUSER1 | *USRPRF | QSYS | OWNER | *CONSISTENT | *USRPRF |
... | ... | ... | ... | ... | ... | ... |
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 |