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:

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:

ParameterSelection
Monitoring SolutionSAP HANA
Monitor ProfileSAP HANA
Monitor TypeSAP 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.

FieldDescription
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.

FieldDescription
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 portBased 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 queryEnter 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 annotationSelect this option to display the query result as an annotation on the number of records metric.

SAP HANA connection details

FieldDescription
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 CategoriesDescription
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 severityDepending on the severity level, select a minimal severity to be alerted on.

Environment settings details

FieldDescription
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:

  • JavaPATROL_HOME/Patrol3/shmkm/logs/java
  • PSLPATROL_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 nameEnter 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.

Was this page helpful? Yes No Submitting... Thank you

Comments