The QHASM.Session_List view contains information about the list of PowerHA sessions in a cluster.
The values returned for the columns in this view contain information represented differently from the panels of the Work with ASP Copy Descriptions (WRKASPCPYD) CL command.
Authorization
The authorization ID of the statement must include the following privileges:
*OBJOPR and *READ authority on QHASM/SSN_LIST.
Input/output system configuration (*IOSYSCFG) special authority.
Note: At least one node in a device domain must be active for sessions in the device domain to be returned.
Results Table
The table describes the columns in the view. The system name used here is SSN_LIST. The schema is QHASM.
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. |
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 |
|---|---|
42501 | Not authorized to object SSN_LIST in QHASM type *FILE |
42502 | CURRENT USER DOES NOT HAVE *IOSYSCFG SPECIAL AUTHORITY |
42704 | CLUSTER DOES NOT EXIST |
560CR | NO VALID LICENSE FOR IBM POWERHA FOR I FOUND |
57012 | CLUSTER RESOURCE SERVICES NOT ACTIVE OR NOT RESPONDING |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |