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 |
---|---|---|
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:
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 |