SAP HANA Direct connection setup

After you have installed the PATROL for SAP HANA, you must configure a monitoring policy.

You can use the information in this topic to configure SAP HANA Direct connection setup monitoring policy with the TrueSight console.

This topic includes the following information:

Related topics

Monitor types and attributes

Installing

Configuration video

https://youtu.be/w60cH_6Ma2c

Before you begin

You must have downloaded and install the SAP HANA KM.

To configure the monitor type

In the Add Monitoring Configuration panel, select the following parameters for the SAP HANA KM:

Parameter	Selection
Monitoring Solution	SAP HANA
Monitor Profile	SAP HANA
Monitor Type	SAP HANA Direct connection setup

For the Global Monitoring Setting, you can enable Logging for all of the configured PATROL Agent environments to confirm that all of the PATROL for SAP HANA environments are correctly configured.

To add an environment configuration

Click Add and enter the Environment Configuration details.

Field

Description

Environment name

Enter a unique environment name for monitoring the SAP HANA database. A container will be created with this environment name that will hold all the TrueSight instances.

Note

The name cannot include blank spaces or any of the following special characters: # $ \ ' | ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * /
Do not use non-English characters to specify an environment name.
Once you save the environment configuration, you cannot change the name without losing the environment's historical data. You can change the environment name by making a copy of the monitoring solution and then you can change the environment name.

The remaining environment details are in the following sections:

Direct instance connection details

Click Add and enter the direct instance connection details.

Field	Description
Host	Enter the host name or IP address of the monitored SAP HANA database. The entry must not contain any character from the following: *'#\|~@%^;`(){}?\\"[]+=\&></**
Connection method	Specify the connection method: Instance number Instance port SAP HANA index server SQL port uses 3XX15 and 3XX13.
Instance number or port	Based on the selection in the above field, enter the SAP HANA database instance number or SQL port to monitor.

Custom SQL Query details

Click Add and enter the custom SQL query details

Custom SQL Query
Query name	Enter a SQL query name. Note The name cannot include blank spaces or any of the following special characters: # $ \ ' \| ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * / After you save the environment configuration, you cannot change the name without losing the environment's historical data. You can change the environment name by making a copy of the monitoring solution and then changing the environment name.
SQL query	Enter the SQL query. Do not terminate the query with the semi-colon (;).
Collection time (minutes)	Specify the collection time interval in minutes. By default, the collection time interval is 10 minutes.
Enable number of records annotation	Select this option to display the query result as an annotation on the number of records metric.

SAP HANA connection details

Field	Description
JDBC driver path	Enter the path of the JDBC driver file. For more details about installing the JDBC driver, see Connect to SAP HANA via JDBC . For example: `/home/ptest/JDBC_Driver/ngdbc.jar`
Credentials
User name	The monitoring user name of the SAP HANA Database.
Password Confirm password	The user password of the SAP HANA Database.

Monitoring categories details

Select the SAP HANA Database activity categories that you want to monitor.

Monitoring Categories	Description
Files	Monitors the files activity of the SAP HANA database. For more details, see the Files (SHM_FILES) monitoring category.
Services	Monitors the services activity of the SAP HANA database For more details, see the Services (SHM_SERVICES) monitoring category.
Health
Health	Select this option to monitor the health activity of the SAP HANA database. For more details, see the Health (SHM_HEALTH) monitoring category.
Alerts severity	Depending on the severity level, select a minimal severity to be alerted on.

Environment settings details

Field	Description
Logging	Select this option to enable debugging operations for all SAP HANA instances configured on this environment. The log files are created under PATROL_HOME directory: Java: `PATROL_HOME/Patrol3/shmkm/logs/java` PSL: `PATROL_HOME/Patrol3/log/shm-*.kmlog`
Device mapping	By default, device mapping on the TrueSight console is enabled. If enabled, all the SAP HANA Database instances are discovered under the SAP HANA host device. If it is disabled, all the SAP HANA Database instances are discovered under the PATROL Agent host device.
Java collector settings
Java home	Enter the path to the JRE directory on the PATROL Agent host. The Java version must be 8 or later. For example: Windows: C:\Program Files (x86)\Java\jre8 Unix\LINUX: /usr/java8_64/ Alternatively, you can also the $JAVA_HOME environment variable in this field. If you use the $JAVA_HOME variable, the Java location depends on the following: If the user name and password are not entered for the Java collector settings; the KM uses the Java location of the user that is running the PATROL Agent A user name and password are entered for the Java collector settings; the KM uses Java location of the user entered in the collector settings. If this field is left blank, the KM looks for the Java executable in the Patrol3\openjdk\ and Patrol3\jre64 location If you enter a path for the JRE directory, you must enter the full path. Do not use the short path format.
JVM arguments	Enter the optional Java Virtual Machine (JVM) arguments for the Java collector.
User name	Enter the local user name to start the Java process.
Password Confirm password	Enter the user password to start the Java process.
Collection settings
Availability collection Interval (minutes)	The time interval used to check for the environment's availability for collecting data. The default interval is one minute.
Data collection Interval (minutes)	The time interval used for data collection from the environment. The default interval is five minutes. Note: Entering a data collection time that is less than 5 minutes will result in a performance issue for the KM.
Long running data collection queries (minutes)	The time interval use to determine when a running query is blocked. The query is blocked because its execution duration is equal to, or greater than, this interval's threshold. The default interval is 30 minutes.

After you have completed configuring the environment, click OK to add this to the environment configurations list. This environment is displayed on the Environment Configuration list.

Click Cancel to exit without saving any changes.

If you want to verify the configuration on your TrueSight console, click here.