PowerHA SQL Services

PowerHA services provide an SQL interface to access, transform, order, and subset the information without needing to code to a PowerHA API.

This table contains a summary of services that are available, and which PTF(s) are required for a given service.

PowerHA Service	Description	Type of Service	Supported IBM i Releases
PowerHA Service	Description	Type of Service	7.2	7.3	7.4	7.5
Administrative Domain Services
QHASM.ADMIN_DOMAIN_LIST	The administrative domain list view contains information about administrative domains in the cluster.	View	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.ADMIN_DOMAIN_NODES	The ADMIN_DOMAIN_MRE_DETAILS table function returns details about nodes in a cluster administrative domain.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.ADMIN_DOMAIN_MRE_ATTRIBUTES	The ADMIN_DOMAIN_MRE_ATTRIBUTES table function returns information about monitored resource attributes for a monitored resource in a cluster administrative domain.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.ADMIN_DOMAIN_MRE_DETAILS	The ADMIN_DOMAIN_MRE_LIST table function returns information about monitored resource entries in a cluster administrative domain.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.ADMIN_DOMAIN_MRE_LIST	The ADMIN_DOMAIN_NODES table function returns information about the nodes in an administrative domain.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
Cluster Resource Group Services
QHASM.CLUSTER_RESOURCE_GROUP_LIST	The cluster resource group list view contains information about cluster resource groups in the cluster.	View	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.CRG_CONFIGURATION_OBJECTS	The CRG_CONFIGURATION_OBJECTS table function returns information about configuration objects managed by a device CRG.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.CRG_INFO	The CRG_INFO table function returns details about a cluster resource group.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.CRG_RECOVERY_DOMAIN	The CRG_RECOVERY_DOMAIN table function returns details about a nodes in a cluster resource group recovery domain.	Table Function	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
Cluster Services
QHASM.Cluster_Info	The cluster info view contains information about a cluster.	View	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
QHASM.Cluster_Nodes	The cluster nodes view contains information about nodes in the cluster.	View	SF99776 Level 15 or SI73520	SF99876 Level 12 or SI73520	SF99666 Level 4 or SI73521	Base
HyperSwap Services
QHASM.HYPERSWAP_STATUS_LIST	The QHASM.HYPERSWAP_STATUS_LIST view contains information about the list of HyperSwap relationships.	View	N/A	N/A	SJ00821	SJ00828
QHASM.HYPERSWAP_STATUS_INFO	The HYPERSWAP_STATUS_INFO table function returns details about HyperSwap relationships.	Table Function	N/A	N/A	SJ00821	SJ00828
Session Services
QHASM.SESSION_LIST	The QHASM.Session_List view contains information about the list of PowerHA sessions in a cluster.	View	SF99776 Level 16 or SI74921	SF99876 Level 13 or SI74921	SF99666 Level 5 or SI74865	Base
QHASM.SESSION_INFO	The SESSION_INFO table function returns details about a session.	Table Function	SF99776 Level 16 or SI74921	SF99876 Level 13 or SI74921	SF99666 Level 5 or SI74865	Base

NOTE: A PTF of 'base' indicates that the service is available in the base release without additional PTFs.