Page Comparison

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 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, 2022See Configuring the PowerHA Web Interface for additional information.

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.

...

Procedure

Open Insite Analytics

Log in to the 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 Insite server, the homepage is displayed.
Click the Select Product button and select Insite Analytics.
Image Modified
The Insite Analytics menu will appear.
Image Modified

Creating Data Connections

...

Tip
Tip: You must add a Data Connection for at least one node in each PowerHA cluster. Data connections are not necessary for every node in a PowerHA cluster. Insite Analytics displays data as it is transmitted by the nodes with a data connection.

Add a data connection for at least one node in each cluster that will be on a dashboard

Expand

title	Creating a Data Connection

In the Insite Analytics Menu select Data Connections
Image Modified
Click +Add from the Data Connections panel.
Image Modified
Fill in the following options:
1. Name: Enter a name for the data connection. The IBM i Host Name is a good choice for the name of the connection.
2. Driver: From the dropdown list, select Db2/400
3. URL: Define the connection string that will be used to connect to the server. The connection string template is:
  Code Block
  language sql
  jdbc:as400://[serverName];prompt=false;extendedmetadata=true;translatebinary=true;libraries=*LIBL;naming=system
  Where: [serverName] = the network resolvable name or address of the IBM i server.
  For example, if the server had IP address 203.0.113.2, the connection URL would be: jdbc:as400://203.0.113.2;prompt=false;extendedmetadata=true;translatebinary=true;libraries=*LIBL;naming=system
4. Timezone: If the IBM i Server is in a different time zone to the Insite Server, set its UTC offset accordingly.
5. Permissions: By default, permission to edit or use a data connection is limited to the Admin user and the creator of the data connection. These options enable other users to be given permission to either edit or use the data connection. Possible values are:
  1. Users: Choose any of the listed users to provide rights to the data connection.
  2. Groups: Choose any of the listed groups to provide rights to the data connection.
  3. Permit All: Select whether to allow all users access to the data connection or to limit permissions to the Admin, creator, or any specified user or group.
6. Credentials: For the node defined in the URL above, enter a valid IBM i Username and Password of the user profile that will be used to process requests for this data connection.
Click the blue Test button to verify the connection
Click the green Save button at the top right to save the connection details.
If you have more than one cluster, additional Data Connections can be set up repeating the above instructions.

Queries

The Query Builder enables the creation of SQL queries, which are used to select the information to be displayed in Insite Dashboards. Follow the procedure in this section to create SQL queries with Query Builder:

In the Insite Analytics menu select Queries
Image Modified

Add the basic PowerHA Queries

Add the Cluster Nodes Query with the following information:

Query Name

PowerHA Cluster Nodes

Description

A list of all cluster nodes along with their status information

SQL

Code Block

language	sql

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.
Image Modified
Complete the options as described below using copy/paste where applicable. For example:
1. Name: Cluster Nodes
2. Description: A list of all cluster nodes along with their status information
3. 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.
Image Modified
Enter the SQL statement. For example:
Code Block
language sql
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:
Image Modified
Click the green Save button in the upper right.

2. Add the Administrative Domains Query with the following information:

Query Name

PowerHA Administrative Domains

Description

A list of administrative domains with their status information

SQL

Code Block

language	sql

SELECT ADMINISTRATIVE_DOMAIN,DOMAIN_STATUS
  FROM QHASM.ADMIN_DOMAIN_LIST

3. Add the Monitored Resources Query with the following information:

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

language	sql

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.

4. Add the Unmonitored Resources Query with the following information:

Query Name

PowerHA Unmonitored Resources

Description

A list of resources not currently monitored by the administrative domain that could be monitored by the administrative domain

SQL

Code Block

language	sql

SELECT JOBD.OBJNAME AS "Unmonitored Resource", '*JOBD' as "Resource Type", JOBD.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*JOBD','*ALLSIMPLE')) JOBD
    WHERE JOBD.OBJLONGSCHEMA != 'QSYS' AND JOBD.OBJLONGSCHEMA != 'QINSYS' AND JOBD.OBJLONGSCHEMA != 'QINPRIOR' AND JOBD.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*JOBD')) MRE
        WHERE MRE.MONITORED_RESOURCE = JOBD.OBJNAME)
UNION
SELECT SBSD.OBJNAME AS "Unmonitored Resource", '*SBSD' as "Resource Type", SBSD.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*SBSD','*ALLSIMPLE')) SBSD
    WHERE SBSD.OBJLONGSCHEMA != 'QSYS' AND SBSD.OBJLONGSCHEMA != 'QINSYS' AND SBSD.OBJLONGSCHEMA != 'QINPRIOR' AND SBSD.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*SBSD')) MRE
        WHERE MRE.MONITORED_RESOURCE = SBSD.OBJNAME)
