Sap hana monitoring

Plugin to monitor the SAP Hana database engine using the local resources of the server where SAP Hana is installed.

Introduction

Plugin to monitor the SAP Hana database engine using the local resources of the server where SAP Hana is installed

Compatibility matrix

Developed using SAP Hana version 2.00.023.00.1513691289

Prerequisites

This plugin uses the local commands of the server and the SAP Hana application to monitor the state of the DB services as well as blockages, connections, and so on.

User with permission to execute the following commands

● hdbsql
● sapcontrol

User with permission to refer to the following tables:

● M_DATABASE
● M_BLOCKED_TRANSACTIONS
● M_HOST_RESOURCE_UTILIZATION
● PUBLIC.M_CONNECTIONS
● M_VOLUME_IO_TOTAL_STATISTICS
● M_LICENSE
● M_RS_MEMORY
● M_SERVICE_THREADS
● M_DATA_VOLUMES

Connection with the Tentacle service associated to your Pandora FMS server is required (for local executions of the plugin) under the following conditions:

● If you have as_agent_plugin disabled.

Configuration

The configuration file of the plugin [plugin name] is divided into blocks:

Paths to binaries

# Command paths
hdbsql = /hana/shared/DBH/hdbclient/hdbsql
sapcontrol = /usr/sap/hostctrl/exe/sapcontrol

hdbsql
Path to find the binary hdbsql (SQL client for SAP Hana)
sapcontrol
Path to find the binary sapcontrol. It will be used to obtain the health status of the SAP Hana services.

User data

# Creds
hana_user = system
hana_password = EncryptedOrPlainPasswordHere
hana_hostport = 172.17.0.2:39017
hana_instance = 90

# 0 to use unencrypted password
use_encrypted_password = 1

To generate encrypted password, run the plugin with -v, the plugin will return an output with the password defined in the encrypted conf.

./pandora_hana pandora_hana.conf -v

hana_user
Hana user
hana_password 
Hana password
hana_hostport
Hana host and port
hana_instance
Hana instance
use_encrypted_password 
Enable with 1 for using encrypted password

Customization of the monitoring

# Use the custom module header
module_header = SAP Hana
# To run in SAP Hana v1 environments
#compat_mode = 1
# To run as plugin server / in cron please set as_agent_plugin = 0
# and fulfill tentacle/local copy options
as_agent_plugin = 1
mode = local
tentacle_ip = yourpandora.lab.artica.lan
tentacle_port = 41121
tentacle_opts =
tentacle_client = "tentacle_client"
local_folder = /var/spoo//pandora / data_in
tmp = /tmp


module_header
Use custom headers for the modules generated by the plugin.
compat_mode
Set compatibility mode to run on environments SAP Hana v1. By setting this token,
module ‘STATUS’ of disk monitorization won’t be available. Also hdbsql parameters will be
adjusted.
as_agent_plugin
Set the value to 1 if you run the plugin with module_plugin from a Pandora FMS
EndPoint.
If you want to run it without an agent, from the CRON of the system, set it to 0.
mode
Mode of transfer of XML files, which can be:
● local: it copies the files to local_folder
● tentacle: it transfers the files to tentacle_ip by tentacle_port
tentacle_ip
IP address or FQDN where Pandora FMS is working.
tentacle_port
Port where the Tentacle service associated to your Pandora FMS server is listening.
tentacle_opts
Extra options for the Tentacle client.
tentacle_client
Path to find the binary customer's Tentacle.
local_folder
Location to move the files to in the local mode.
tmp
Temporary location to store the files before being sent.

Manual execution

To run the plugin, configure the config file according to the instructions above.

Execution of the plugin:

./pandora_hana.64 pandora_hana.conf

Modules generated by the plugin

The standard execution of this plug-in will return the following modules by default (with all
the optional blocks enabled):

Monitoring:

● SAP Hana connection status
● SAP Hana services health
● SAP Hana HDB Daemon status
● SAP Hana HDB Compileserver status
● SAP Hana HDB Indexserver-DBH status
● SAP Hana HDB Indexserver-D11 status
● SAP Hana HDB Nameserver status
● SAP Hana HDB Preprocessor status
● SAP Hana HDB Scriptserver-D11 status
● SAP Hana HDB Web Dispatcher status
● SAP Hana HDB XSEngine-DBH status
● SAP Hana HDB Indexserver-B11 status
● SAP Hana license validity
● SAP Hana license permanent
● SAP Hana license usage
● SAP Hana connections running
● SAP Hana connections active
● SAP Hana connections idle
● SAP Hana transactions blocked
● SAP Hana HOST:PORT/DATA_BACKUP read bandwidth
● SAP Hana HOST:PORT/DATA_BACKUP write bandwidth
● SAP Hana HOST:PORT/LOG_BACKUP read bandwidth
● SAP Hana HOST:PORT/LOG_BACKUP write bandwidth
● SAP Hana HOST:PORT/CATALOG_BACKUP read bandwidth
● SAP Hana HOST:PORT/CATALOG_BACKUP write bandwidth
● SAP Hana HOST:PORT/LOG read bandwidth
● SAP Hana HOST:PORT/LOG write bandwidth
● SAP Hana HOST:PORT/DATA read bandwidth
● SAP Hana HOST:PORT/DATA write bandwidth
● SAP Hana HOST:PORT Row Store allocated size
● SAP Hana HOST:PORT Row Store free ratio
● SAP Hana HOST:PORT Row Store reorg.
● SAP Hana HOST:PORT CPU time self
● SAP Hana HOST:PORT data file state
● SAP Hana HOST:PORT data disk usage