| Note |
|---|
New PowerHA Modern Web Interface
We recently announced a modern web interface for PowerHA on IBM i 7.4 and 7.5. This new modern web interface will provide at-a-glance health information from a web browser. Additional information on this new interface will be available in December. We recommend utilizing the new web interface built into PowerHA instead of HelpSystems Fortra’s Insite and Insite Analytics. The instructions below will remain for existing installations and those looking for examples of utilizing PowerHA SQL services in other monitoring products.
Planned availability: December 16th, 2022 |
...
The dashboards are delivered as part of HelpSystems Fortra’s Insite and Insite Analytics - a free offering from HelpSystemsFortra. Insite and Insite Analytics must be installed prior to following the steps below. For more information on Insite see the following information:
...
Open Insite Analytics
Log in to the HelpSystems Insite Server
Open the Insite Analytics Product
| Expand |
|---|
| title | Opening Insite Analytics |
|---|
|
Note: For general usage of Insite Analytics, see the Insite Analytics Users Guide. After logging in to the HelpSystems Insite server, the homepage is displayed. Click the Select Product button and select Insite Analytics.  The Insite Analytics menu will appear. 
|
...
The Query Builder enables the creation of SQL queries, which are used to select the information to be displayed in the HelpSystems Insite Dashboards. Follow the procedure in this section to create SQL queries with Query Builder:
...
Query Name | PowerHA Monitored Resources Requiring Attention |
|---|
Description | A list of monitored resources that are either failed or inconsistent along with additional node level information |
|---|
SQL | | Code Block |
|---|
| SELECT DETAILS.MONITORED_RESOURCE,DETAILS.RESOURCE_TYPE,DETAILS.LIBRARY,DETAILS.GLOBAL_STATUS,DETAILS.NODE,DETAILS.LOCAL_STATUS,DETAILS.MESSAGE_ID,DETAILS.MESSAGE_TEXT
FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST()) LIST,
TABLE(QHASM.ADMIN_DOMAIN_MRE_DETAILS(MONITORED_RESOURCE => LIST.MONITORED_RESOURCE, RESOURCE_TYPE => LIST.RESOURCE_TYPE, LIBRARY => LIST.LIBRARY)) DETAILS
WHERE (LIST.GLOBAL_STATUS = '*INCONSISTENT' OR LIST.GLOBAL_STATUS = '*FAILED') AND
DETAILS.LOCAL_STATUS != 'CURRENT' |
|
|---|
| Info |
|---|
Note: Since the Monitored Resources Requiring Attention query only returns monitored resources that require attention, it is likely that when previewing this query, no data will be returned. |
...
Query Name | PowerHA Recovery Domain Nodes Requiring Attention |
|---|
Description | A list of nodes in CRG recovery domains that are inactive or ineligible |
|---|
SQL | | Code Block |
|---|
| SELECT RCYDMN.CLUSTER_RESOURCE_GROUP, RCYDMN.NODE, RCYDMN.NODE_STATUS, RCYDMN.SITE_NAME
FROM QHASM.CLUSTER_RESOURCE_GROUP_LIST LIST,
TABLE(QHASM.CRG_RECOVERY_DOMAIN(LIST.CLUSTER_RESOURCE_GROUP)) RCYDMN
WHERE NODE_STATUS != 'ACTIVE' |
|
|---|
| Info |
|---|
Note: Since the Recovery Domain Nodes Requiring Attention query only returns nodes that are not eligible for a switchover, it is likely that when previewing this query, no data will be returned. |
...
This section describes how to create a HelpSystems Insite Dashboard and add various widgets to show the status of PowerHA, highlighting issues that require attention. The example dashboard defined here includes all the queries you have defined. You can choose which of these to include and adjust the layout to suit your preferences.
...
| Expand |
|---|
| title | Creating an Insite Dashboard |
|---|
|
In the Navigation Pane, click Dashboards. If the menu is hidden, hover over the Navigation Pane to expand it.  Click the green +Add Dashboard button at the upper-right of the screen  Enter a unique name for the dashboard. For example: PowerHA Status Dashboard Enter a Description. For example: Status for PowerHA Environments Select a Color Theme. This theme applies to all widgets on this dashboard. In this example, we used the default Light Theme. Set the Edit Rights and Share With sections as required or leave them as the default. Refer to the HelpSystems Insite User Guide for options. Click Save. From the dashboard in Edit mode, click Select Quick Layout. From the layouts panel, select the 2 widgets tile.
| Tip |
|---|
Tip: The layout is customizable. Choose a layout that suits your needs. |
|
...