Versions Compared

Version Old Version 1 New Version 2
Changes made by

Shengli Li

Shengli Li

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The QHASM.SessionHYPERSWAP_STATUS_List LIST view contains HyperSwap information about the list of PowerHA sessions 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 ASP Copy Descriptions (WRKASPCPYDHyperSwap Status (WRKHYSSTS) CL command.

Authorization 

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

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

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

Info

Note: At least one node in a device domain must be active for sessions in the device domain to be returned.

Results Table

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

Column Name

System Column Name

Data Type

Description

SESSION_NAME

NODE

SSN

NODE

VARCHAR(

10

8)

The name of the session

A valid simple name that uniquely identifies a node.

SESSION

ASP_

TYPE

DEVICE

TYPE

ASPDEV

VARCHAR(10)

Nullable

The

type of session. Possible session types

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

*

FLASHCOPY

SYSBAS

The session is a FlashCopy session.

*GEOMIR

The session is a Geographic Mirroring session.

*GLOBALMIR

The session is a Global Mirror session.

*METROMIR

The session is a Metro Mirror session.

STORAGE_TYPE

STGTYPE

VARCHAR(3)

The type of storage used in the session

CLUSTER_RESOURCE_GROUP

CRG

VARCHAR(10)

Nullable

The name of the cluster resource group (CRG) associated with this session.

Contains the null value if the session type is *FLASHCOPY.

SOURCE_SITE

SRCSITE

VARCHAR(8)

Nullable

The name of the cluster resource group (CRG) site name that the source of this session is associated with

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:

ASP

ASP Session (DS8000 or Geographic Mirroring)

CSM

CSM ASP Session

SVC

SVC ASP Session

NOT CONFIGURED
The disk unit is not configured for HyperSwap.

name
The name of the source storage identifier.

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

the session type is *FLASHCOPY.

TARGET_SITE

TGTSITE

HyperSwap status is not known for the device on this node.

SECOND_STORAGE_IDENTIFIER

STGID2

VARCHAR(

8

20)

Nullable

The

name of the cluster resource group (CRG) site name that the target of this session is associated with.

Contains the null value if the session type is *FLASHCOPY.

SOURCE_NODE

SRCNODE

VARCHAR(8)

The name of the cluster node that is attached to the source copy of the ASP.

TARGET_NODE

TGTNODE

VARCHAR(8)

Nullable

The name of the cluster node that is attached to the target copy of the ASP

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

NOT CONFIGURED
The disk unit is not configured for HyperSwap.

name
The name of the source storage identifier.

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

the session type is *FLASHCOPY and the FlashCopy is a no target FlashCopy.

SWITCHOVER_REVERSE_REPLICATE

SWTRVSREPL

VARCHAR(4

HyperSwap status is not known for the device on this node.

STORAGE_AFFINITY

STGAFNTY

VARCHAR(3)

Nullable

Switchover reverse replication indicates whether the replication restarts after a switchover in the reverse direction or becomes detached

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

*

YES

Replication is reversed after a switchover

The affinity of the storage device is used.

*

NO

Replication

The affinity of the storage device is not

reversed after a switchover. The session becomes detached after a switchover

used.

Contains the null value if

the session type is *FLASHCOPY.

ASP_DEVICE

ASPDEV

HyperSwap status is not known for the device on this node.

COPY_STATUS

CPYSTS

VARCHAR(

10

SOURCE_COPY_DESCRIPTION

SRCCPY

VARCHAR(10)

The name of an ASP copy description for the ASP device that is currently the source copy.

TARGET_COPY_DESCRIPTION

TGTCPY

VARCHAR(10)

The name of an ASP copy description for the ASP device that is currently the target copy.

DEVICE_DOMAIN

DEVDMN

VARCHAR(10)

The name of the device domain the session is in

20)

The name of the Auxiliary Storage Pool (ASP) device description.

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 sessions in the device domain for the local nodenodes and devices.

panelIconId
Code Block
languagesql
SELECT DISTINCTNODE, SESSIONASP_NAMEDEVICE, SESSIONCOPY_TYPESTATUS
  FROM QHASM.SESSIONHYPERSWAP_STATUS_LIST;
Panel
atlassian-light_bulb_on
panelIcon:light_bulb_on:
panelIconText:light_bulb_on:
bgColor#E3FCEF
Tip: This SQL service returns one row per IASP device in a session. This example uses the DISTINCT keyword to ensure only one entry per session is returned even in complex environments with multiple IASP devices.
Example 1 - Sample Output
SESSION
NODE
ASP_
NAME
DEVICE
SESSION
COPY_
TYPE
STATUS
NODEA
SVCGLOBAL
*GLOBALMIR
FLASH
*FLASHCOPY
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 
 SSN
HYS_LIST in QHASM type *FILE
42502
CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY
42704
CLUSTER 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
58004
AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION