QHASM.ADMIN_DOMAIN_MRE_LIST table function

Owned by Brian Nordland
Last updated: Sept 26, 2023
5 min read

The ADMIN_DOMAIN_MRE_LIST table function returns information about monitored resource entries 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_LIST (MONITORED_RESOURCE => monitored-resource, RESOURCE_TYPE => monitored-resource-type, LIBRARY => monitored-resource-library, GLOBAL_STATUS => monitored-resource-global-status, ADMINISTRATIVE_DOMAIN => administrative-domain-name)

The schema is QHASM.

monitored-resource

Specifies the name of the monitored resource. The name can be either a fully qualified name or a generic resource name.

The following special values are allowed for monitored-resource:

*ALL

All monitored resources

generic-resource-name

Resources that meet the criteria are selected. A generic resource name is a character string that contains one or more characters followed by an asterisk (*); for example, ABC*. The asterisk substitutes for any valid characters. If an asterisk is not specified with the resource name, the system interprets that the resource name is a complete resource name.

monitored-resource-type

Specifies the type of the monitored resource.

The following values are allowed for monitored-resource-type:

*ALL

All monitored resource types.

*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.

monitored-resource-library

Specifies the library for the monitored resource. For resources that do not reside in a library, this parameter is ignored. The library can be either a fully qualified name or a generic library name.

The following special values are allowed for monitored-resource-library:

*ALL

Monitored resources from all libraries.

generic-library-name

Resources that meet the criteria are selected. A generic library name is a character string that contains one or more characters followed by an asterisk (*); for example, ABC*. The asterisk substitutes for any valid characters. If an asterisk is not specified with the library name, the system interprets that the library name is a library resource name.

monitored-resource-global-status

Specifies the global status a resource must have in order for the resource to be selected.

The following values are allowed for monitored-resource-global-status.

*ALL

All monitored resources.

*ADDED

Monitored resources that have a global status of added.

*CONSISTENT

Monitored resources that have a global status of consistent.

*ENDED

Monitored resources that have a global status of ended.

*FAILED

Monitored resources that have a global status of failed.

*INCONSISTENT

Monitored resources that have a global status of inconsistent.

*PENDING

Monitored resources that have a global status of pending.

administrative-domain-name

Specifies the cluster administrative domain which 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 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.

MONITORED_RESOURCE

VARCHAR(256)

The name of the resource being monitored.

RESOURCE_TYPE

VARCHAR(10)

The type of the resource being monitored.

*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.

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.

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 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.

Examples

Example 1 - Retrieve information about inconsistent monitored resources

SELECT * FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(GLOBAL_STATUS => '*INCONSISTENT'));

Example 1 - Sample Output

ADMINISTRATIVE_DOMAIN

CONSISTENT_INFORMATION

RESOURCE

RESOURCE_TYPE

LIBRARY

GLOBAL_STATUS

ADMINISTRATIVE_DOMAIN

CONSISTENT_INFORMATION

RESOURCE

RESOURCE_TYPE

LIBRARY

GLOBAL_STATUS

ADMDMN

YES

MYUSER

*USRPRF

QSYS

*INCONSISTENT

ADMDMN

YES

PRTDEV1

*PRTDEV

QSYS

*INCONSISTENT

Example 2 - Find the list of user profiles not being monitored by the administrative domain

SELECT USRPRF.OBJNAME AS UNMONITORED_RESOURCE FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS','*USRPRF','*ALLSIMPLE')) USRPRF WHERE NOT EXISTS ( SELECT MONITORED_RESOURCE FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*USRPRF')) MRE WHERE MRE.MONITORED_RESOURCE = USRPRF.OBJNAME);

Example 2 - Sample Output

UNMONITORED_RESOURCE

UNMONITORED_RESOURCE

Bob

Mary

QSECOFR

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

 

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.