/
QHASM.SESSION_INFO table function

QHASM.SESSION_INFO table function

The SESSION_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 ASP Session (DSPASPSSN), Display CSM Session (DSPCSMSSN), and Display SVC Session (DSPSVCSSN) commands.

Authorization

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

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

Parameters

QHASM.SESSION_INFO ( SESSION => session-name DEVICE_DOMAIN => device-domain)

The schema is QHASM.

session-name

Specifies the name of the session.

device-domain

Specifies the name of the device domain.

*

The device domain that the current node is in.

name

Specify the name of the device domain.

Result Table

The result of the function is a table containing a row for each independent auxiliary storage pool (IASP) in the session with the format shown in the following table.

Column Name

Data Type

Description

Column Name

Data Type

Description

SESSION_NAME

VARCHAR(10)

The name of the session.

SESSION_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

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

PVS

PVS ASP Session

CLUSTER_RESOURCE_GROUP

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

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

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

VARCHAR(8)

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

TARGET_NODE

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

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.

CSM_CONFIGURATION_DESCRIPTION

VARCHAR(10)

Nullable

The name of the High Availability (HA) configuration description associated with this session.

Contains the null value if the STORAGE_TYPE is not CSM.

SESSION_NAME_ON_CSM

VARCHAR(250)

Nullable

The name of the session on the Copy Services Manager storage controller that is managed by the PowerHA CSM session.

Contains the null value if the STORAGE_TYPE is not CSM.

DATA_EXPOSURE

BIGINT

Nullable

For CSM/SVC Global Mirror the recovery point objective or data exposure represents the period of time (in milliseconds) after data is written to the storage at the source site until that same data is received by the storage at the target site. This field is in milliseconds.

Data exposure is influenced by factors including:

  • Physical distance between the storage systems

  • Latency between the storage systems

  • Available bandwidth of the data link

  • Input/Output (I/O) load on the storage systems

  • Storage system configuration

Contains the null value if the session is not an CSM/SVC Global Mirror session or if the data exposure is unknown.

A value of -2 indicates time configuration error on the storage systems.

TRANSMISSION_DELIVERY

VARCHAR(6)

Nullable

The transmission delivery method of an ASP session. This attribute only applies to Geographic Mirroring sessions.

*ASYNC

The mirroring uses asynchronous communication between the production and mirror copy systems. This delivery method is best for high latency environments. This delivery method will consume more system resources on the production copy node than *SYNC delivery.

*SYNC

The mirroring uses synchronous communication between the production and mirror copy systems. This delivery method is best for low latency environments.

Contains the null value if the session is not a geographic mirroring session.

TRANSMISSION_COMPRESSION

This column was introduced in 7.4 HA 4.7.2 and 7.5 HA 5.1.2. Systems with a lower potential PowerHA version will not display this column. Clusters running at a lower current PowerHA version will have the null value for this column.

VARCHAR(10)

Nullable

The compression setting of Geographic Mirroring data when sent between systems. This attribute only applies to Geographic Mirroring sessions.

*NONE

Data is not compressed.

*RESYNC

Data is compressed during a full or partial synchronization.

When the copy status of the session is resuming, the data is compressed. After the copy status of the session becomes active, the data is not compressed.

Contains the null value if the session is not a geographic mirroring session or the compression setting is unknown.

SYNCHRONIZATION_PRIORITY

VARCHAR(7)

Nullable

The synchronization priority for a Geographic Mirroring session. Possible priorities are:

*LOW

Low priority. This uses the fewest resources, but synchronization takes longer to complete.

*MEDIUM

Medium priority. This provides a balance between resource usage and the amount of time required to complete synchronization.

*HIGH

High priority. This completes synchronization as quickly as possible, but consumes the most resources.

Contains the null value if the session is not a geographic mirroring session.

SUSPEND_TIMEOUT

INTEGER

Nullable

The number of seconds the production copy waits for a communications response from the mirror copy before suspending transmission of data from the production copy to the mirror copy.

Contains the null value if the session is not a geographic mirroring session.

FLASHCOPY_TYPE

VARCHAR(7)

Nullable

The type of the FlashCopy. Possible FlashCopy types are:

*COPY

All sectors are copied from the FlashCopy source to the FlashCopy target.

*NOCOPY

Only those sectors that are different between the FlashCopy source and FlashCopy target exist in the FlashCopy target. References to the target for other sectors retrieve those sectors from the the FlashCopy source.

Contains the null value if the session is not a FlashCopy session

PERSISTENT_RELATIONSHIP

VARCHAR(4)

Nullable

The persistent attribute of a FlashCopy session. Possible persistent attribute values are:

*YES

