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 |
|---|---|---|
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 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:
Contains the null value if the session is not an CSM Global Mirror session. |
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. |
CONSISTENCY_GROUP_NAME | VARCHAR(64) | The name of the consistency group used to control the relationship. |
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 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 | 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_IN_TRANSIT | 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_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:
Contains the null value if the session is not an ASP Geographic Mirroring session or if the round trip time is unknown. |
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|
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 |
|---|---|
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 |