QHASM.HYPERSWAP_STATUS_INFO table function

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

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

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
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.

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
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

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
device.

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
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

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
device.

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
The name of the source storage identifier that is the primary in the HyperSwap Relationship.

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 Output

ASP_DEVICE

FIRST_STORAGE_IDENTIFIER

FIRST_VOLUME

SECOND_STORAGE_IDENTIFIER

SECOND_VOLUME

COPY_STATUS

ASP_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

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.