The relationship between the FlashCopy source and its target is persistent. The *INCR and *REVERSE operations of the change session command are supported. The FlashCopy target can be updated with the changes since the last point-in-time copy (*INCR) or the FlashCopy source can be returned to the state it had at the time of the most recent point-in-time copy (*REVERSE).

*NO

The relationship between the FlashCopy source and its target is not persistent. The *INCR and *REVERSE operations of the change session command are not supported.

Contains the null value if the session is not a FlashCopy session

SECTORS_COPIED

BIGINT

Nullable

For an ASP FlashCopy session, identifies the number of sectors that have been copied.

Contains the null value for any other session type.

SECTORS_REMAINING

BIGINT

Nullable

For an ASP FlashCopy session, identifies the number of sectors that have not yet been copied.

Contains the null value for any other session type.

VOLUME_GROUP_NAME

This column was introduced in 7.4 HA 4.11.2 and 7.5 HA 5.5.2.

VARCHAR(64)

Nullable

The name of the volume group used for a SVC policy-based replication or Power Virtual Server (PVS) Global Replication Services (GRS) replication.

Contains the null value for any other session type.

CONSISTENCY_GROUP_NAME

VARCHAR(64)

Nullable

The name of the consistency group used to control the relationship for a SVC remote copy session.

Contains the null value for any other session type.

REVERSE_CONSISTENCY_GROUP_NAME

VARCHAR(64)

Nullable

The name of the reverse consistency group used to control the relationship.

Contains the null value if the STORAGE_TYPE is not SVC and the SESSION_TYPE is not *FLASHCOPY or if the FlashCopy does not have a reverse consistency group.

SOURCE_STORAGE_CLUSTER_NAME

VARCHAR(64)

The name of the storage unit cluster for the source storage unit.

TARGET_STORAGE_CLUSTER_NAME

VARCHAR(64)

The name of the storage unit cluster for the target storage unit.

INCREMENTAL_FLASHCOPY

VARCHAR(4)

Nullable

Specifies if the FlashCopy is an incremental FlashCopy. Possible values are:

*YES

The FlashCopy is an incremental FlashCopy

*NO

The FlashCopy is not an incremental FlashCopy

This value is only valid for SVC FlashCopy sessions and will be null for all other session types or when the value is unknown.

COPY_RATE

INTEGER

Nullable

Specifies the rate at which data is copied from the source virtual disks (VDisks) of a FlashCopy to the target Vdisks.

This value is only valid for SVC FlashCopy sessions and will be null for all other session types or when the value is unknown.

CLEANING_RATE

INTEGER

Nullable

Specifies the rate at which the cleaning process is done on the FlashCopy mapping. The cleaning process copies data from the target virtual disk (VDisk) of a mapping to the target VDisks of other mappings that are dependent on this data.

This value is only valid for SVC FlashCopy sessions and will be null for all other session types or when the value is unknown.

GRAIN_SIZE

INTEGER

Nullable

Specifies the FlashCopy grain size in kilobytes (KB). More information on FlashCopy grains and grain size can be found in the SAN Volume Controller Information Center.

This value is only valid for SVC FlashCopy sessions and will be null for all other session types or when the value is unknown.

CYCLING_MODE

VARCHAR(8)

Nullable

Indicates the cycling mode of the replication. Possible values are:

NONE

The cycling mode is none. This value will appear for Metro Mirror sessions and Global Mirror without change volumes sessions.

MULTIPLE

The cycling mode is multiple. This value will appear for Global Mirror with change volumes sessions

Contains the null value if the session is not an SVC Metro Mirror or Global Mirror session or if there is not a freeze time.

FREEZE_TIME

TIMESTAMP(0)

Nullable

For an SVC Global Mirror with change volumes session, represents the freeze time of the consistency group.

For an SVC FlashCopy session represents the point in time of the FlashCopy operation.

For a PVS Global Mirror session, represents the freeze time of the volume group.

Contains the null value if the session is not a PVS Global Mirror session, SVC Global Mirror session with a CYCLING_MODE of MULTIPLE or not an SVC FlashCopy session.

ASP_DEVICE

VARCHAR(10)

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

SOURCE_ASP_STATE

VARCHAR(10)

Nullable

The device configuration status of an ASP.

ACTIVE

The status of the ASP is active.

AVAILABLE

The status of the ASP is available.

FAILED

The status of the ASP is failed.

VARIED OFF

The status of the ASP is varyoff.

VARIED ON

The status of the ASP is varyon.

Contains the null value if the ASP vary state is unknown.

SOURCE_COPY_DESCRIPTION

VARCHAR(10)

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

SOURCE_TRACKING_SPACE_USED

DECIMAL(7,3)

Nullable

The percentage of the reserved tracking space that has been used for tra