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 |
|---|---|---|---|
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 name 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: NOT CONFIGURED name 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_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. |
SECOND_STORAGE_IDENTIFIER | STGID2 | VARCHAR(20) Nullable | The unique identifier for the storage device that a logical unit (volume) resides in. Possible values are: NOT CONFIGURED name 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. |
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. |
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. |
COPY_STATUS | CPYSTS | VARCHAR(20) Nullable | A summary of the status of the HyperSwap 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 |
|---|---|---|
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 |
|---|---|
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 |