Versions Compared

Key

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

The QHASM.Session_List view contains information about the list of PowerHA sessions in a cluster.

...

  • *OBJOPR and *READ authority on QHASM/SSN_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.

...

Column Name

System Column Name

Data Type

Description

SESSION_NAME

SSN

VARCHAR(10)

The name of the session.

SESSION_TYPE

TYPE

VARCHAR(10)

The type of session. Possible session types are:

*FLASHCOPY

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. Possible values are:

ASP

ASP Session (DS8000 or Geographic Mirroring)

CSM

CSM ASP Session

SVC

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

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

TARGET_SITE

TGTSITE

VARCHAR(8)

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.

Contains the null value if the session type is *FLASHCOPY and the FlashCopy is a no target FlashCopy.

SWITCHOVER_REVERSE_REPLICATE

SWTRVSREPL

VARCHAR(4)

Nullable

Switchover reverse replication indicates whether the replication restarts after a switchover in the reverse direction or becomes detached. Possible values are:

*YES

Replication is reversed after a switchover.

*NO

Replication is not reversed after a switchover. The session becomes detached after a switchover

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

ASP_DEVICE

ASPDEV

VARCHAR(10)

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

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.

Examples

Example 1 - Get the list of sessions and type

The following example gets a list of sessions in the device domain for the local node.

Code Block
languagesql
SELECT DISTINCT SESSION_NAME, SESSION_TYPE
  FROM QHASM.SESSION_LIST;
Panel
panelIconIdatlassian-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_NAME

SESSION_TYPE

SVCGLOBAL

*GLOBALMIR

FLASH

*FLASHCOPY

SQLSTATE Values

Errors and warnings returned by this function are returned as SQL state values. Possible SQLSTATE values returned by this view are:

...