UNION
SELECT USRPRF.OBJNAME AS "Unmonitored Resource", '*USRPRF' as "Resource Type", USRPRF.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS','*USRPRF','*ALLSIMPLE')) USRPRF
    WHERE NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*USRPRF')) MRE
        WHERE MRE.MONITORED_RESOURCE = USRPRF.OBJNAME)
UNION
SELECT AUTL.OBJNAME AS "Unmonitored Resource", '*AUTL' as "Resource Type", AUTL.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS','*AUTL','*ALLSIMPLE')) AUTL
    WHERE NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*AUTL')) MRE
        WHERE MRE.MONITORED_RESOURCE = AUTL.OBJNAME)
UNION
SELECT CLS.OBJNAME AS "Unmonitored Resource", '*CLS' as "Resource Type", CLS.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*CLS','*ALLSIMPLE')) CLS
    WHERE CLS.OBJLONGSCHEMA != 'QSYS' AND CLS.OBJLONGSCHEMA != 'QINSYS' AND CLS.OBJLONGSCHEMA != 'QINPRIOR' AND CLS.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*CLS')) MRE
        WHERE MRE.MONITORED_RESOURCE = CLS.OBJNAME)

5. Add the Cluster Resource Groups Query with the following information:

Query Name

PowerHA Cluster Resource Groups

Description

A list of cluster resource groups along with their status

SQL

Code Block

language	sql

SELECT CLUSTER_RESOURCE_GROUP,CRG_TYPE,CRG_STATUS,PRIMARY_NODE 
  FROM QHASM.CLUSTER_RESOURCE_GROUP_LIST

6. Add the Recovery Domain Nodes Requiring Attention Query with the following information:

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

language	sql

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.

7. Add the Session Info Query with the following information:

Query Name

PowerHA Session Information

Description

A list of sessions along with current replication status

SQL

Code Block

language	sql

SELECT SESSION_INFO.SESSION_NAME,SESSION_INFO.SESSION_TYPE,SESSION_INFO.ASP_DEVICE,SESSION_INFO.SOURCE_NODE,SESSION_INFO.SOURCE_ASP_STATE,SESSION_INFO.COPY_STATUS,SESSION_INFO.TARGET_NODE,SESSION_INFO.TARGET_ASP_STATE
FROM QHASM.SESSION_LIST SESSION_LIST,
     TABLE(QHASM.SESSION_INFO(SESSION => SESSION_LIST.SESSION_NAME)) SESSION_INFO

Add the PowerHA Queries with Drilldown Query

1. Add the Count Cluster Nodes Requiring Attention Query:

Query Name

PowerHA Count Cluster Nodes Requiring Attention

Description

A count of cluster nodes that are not active

SQL

Code Block

language	sql

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
Image Modified
Under choose query, select the drilldown query. For example: PowerHA Cluster Nodes
Image Modified
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.

2. Add the Count of Admin Domains Requiring Attention Query:

Query Name

PowerHA Count of Admin Domains Requiring Attention

Description

A count of administrative domains that are not active

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT 
  FROM QHASM.ADMIN_DOMAIN_LIST
  WHERE DOMAIN_STATUS != 'ACTIVE'

Drilldown Query

PowerHA Administrative Domains

3. Add the Count of Monitored Resources Requiring Attention Query:

Query Name

PowerHA Count of Monitored Resources Requiring Attention

Description

A count of monitored resources requiring attention

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT 
  FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST()) LIST
  WHERE LIST.GLOBAL_STATUS = '*INCONSISTENT' OR LIST.GLOBAL_STATUS = '*FAILED'

Drilldown Query

PowerHA Monitored Resources Requiring Attention

4. Add the Count of Unmonitored Resources Query:

Query Name

PowerHA Count of Unmonitored Resources

Description

A count of resources not currently monitored by the administrative domain that could be monitored by the administrative domain

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT FROM
(SELECT JOBD.OBJNAME AS "Unmonitored Resource", '*JOBD' as "Resource Type", JOBD.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*JOBD','*ALLSIMPLE')) JOBD
    WHERE JOBD.OBJLONGSCHEMA != 'QSYS' AND JOBD.OBJLONGSCHEMA != 'QINSYS' AND JOBD.OBJLONGSCHEMA != 'QINPRIOR' AND JOBD.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*JOBD')) MRE
        WHERE MRE.MONITORED_RESOURCE = JOBD.OBJNAME)
UNION
SELECT SBSD.OBJNAME AS "Unmonitored Resource", '*SBSD' as "Resource Type", SBSD.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*SBSD','*ALLSIMPLE')) SBSD
    WHERE SBSD.OBJLONGSCHEMA != 'QSYS' AND SBSD.OBJLONGSCHEMA != 'QINSYS' AND SBSD.OBJLONGSCHEMA != 'QINPRIOR' AND SBSD.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*SBSD')) MRE
        WHERE MRE.MONITORED_RESOURCE = SBSD.OBJNAME)
