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.

Examples

Example 1 - Retrieve information about inconsistent monitored resources

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

Example 1 - Sample Output

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

SQLSTATE Values

Errors and warnings returned by this function are returned as SQL state values. Possible SQLSTATE values returned by this view are: