QHASM.HYPERSWAP_STATUS_INFO table function
- Shengli Li
- Brian Nordland
The HYPERSWAP_STATUS_INFO table function returns details about a session.
The values returned for the columns in this view contain information represented differently from the panels of the Display HyperSwap Status (DSPHYSSTS) command.
Authorization
The authorization ID of the statement must include the following privileges:
Input/output system configuration (*IOSYSCFG) special authority.
Parameters
QHASM.HYPERSWAP_STATUS_INFO ( ASP_DEVICE => ASP-device-name, NODE => node-name)The schema is QHASM.
ASP_DEVICE
Specifies the name of the ASP device.
*ALL
The HyperSwap status information for all ASP devices on the node is returned.
NODE
Specifies the name of the node.
*
The HyperSwap status information for the ASP device on the local node is returned.
Result Table
The result of the function is a table containing a row for each disk unit in the ASP device on the node shown in the following table.
Column Name | Data Type | Description |
|---|---|---|
ASP_DEVICE | VARCHAR(10) | The name of the Auxiliary Storage Pool (ASP) group the HyperSwap status is for. Possible values are: *SYSBAS name |
UNIT | INTEGER | The disk unit identifier. |
STORAGE_TYPE | VARCHAR(3) | The type of storage for the session. Possible values are: ASP ASP Session (DS8000 or Geographic Mirroring) CSM CSM ASP Session SVC SVC ASP Session |
FIRST_STORAGE_IDENTIFIER | VARCHAR(20) Nullable | The unique identifier for the storage device that a logical unit (volume) resides in. Possible values are: 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, or HyperSwap is not configured. |
FIRST_STORAGE_ACCESSIBLE | 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 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_VOLUME | VARCHAR(4) Nullable | The unique volume identifier for the logical unit within the storage 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_IDENTIFIER | VARCHAR(20) Nullable | The unique identifier for the storage device that a logical unit (volume) resides in. Possible values are: 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, or HyperSwap is not configured. |
SECOND_STORAGE_ACCESSIBLE | 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 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_VOLUME | VARCHAR(4) Nullable | The unique volume identifier for the logical unit within the storage 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. |
STORAGE_AFFINITY | 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 status is not known for the device on this node. |
PRIMARY_STORAGE_IDENTIFIER | VARCHAR(20) Nullable | The unique identifier for the storage device that is the primary storage device in the HyperSwap relationship. Possible values are: name 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 | VARCHAR(20) Nullable | The status of the HyperSwap relationship as reported by the IBM System Storage Device. Possible values are: ACTIVE-SYNCHRONIZED The HyperSwap relationship for the volume is active and all of the copies of the volumes are synchronized. SUSPENDED The HyperSwap relationship for the volume is currently suspended. RESUMING The HyperSwap relationship for the volume is currently resuming. TWO PRIMARY The HyperSwap relationship for the volume 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 volume. Contains the null value if HyperSwap status is not known for the volume on this node. |
COPY_PROGRESS | INTEGER Nullable | The percent of synchronization complete between source and target. If the COPY_STATUS is RESUMING, it is the synchronization progress. If the COPY_STATUS is ACTIVE-SYNCHRONIZED, it is 100. Otherwise, it is 0. Contains the null value if HyperSwap status is not known for the volume on this node. |
Examples
Example 1 - Get the HyperSwap status for ASP devices on a node
The following example returns the session name, the type of session, a list of IASP devices in the session, and the replication state for each IASP device for a session named MYSSN.
SELECT UNIT, FIRST_STORAGE_IDENTIFIER, FIRST_VOLUME,
SECOND_STORAGE_IDENTIFIER, SECOND_VOLUME, COPY_STATUS
FROM TABLE(QHASM.HYPERSWAP_STATUS_INFO(ASP_DEVICE => 'DEVICE1', NODE => 'NODEA'));
Example 1 - Sample OutputASP_DEVICE | FIRST_STORAGE_IDENTIFIER | FIRST_VOLUME | SECOND_STORAGE_IDENTIFIER | SECOND_VOLUME | COPY_STATUS |
|---|---|---|---|---|---|
DEVICE1 | IBM.2107-11ABC11 | 0101 | IBM.2107-22XYZ22 | 0201 | ACTIVE-SYNCHRONIZED |
DEVICE1 | IBM.2107-11ABC11 | 0102 | IBM.2107-22XYZ22 | 0202 | ACTIVE-SYNCHRONIZED |
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 | DEVICE DOMAIN &1 DOES NOT EXIST |
42704 | SESSION &1 DOES NOT EXIST |
42704 | NODE &1 DOES NOT EXIST |
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 DEVICE DOMAIN &1 NOT AVAILABLE |
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.