QHASM.SESSION_INFO table function

Owned by Brian Nordland
Last updated: Mar 20, 2024 by Shengli Li
15 min read

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

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.

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.

Contains the null value if the session is not an 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)

The percentage of the reserved tracking space that has been used for tracking changes on the production copy. If 100% of the reserved tracking space has been used, changes to the data stop being tracked and a full synchronization will be required.

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

TARGET_COPY_DESCRIPTION

VARCHAR(10)

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

TARGET_TRACKING_SPACE_USED

DECIMAL(7,3)

The percentage of the reserved tracking space that has been used for tracking changes on the mirror copy. If 100% of the reserved tracking space has been used, changes to the data stop being tracked and a full synchronization will be required.

COPY_STATUS

VARCHAR(15)

Nullable

The copy status field indicates the current replication status between the source and target. Possible values are:

ACTIVE

Active. The target ASP is current with the source ASP and replication is active.

INVALID

Invalid. The state of the replication is currently not valid.

NOT CONFIGURED

Not configured. Replication between the source and target is not configured.

DETACHED

Detached. The replication status is detached. Replication is not active and the target copy of the "ASP may become available for read and write operations.

RESUME PENDING

Resume pending. Synchronization has been requested, but is not yet occurring for this session. This can occur if the Resume has been requested, but the Production Copy is varied off, for example.

RESUMING

Resuming. The replication status is resuming. The target copy of the ASP is not synchronized with its production copy but synchronization is active.

REVERSED

Reversed. Replication is currently reversed. The replication direction on the storage does not match the direction of the cluster resource group (CRG).

SUSPENDED

Suspended. The replication status is suspended. Replication currently is not active.

Contains the null value if the current replication status is unknown.

COPY_PROGRESS

INTEGER

The percent of synchronization complete between source and target. A value of 100 means source ASP and target ASP are synchronized.

STORAGE_STATE

VARCHAR(32)

Nullable

The state of the session as reported by the storage device.

Possible values for SVC *FLASHCOPY sessions are:

IDLE OR COPIED
The storage unit state is Idle or copied. The source and target volumes act as independent volumes even if a mapping exists between the two. Read and write caching is enabled for both the source and the target volumes.

COPYING

The storage unit state is Copying. Read and write caching is enabled on both the source and the target volumes.

PREPARED

The storage unit state is Prepared. Mapping is ready to begin. The target volume is online, but is not accessible. 

PREPARING

The storage unit state is Preparing. The target volume is online but not accessible.

STOPPED

The storage unit state is Stopped. This could be from an issued command or an I/O error.

STOPPING

The storage unit state is Stopping. This indicates that the mapping is copying data to another mapping.

SUSPENDED

The storage unit state is Suspended. Mapping began but did not complete.

FLASH COPY EMPTY
The flash copy has no data.

 

Possible values for Policy-based-replication sessions are:

RUNNING
The storage unit state is Running. This indicates that the replication is active.

SUSPENDED
The storage unit state is Suspended. This indicates that the replication is stopped.

INDEPENDENT
The storage unit state is Independent. This indicates that the replication is detached.

DISCONNECTED
The storage unit state is Disconnected. This indicates that the network communication for replication is not working.

 

Possible values for SVC Metro Mirror or Global Mirror sessions are:

INCONSISTENT STOPPED
The storage unit state is InconsistentStopped. This indicates that the primary volume is accessible for read/write I/O operations, but the secondary volume is not accessible for either operation.

INCONSISTENT COPYING
The storage unit state is InconsistentCopying. The primary volume is accessible for read/write I/O operations, but the secondary volume is not accessible for either operation. This state is the result of starting replication when the previous state was InconsistentStopped.

CONSISTENT STOPPED
The storage unit state is ConsistentStopped. Indicates that the secondary volume contains a consistent image, but it might be out of date with the primary volume.

CONSISTENT SYNCHRONIZED
The storage unit state is ConsistentSynchronized. Both the primary and secondary volumes are accessible.

CONSISTENT COPYING

The storage unit state is ConsistentCopying. The primary volume is accessible for read/write I/O operations. The secondary volume contains a consistent image that might be out of date with the primary volume.

IDLING

The storage unit state is Idling. This indicates that the relationship has stopped. Both volumes are accessible.

IDLING DISCONNECTED

The storage unit state is IdlingDisconnected. Volumes in this state operate in the primary role and can accept read or write I/O operations.

INCONSISTENT DISCONNECTED

The storage unit state is InconsistentDisconnected. Volumes in this state are operating in the secondary role and cannot accept read or write I/O operations.

CONSISTENT DISCONNECTED

The storage unit state is ConsistentDisconnected. Volumes in this state operate in a secondary role.

EMPTY

The remote copy has no data.

Possible values for CSM Metro Mirror or Global Mirror sessions are:

DEFINED

The state of the session on the CSM storage controller is Defined. The session exists but is inactive.

PREPARED

The state of the session on the CSM storage controller is Prepared. The source to target data transfer is active. The data that is written to the source is transferred to the target, and all volumes are consistent and recoverable.

PREPARING

The state of the session on the CSM storage controller is Preparing. The volumes are initializing, synchronizing, or resynchronizing.

RECOVERING

The state of the session on the CSM storage controller is Recovering. The session is in the process of recovering.

SUSPENDED

The state of the session on the CSM storage controller is Suspended. Data copying has temporarily stopped.

