Obtain information about monitored resource attributes from MREs in the admin domain.

The ADMIN_DOMAIN_MRE_ATTRIBUTES table function returns information about the monitored resource attributes of a monitored resource 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_ATTRIBUTES (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 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

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) Nullable	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

SELECT * FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_ATTRIBUTES(MONITORED_RESOURCE => 'MYUSER1',
                                         RESOURCE_TYPE => '*USRPRF',
                                         LIBRARY => 'QSYS'));

Example 1 - Sample Output

ADMINISTRATIVE_DOMAIN	RESOURCE	RESOURCE_TYPE	LIBRARY	ATTRIBUTE	GLOBAL_STATUS	GLOBA_VALUE

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

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

IBM Partnership

QHASM.ADMIN_DOMAIN_MRE_ATTRIBUTES table function