...

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. DEVD A device description. The DEVICE_TYPE column indicates the type of device description. IPA IP Address.
DEVICE_TYPE	VARCHAR(10) Nullable	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.

Contains the null value if there is no device type or if the OBJECT_TYPE is not of type *DEVD.

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

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

Preserves

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

Same

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:

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
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 RESOURCE GROUP &1 NOT AVAILABLE
58004	AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION

Versions Compared

Old Version 1

New Version Current

Key

Examples

Example 1 - Get the list of configuration objects in a device CRG

Example 1 - Sample Output

Example 2 - Get the list of IASP devices not in a cluster resource group

Example 2 - Sample Output

SQLSTATE Values

Page Comparison

Versions Compared

Old Version 1

New Version Current

Key

Examples

Example 1 - Get the list of configuration objects in a device CRG

Example 1 - Sample Output

Example 2 - Get the list of IASP devices not in a cluster resource group

Example 2 - Sample Output

SQLSTATE Values