QHASM.Session_List View
- Brian Nordland
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. |
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.
SELECT DISTINCT SESSION_NAME, SESSION_TYPE
FROM QHASM.SESSION_LIST;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 |
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.