The CRG_CONFIGURATION_OBJECTS table function returns details about configuration objects managed by a cluster resource group.
Authorization
The authorization ID of the statement must include the following privileges:
Authorization as required by PowerHA product functionality.
Input/output system configuration (*IOSYSCFG) special authority.
Allows access to the object attributes and use of the object(*USE) to the CRG object.
Parameters
QHASM.CRG_CONFIGURATION_OBJECTS ( CLUSTER_RESOURCE_GROUP => cluster-resource-group-name )
The schema is QHASM.
cluster-resource-group-name
Specifies the name of the cluster resource group.
Result Table
The result of the function is a table containing a row for each configuration object in the CRG with the format shown in the following table. This is only valid for device CRGs. An empty table is returned for other CRG types.
Column Name | Data Type | Description |
|---|---|---|
CLUSTER_RESOURCE_GROUP | VARCHAR(10) | The name of the cluster resource group |
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. |
CONFIGURATION_OBJECT | VARCHAR(10) | The configuration object name for a device entry. An example of this would be the auxiliary storage pool device description name. |
OBJECT_TYPE | VARCHAR(10) | The type of configuration object specified with configuration object name. |
DEVICE_TYPE | VARCHAR(10) | The type of device description. ASP An auxiliary storage pool device. ASYNC An asynchronous communications device. BSC A binary synchronous communications device. CRP A cryptographic device. DDI A distributed data interface communication line. DSP A display device. ELAN An Ethernet communication line. FAX A facsimile communication line. FNC An ICF finance device. GUEST A network server device for a guest operating system (Linux) running in a logical partition. ISCSI A network server device that uses an iSCSI connection. IXSVR An integrated network server device. LWS A local workstation controller. NET A network device. NWSH A network server host adapter device. OPT An optical device. PPP A point-to-point protocol communication line. PRT A printer device. RTL A retail device. RWS A remote workstation controller. SDLC A synchronous data link control communication line. TAP A tape device. TDLC A twinaxial data link control communication line. TRLAN A token-ring line. WLS A wireless local area network communication line. X25 An X.25 communication line. |
DEVICE_SUBTYPE | VARCHAR(10) Nullable | UNKNOWN The subtype cannot be determined because hardware configuration is not complete. UDFS UDFS independent auxiliary storage pool. SECONDARY Secondary independent auxiliary storage pool. PRIMARY Primary independent auxiliary storage pool. *WIN32 Windows x86-32 bit operating system. *WIN64 Windows x86-64 bit operating system. *LINUX32 Linux x86-32 bit operating system. *LINUX64 Linux x86-64 bit operating system. *LINUXPPC Linux on POWER operating system. *AIXPPC AIX on POWER operating system. *OPSYS IBM i operating system. *ESX VMware ESX server. *ESXE VMware ESX embedded server. Contains the null value if the device type does not have a subtype. |
VARY_ONLINE | VARCHAR(10) | Indicates whether the configuration object should be varied on and the server takeover IP address should be started when the device is switched from one node to another. *OFFLINE Remains varied off and leaves the server takeover IP address inactive *CURRENT Preserves the VARY status of the configuration object and the status of the server takeover IP address. If the configuration object was online prior to the switchover or failover, the configuration object will vary on after the switchover of failover completes and will start the server takeover IP address. If the configuration object was offline prior to the switchover or failover, the configuration object will not vary on after the switchover or failover completes and will not start the server takeover IP address. *ONLINE Is varied on and starts the server takeover IP address. *PRIMARY Same as the associated primary auxiliary storage pool |
SERVER_TAKEOVER_IP_ADDRESS | VARCHAR(45)Nullable | This is a takeover IP address for servers associated with the relational database name in the device description for an auxiliary storage pool. The address may be an IPv4 address or IPv6 address. Contains the null value if no server takeover IP address is defined. |
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 DOES NOT EXIST |
42704 | CLUSTER RESOURCE GROUP &1 DOES NOT EXIST |
55019 | THIS REQUEST IS NOT VALID FOR CLUSTER RESOURCE GROUP &1. THE REQUEST IS VALID ONLY FOR A DEVICE CLUSTER RESOURCE GROUP |
560CR | NO VALID LICENSE FOR IBM POWERHA FOR I FOUND |
57012 | CLUSTER RESOURCE SERVICES NOT ACTIVE OR NOT RESPONDING |
57012 | INFORMATION FOR CLUSTER RESOURCE GROUP &1 NOT AVAILABLE |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |