PowerHA by design requires minimal ongoing monitoring, management, and maintenance. With PowerHA dashboards, ongoing monitoring is simplified even more. Dashboards enable administrators to see any errors or warnings that may affect their business continuity. These dashboards can be configured to show PowerHA information alongside information from other products and can be configured to show multiple PowerHA environments on one screen.
...
Before
...
You Begin
The dashboards are delivered as part of HelpSystems Insite and Insite Analytics - a free offering from HelpSystems. Insite and Insite Analytics must be installed prior to following the steps below. For more information on Insite see the following information:
...
| Expand |
|---|
| title | Opening Insite Analytics |
|---|
|
NOTENote: 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. 
|
...
Query Name | PowerHA Cluster Nodes |
|---|
Description | A list of all cluster nodes along with their status information |
|---|
SQL | | Code Block |
|---|
| SELECT NODE,NODE_STATUS FROM QHASM.CLUSTER_NODES |
|
|---|
For instructions to add queries to Insite Analytics, expand this section.
| Expand |
|---|
| title | Adding a Basic Query to Insite Analytics |
|---|
|
Click the green +Add button at the top right of the Queries panel. The New Query panel opens on the right.  Complete the options as described below using copy/paste where applicable. For example: Name: Cluster Nodes Description: A list of all cluster nodes along with their status information Select Data Connection: Select the data connection(s) that you previously created
Click the green Edit Query button to continue. Click the gray Advanced Mode button to allow direct entry of the SQL statement.  Enter the SQL statement. For example: | Code Block |
|---|
| SELECT NODE,NODE_STATUS FROM QHASM.CLUSTER_NODES |
Click the Preview button. The panel should look similar to the following, returning information from your environment:  Click the green Save button in the upper right.
|
...
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. |
...
Query Name | PowerHA Count Cluster Nodes Requiring Attention |
|---|
Description | A count of cluster nodes that are not active |
|---|
SQL | | Code Block |
|---|
| SELECT COUNT(*) AS COUNT FROM QHASM.CLUSTER_NODES
WHERE NODE_STATUS != 'ACTIVE' |
|
|---|
Drilldown Query | PowerHA Cluster Nodes |
|---|
...
For instructions to add drilldown queries to Insite Analytics, expand this section.
| Expand |
|---|
| title | Adding a Drilldown Query |
|---|
|
Specific drill down queries are used to create color-coded indicator widgets showing a count of errors. Users can click on the widget to drill down into details of the errors. Click Advanced Drilldown  Under choose query, select the drilldown query. For example: PowerHA Cluster Nodes  Select to Inherit Data connection from the main query. Click the green OK button in the upper-right corner. On the main Query Edit panel, click the green Save button in the upper-right corner.
|
...
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 in this section here includes all the queries you have defined. You may can choose which of these you to include and adjust the layout to suit your preferences.
You can create as many dashboards as needed. The layout and settings of the dashboard can be changed at any time by customizing it.
Create an Insite Dashboard
| 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. |
|
2. Add PowerHA Dashboard Widgets
For instructions to add PowerHA widgets to Insite Analytics, expand this section.
| Expand |
|---|
| title | Adding PowerHA Widgets to the Dashboard |
|---|
|
There are 7 Power HA count of widgets. This example uses Indicator Widgets to show the count of each type. These indicator widgets will be grouped using a Group Widget, allowing a single title above the widgets. Creating the LayoutEnsure Edit mode is on.  Hover your mouse over the top section and select the green +Add Group.  Click Edit Group. Select to Show the Header. Enter a Title such as PowerHA Status.  Click the green Save button in the upper-right hand corner. Hover your mouse over the top section and select the Edit Groups Widgets button. Use the < and > arrows to split the section into 8 as shown below. If you make a mistake, click the undo button at the top of the panel. 
Add the Cluster Nodes Widget Click the three dots at the top right of section 1 and select Add Widget. Select Insite Analytics for the Data Source. For the Asset select PowerHA Count of Cluster Nodes Requiring Attention. Select the cluster node to use for this connection. In this example, the data source is Prod.  Enter Nodes under Name. Select Key Indicator as the Widget Type. Select the only metric that is displayed. The preview on the left will now update to display a number.  In order to show the widget as green when the count is zero, and red when greater than zero, thresholds must be used. Select the Layout Tab. Select Show for Use Status Color as Widget Background and Custom for Thresholds. Click the green Add Rule button. On the first rule, set the Condition to =, leave the Value as 0, and set the status to Good. This rule causes the widget to display in green when there are no cluster node errors. On the second rule, set the Condition to >, leave the Value as 0, and set the status to Critical. This rule causes the widget to display in green when there are one or more cluster node errors.  Click the green Save button in the upper-right hand corner.
Repeat step 1 a-m for the remaining 6 sections in this Group: For the 2nd section:
Asset | PowerHA Count of Admin Domains Requiring Attention |
|---|
Name | Admin Domains |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Warning |
c. For the 3rd section: Asset | PowerHA Count of Monitored Resources Requiring Attention |
|---|
Name | MREs |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Critical |
d. For the 4th section: Asset | PowerHA Count of Unmonitored Resources |
|---|
Name | Unmonitored Resources |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Warning |
e. For the 5th section: Asset | PowerHA Count of Cluster Resource Groups Requiring Attention |
|---|
Name | CRGs |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Warning |
f. For the 6th section: Asset | PowerHA Count of Recovery Domain Nodes Requiring Attention |
|---|
Name | Recovery Domain |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Critical |
g. For the 7th section: Asset | PowerHA Count of Sessions Requiring Attention |
|---|
Name | Sessions |
|---|
Rules | Condition | Value | Status |
|---|
= | 0 | Good | > | 0 | Critical |
3. When all widgets have been defined, click on Stop Editing Group. |
...
The dashboard described in this document is just one example . Other examples include:
...
of a PowerHA dashboard. Some suggestions for use include:
If you have multiple clusters to monitor, a single dashboard can be created with a group for each cluster or a separate dashboard can be created for each cluster.
If you have PowerHA and Robot HA, a single dashboard can be created that shows both the status of PowerHA and the status of Robot HA.
Create You can create queries to other data sources and combine PowerHA data with data from other applications.
...