QHASM.HYPERSWAP_STATUS_LIST View

Owned by Shengli Li
Last updated: Jun 21, 2024 by Brian Nordland
4 min read

The QHASM.HYPERSWAP_STATUS_LIST view contains HyperSwap information about the list of nodes and devices in a cluster.

The values returned for the columns in this view contain information represented differently from the panels of the Work with HyperSwap Status (WRKHYSSTS) CL command.

Authorization 

The authorization ID of the statement must include the following privileges:

  • *OBJOPR and *READ authority on QHASM/HYS_LIST.

  • Input/output system configuration (*IOSYSCFG) special authority.

Results Table

The table describes the columns in the view. The system name used here is HYS_LIST. The schema is QHASM.

Column Name

System Column Name

Data Type

Description

Column Name

System Column Name

Data Type

Description

NODE

NODE

VARCHAR(8)

A valid simple name that uniquely identifies a node.

ASP_DEVICE

ASPDEV

VARCHAR(10)

Nullable

The name of the Auxiliary Storage Pool (ASP) group the HyperSwap status is for. Possible values are:

*SYSBAS
HyperSwap status is returned for disk unit pairs in the System ASP (ASP 1) and the User ASPs (ASP numbers 2 through 32).

name
The name of an Independent ASP device description for a primary Independent ASP.

Contains the null value if HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster.

FIRST_STORAGE_IDENTIFIER

STGID1

VARCHAR(20)

Nullable

The unique identifier for the storage device that a logical unit (volume) resides in. Possible values are:

name
The name of the source storage identifier.

Contains the null value if HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster, or HyperSwap is not configured.

FIRST_STORAGE_ACCESSIBLE

STGID1ACS

VARCHAR(3)

Nullable

Whether the storage device is accessible or not. Possible values are:

YES

The storage device is accessible.

NO

The storage device is not accessible.

Contains the null value if HyperSwap is not configured or the HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster, or HyperSwap is not configured.

SECOND_STORAGE_IDENTIFIER

STGID2

VARCHAR(20)

Nullable

The unique identifier for the storage device that a logical unit (volume) resides in. Possible values are:

name
The name of the source storage identifier.

Contains the null value if HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster, or HyperSwap is not configured.

SECOND_STORAGE_ACCESSIBLE

STGID2ACS

VARCHAR(3)

Nullable

Whether the storage device is accessible or not. Possible values are:

YES

The storage device is accessible.

NO

The storage device is not accessible.

Contains the null value if HyperSwap is not configured or the HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster, or HyperSwap is not configured.

STORAGE_AFFINITY

STGAFNTY

VARCHAR(3)

Nullable

Whether the affinity of the storage device is used or not. Possible values are:

YES

The affinity of the storage device is used.

NO

The affinity of the storage device is not used.

NOT DEFINED

The affinity of the storage device is not defined.

Contains the null value if HyperSwap is not configured or the HyperSwap status is not known for the device on this node, or HyperSwap is not configured.

PRIMARY_STORAGE_IDENTIFIER

PRISTGID

VARCHAR(20)

Nullable

The unique identifier for the storage device that is the primary storage device in the HyperSwap relationship. Possible values are:

name
The name of the source storage identifier.

Contains the null value if the HyperSwap status is ‘TWO PRIMARY’ or if the HyperSwap status is not known for the device on this node. This could be due to a failure communicating with the node, or because the node is not active in the cluster, or HyperSwap is not configured.

COPY_STATUS

CPYSTS

VARCHAR(20)

Nullable

A summary of the status of the HyperSwap
relationships for the device on the node. Possible
values are:

ACTIVE-SYNCHRONIZED

All of the HyperSwap relationships for the device are active and all of the copies of the volumes are synchronized.

SUSPENDED

One or more of the HyperSwap relationships for the device are currently suspended.

RESUMING

HyperSwap is currently resuming.

TWO PRIMARY

One or more of the HyperSwap relationships for the device consists of two primary volumes.

STORAGE FAILURE

There are problems when communicating with the storage devices.

NOT CONFIGURED

The HyperSwap relationships are not configured on this node for the device.

INVALID

The configuration of HyperSwap relationships on this node for the device is not valid.

Contains the null value if HyperSwap status is not known for the device on this node.

Examples

Example 1 - Get all the HyperSwap relationships

The following example gets the HyperSwap relationships for a list of nodes and devices.

SELECT NODE, ASP_DEVICE, COPY_STATUS FROM QHASM.HYPERSWAP_STATUS_LIST;

Example 1 - Sample Output

NODE

ASP_DEVICE

COPY_STATUS

NODE

ASP_DEVICE

COPY_STATUS

NODEA

DEVICE1

ACTIVE-SYNCHRONIZED

NODEA

DEVICE2

 

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

42501

Not authorized to object HYS_LIST in QHASM type *FILE

42502

CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY

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

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.