PowerHA SQL Services
- Brian Nordland
- Shengli Li
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 | |||
|---|---|---|---|---|---|---|
7.2 | 7.3 | 7.4 | 7.5 | |||
Administrative Domain Services | ||||||
The administrative domain list view contains information about administrative domains in the cluster. | View | SF99776 Level 15 or | SF99876 Level 12 | SF99666 Level 4 or SI73521 | Base | |
The ADMIN_DOMAIN_MRE_DETAILS table function returns details about nodes in a cluster administrative domain. | Table Function | SF99776 Level 15 or | SF99876 Level 12 | SF99666 Level 4 | Base | |
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 | SF99876 Level 12 | SF99666 Level 4 | Base | |
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 | SF99666 Level 4 or | Base | |
The ADMIN_DOMAIN_NODES table function returns information about the nodes in an administrative domain. | Table Function | SF99776 Level 15 or | SF99876 Level 12 | SF99666 Level 4 or | Base | |
Cluster Resource Group Services | ||||||
The cluster resource group list view contains information about cluster resource groups in the cluster. | View | SF99776 Level 15 or | SF99876 Level 12 or SI73520 | SF99666 Level 4 or SI73521 | Base | |
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 | |
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 | |
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 | ||||||
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 | |
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 | ||||||
The QHASM.HYPERSWAP_STATUS_LIST view contains information about the list of HyperSwap relationships. | View | N/A | N/A | SJ00821 | SJ00828 | |
The HYPERSWAP_STATUS_INFO table function returns details about HyperSwap relationships. | Table Function | N/A | N/A | SJ00821 | SJ00828 | |
Session Services | ||||||
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 | |
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.
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.