UNION
SELECT USRPRF.OBJNAME AS "Unmonitored Resource", '*USRPRF' as "Resource Type", USRPRF.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS','*USRPRF','*ALLSIMPLE')) USRPRF
    WHERE NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*USRPRF')) MRE
        WHERE MRE.MONITORED_RESOURCE = USRPRF.OBJNAME)
UNION
SELECT AUTL.OBJNAME AS "Unmonitored Resource", '*AUTL' as "Resource Type", AUTL.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('QSYS','*AUTL','*ALLSIMPLE')) AUTL
    WHERE NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*AUTL')) MRE
        WHERE MRE.MONITORED_RESOURCE = AUTL.OBJNAME)
UNION
SELECT CLS.OBJNAME AS "Unmonitored Resource", '*CLS' as "Resource Type", CLS.OBJLONGSCHEMA as "Resource Library"
    FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL','*CLS','*ALLSIMPLE')) CLS
    WHERE CLS.OBJLONGSCHEMA != 'QSYS' AND CLS.OBJLONGSCHEMA != 'QINSYS' AND CLS.OBJLONGSCHEMA != 'QINPRIOR' AND CLS.OBJLONGSCHEMA != 'QINMEDIA' AND
        NOT EXISTS (
        SELECT MONITORED_RESOURCE
        FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(RESOURCE_TYPE => '*CLS')) MRE
        WHERE MRE.MONITORED_RESOURCE = CLS.OBJNAME))

Drilldown Query

PowerHA Unmonitored Resources

5. Add the Count of Cluster Resource Groups Requiring Attention Query:

Query Name

PowerHA Count of Cluster Resource Groups Requiring Attention

Description

A count of cluster resource groups that are not active

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT 
  FROM QHASM.CLUSTER_RESOURCE_GROUP_LIST
  WHERE CRG_STATUS != 'ACTIVE'

Drilldown Query

PowerHA Cluster Resource Groups

6. Add the Count of Recovery Domain Nodes Requiring Attention Query:

Query Name

PowerHA Count of Recovery Domain Nodes Requiring Attention

Description

A count of cluster resource groups that are not active

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT
  FROM QHASM.CLUSTER_RESOURCE_GROUP_LIST LIST,
       TABLE(QHASM.CRG_RECOVERY_DOMAIN(LIST.CLUSTER_RESOURCE_GROUP)) RCYDMN
  WHERE NODE_STATUS != 'ACTIVE'

Drilldown Query

PowerHA Recovery Domain Nodes Requiring Attention

7. Add the Count of Sessions Requiring Attention Query:

Query Name

PowerHA Count of Sessions Requiring Attention

Description

A count of sessions where the copy status is not active

SQL

Code Block

language	sql

SELECT COUNT(*) AS COUNT
FROM QHASM.SESSION_LIST SESSION_LIST,
     TABLE(QHASM.SESSION_INFO(SESSION => SESSION_LIST.SESSION_NAME)) SESSION_INFO
WHERE SESSION_INFO.COPY_STATUS != 'ACTIVE'

Drilldown Query

PowerHA Session Information

PowerHA Status Dashboard

This section describes how to create a 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.

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.
Image Modified
Click the green +Add Dashboard button at the upper-right of the screen
Image Modified
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 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.

...

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 Layout

Ensure Edit mode is on.
Image Modified
Hover your mouse over the top section and select the green +Add Group.
Image Modified
Click Edit Group.
Select to Show the Header.
Enter a Title such as PowerHA Status.
Image Modified
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.
Image Modified

Adding Widgets to the Layout

Add the Cluster Nodes Widget
1. Click the three dots at the top right of section 1 and select Add Widget.
2. Select Insite Analytics for the Data Source.
3. For the Asset select PowerHA Count of Cluster Nodes Requiring Attention.
4. Select the cluster node to use for this connection. In this example, the data source is Prod.
  Image Modified
5. Enter Nodes under Name.
6. Select Key Indicator as the Widget Type.
7. Select the only metric that is displayed. The preview on the left will now update to display a number.
  Image Modified
8. 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.
9. Select Show for Use Status Color as Widget Background and Custom for Thresholds.
10. Click the green Add Rule button.
11. 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.
12. 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.
  Image Modified
13. Click the green Save button in the upper-right hand corner.
Repeat step 1 a-m for the remaining 6 sections in this Group:
1. 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 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.
You can create queries to other data sources and combine PowerHA data with data from other applications.

Versions Compared

Old Version 6

New Version Current

Key

Procedure

Open Insite Analytics

Creating Data Connections

Queries

Add the basic PowerHA Queries

Add the PowerHA Queries with Drilldown Query

PowerHA Status Dashboard

Creating the Layout

Adding Widgets to the Layout