The QHASM.Session_List view contains information about the list of PowerHA sessions in a cluster.
...
*OBJOPR and *READ authority on QHASM/SSN_LIST.
Input/output system configuration (*IOSYSCFG) special authority.
| Info |
|---|
Note: At least one node in a device domain must be active for sessions in the device domain to be returned. |
...
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. |
Examples
Example 1 - Get the list of sessions and type
The following example gets a list of sessions in the device domain for the local node.
| Code Block | ||
|---|---|---|
| ||
SELECT DISTINCT SESSION_NAME, SESSION_TYPE
FROM QHASM.SESSION_LIST; |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Tip: This SQL service returns one row per IASP device in a session. This example uses the DISTINCT keyword to ensure only one entry per session is returned even in complex environments with multiple IASP devices. |
Example 1 - Sample Output
SESSION_NAME | SESSION_TYPE |
|---|---|
SVCGLOBAL | *GLOBALMIR |
FLASH | *FLASHCOPY |
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 |
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 |
58004 | AN UNEXPECTED ERROR OCCURRED. SEE JOBLOG FOR MORE INFORMATION |