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