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

7.2

7.3

7.4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.