...
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) Nullable | The type of device description. ASP An auxiliary storage pool device. Contains the null value if there is no device type. |
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. Contains the null value if the device type does not have a subtype. |
VARY_ONLINE | VARCHAR(10) | Indicates what configuration action to take when the cluster resource group is switched over or failed over to a backup node. Switchover and failover completion may be delayed if the varyon of devices takes a long time. *OFFLINE Remains varied off and leaves the server takeover IP address inactive *CURRENT For a configuration object of type *DEVD, 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. For a configuration object of type *IPA, the IP address is also started when the cluster resource group is started, and ended when the cluster resource group is ended. *PRIMARY For a configuration object of type *DEVD, 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, or the IP address for a configuration object with type *IPA. The address may be an IPv4 address or IPv6 address. Contains the null value if no server takeover IP address is defined. |
Examples
Example 1 - Get the list of configuration objects in a device CRG
The following example gets the list of configuration objects in the CRG named MYCRG.
| Code Block |
|---|
SELECT CONFIGURATION_OBJECT, VARY_ONLINE, SERVER_TAKEOVER_IP_ADDRESS
FROM TABLE(QHASM.CRG_CONFIGURATION_OBJECTS(CLUSTER_RESOURCE_GROUP => 'MYCRG')); |
Example 1 - Sample Output
CONFIGURATION_OBJECT | VARY_ONLINE | SERVER_TAKEOVER_IP_ADDRESS |
|---|---|---|
PRODIASP | *ONLINE | 192.0.2.10 |
ARCHIVEASP | *PRIMARY | - |
Example 2 - Get the list of IASP devices not in a cluster resource group
This example finds the list of IASP devices on the local system that are not in a cluster resource group.
| Code Block |
|---|
SELECT ASPINFO.DEVICE_DESCRIPTION_NAME FROM
QSYS2.ASP_INFO ASPINFO
WHERE NOT EXISTS (
SELECT CONFIGURATION_OBJECT
FROM (SELECT CLUSTER_RESOURCE_GROUP FROM QHASM.CRG_LIST WHERE CRG_TYPE = '*DEV') AS CRGLIST,
TABLE(QHASM.CRG_CONFIGURATION_OBJECTS(CLUSTER_RESOURCE_GROUP => CRGLIST.CLUSTER_RESOURCE_GROUP)) CFGOBJ
WHERE ASPINFO.DEVICE_DESCRIPTION_NAME = CFGOBJ.CONFIGURATION_OBJECT); |
Example 2 - Sample Output
DEVICE_DESCRIPTION_NAME |
|---|
MYIASP |
SQLSTATE Values
Errors and warnings returned by this function are returned as SQL state values. Possible SQLSTATE values returned by this view are:
...