SUSPENDED (PARTIAL)

The state of the session on the CSM storage controller is Suspended (Partial). Data copying between the source site and one of the target sites has suspended.

SUSPENDING

The state of the session on the CSM storage controller is Suspending. The session is changing into a Suspended state.

TARGET AVAILABLE

The state of the session on the CSM storage controller is Target available. Target volumes are available for application updates.



Contains the null value if the session type and storage type is not covered above, or if the storage state is unknown.

DATA_OUT_OF_SYNC

BIGINT

Nullable

The amount of data that is currently being tracked (in bytes)

Contains the null value if the session type is not Geographic Mirroring.

DATA_IN_TRANSIT

BIGINT

Nullable

A measurement of the amount of data in bytes from the production copy that is queued to send to the mirror copy but has not yet been received by the mirror copy node. This indicates how far behind the mirror copy node is. This value is only valid when the Geographic Mirroring copy status is Active.

Contains the null value if the session type is not Geographic Mirroring or if the session type is Geographic Mirroring and transmission delivery is *SYNC.

DATA_STATE

VARCHAR(9)



The data state of the mirror copy of the ASP. Possible data states are:

BACKLEVEL

Data on the mirror copy of the ASP is not up to date with the data on the production copy. This can occur when replication is either suspended or detached, resulting in a copy that is usable, but not current with the production data.

INSYNC

The target ASP copy has been synchronized with its source. The two copies are identical to each other. This can only occur when the source copy has been varied off.

UNUSABLE

The data in the ASP copy is not in a usable state. Either synchronization has not yet been completed, or the mirror copy node had an abnormal termination that requires synchronization.

USABLE

The data in the ASP copy is in a usable state. If *ASYNC mirroring mode has been selected, the mirror copy is usable unless an abnormal termination of the mirror copy occurs before the mirror copy of the ASP can be quiesced.

ROUND_TRIP_TIME

BIGINT

Nullable

For ASP Geographic Mirroring contains the round-trip time in microseconds. Round-trip time represents the period of time when data is written to the storage on the production copy until that same data is acknowledged by the mirror copy node. For asynchronous transmission delivery, this indicates how far behind the mirror copy node is or could be. Regardless of transmission delivery, this estimates the impact of the network on the performance of geographic mirroring.

Round-trip time is influenced by factors including:

  • Physical distance between the production and mirror nodes

  • Latency between the nodes

  • Available data port bandwidth

  • Input/Output (I/O) load on the nodes

  • System configuration

Contains the null value if the session is not an ASP Geographic Mirroring session or if the round trip time is unknown.

DETACH_MODE

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

VARCHAR(10)

The detach mode that controls the replication of data when the session is detached for a SVC policy-based replication.

*ACTIVE

When the session is detached, replication continues to the target storage device in the background. While the data on the copy of the independent auxiliary storage pool that is accessible on the target
node is still a point-in-time copy from when the detach was issued, the target storage controller continues to receive updates from the production storage controller, improving the recovery point and
reducing the time required for resynchronization after a reattach.

Using this option may cause more storage space use in the target SAN Volume Controller.

*NONE

When the session is detached, replication is no longer running.

 

Contains the null value for any other session type.

DEVICE_DOMAIN

VARCHAR(10)

The name of the device domain the session is in.

Examples

Example 1 - Get the replication status for IASP devices in a session

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 SSN.SESSION_NAME, SSN.SESSION_TYPE, SSN.ASP_DEVICE, SSN.SOURCE_ASP_STATE, SSN.COPY_STATUS FROM TABLE(QHASM.SESSION_INFO(SESSION => 'MYSSN')) SSN;

Example 1 - Sample Output

SESSION_NAME

SESSION_TYPE

ASP_DEVICE

SOURCE_ASP_STATE

COPY_STATUS

SESSION_NAME

SESSION_TYPE

ASP_DEVICE

SOURCE_ASP_STATE

COPY_STATUS

MYSSN

*GEOMIR

MYIASP

AVAILABLE

ACTIVE

MYSSN

*GEOMIR

ARCHIVEASP

AVAILABLE

SUSPENDED

Example 2 - Find the replication status for all IASP devices with metro mirror or global mirror replication

The following example finds all sessions that are either Metro Mirror or Global Mirror and returns the session name, type of session, IASP device, and replication status:

SELECT INFO.SESSION_NAME, INFO.SESSION_TYPE, INFO.ASP_DEVICE, INFO.COPY_STATUS FROM (SELECT DISTINCT SESSION_NAME FROM QHASM.SESSION_LIST WHERE SESSION_TYPE = '*GLOBALMIR' OR SESSION_TYPE = '*METROMIR') AS LIST, TABLE(QHASM.SESSION_INFO(SESSION => LIST.SESSION_NAME)) INFO;

Example 2 - Sample Output

SESSION_NAME

SESSION_TYPE

ASP_DEVICE

COPY_STATUS

SESSION_NAME

SESSION_TYPE

ASP_DEVICE

COPY_STATUS

SVCSSN1

*METROMIR

MYIASP

DETACHED

SVCSSN1

*METROMIR

ARCHIVEASP

DETACHED

SVCGMIRSSN

*GLOBALMIR

PRODASP

ACTIVE

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

CLUSTER DOES NOT EXIST

42704

DEVICE DOMAIN &1 DOES NOT EXIST

42704

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