SAP Service monitoring for  HANA DB

 

 

 

Step 1:-  Login to Server.

MEGHNAECC:~ #  insserv /etc/init.d/zabbix_agentd    [ To start  zabbix agent automatically after reboot]

 

Step 2:-

MEGHNAECC:~ # su – mhdadm [ Login to application ]

MEGHNAECC:/usr/sap/MHD/HDB00> which sapcontrol

/usr/sap/MHD/HDB00/exe/sapcontrol

MEGHNAECC:/usr/sap/MHD/HDB00> echo $LD_LIBRARY_PATH

/usr/sap/MHD/HDB00/exe:/usr/sap/MHD/HDB00/exe/Python/lib:/usr/sap/MHD/HDB00/exe/filter:/usr/sap/MHD/HDB00/exe/dat_bin_dir:/usr/sap/MHD/HDB00/exe/plugins/afl:/usr/sap/MHD/HDB00/exe/plugins/lcapps:/usr/sap/MHD/HDB00/exe/plugins/repository:/usr/sap/MHD/SYS/global/security/lib:/usr/sap/MHD/SYS/global/hdb/federation

MEGHNAECC:/usr/sap/MHD/HDB00> exit

 

 

Step 3:-

MEGHNAECC:~ # vi /opt/zabbix/bin/check_sap_hana_health.sh

export LD_LIBRARY_PATH=/usr/sap/MHD/HDB00/exe:/usr/sap/MHD/HDB00/exe/Python/lib:/usr/sap/MHD/HDB00/exe/filter:/usr/sap/MHD/HDB00/exe/dat_bin_dir:/usr/sap/MHD/HDB00/exe/plugins/afl:/usr/sap/MHD/HDB00/exe/plugins/lcapps:/usr/sap/MHD/HDB00/exe/plugins/repository:/usr/sap/MHD/SYS/global/security/lib:/usr/sap/MHD/SYS/global/hdb/federation

/usr/sap/MHD/HDB00/exe/sapcontrol -nr 00 -function GetProcessList

 

 

Step 4:-

MEGHNAECC:~ # chmod 755 /opt/zabbix/bin/check_sap_hana_health.sh

 

Step 5:-

MEGHNAECC:~ # /opt/zabbix/bin/check_sap_hana_health.sh

08.12.2015 13:01:16

GetProcessList

OK

name, description, dispstatus, textstatus, starttime, elapsedtime, pid

hdbdaemon, HDB Daemon, GREEN, Running, 2015 11 24 22:44:05, 326:17:11, 4570

hdbnameserver, HDB Nameserver, GREEN, Running, 2015 11 24 22:44:06, 326:17:10, 4586

hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2015 11 24 22:44:15, 326:17:01, 4704

hdbindexserver, HDB Indexserver, GREEN, Running, 2015 11 24 22:44:18, 326:16:58, 4736

hdbstatisticsserver, HDB Statisticsserver, GREEN, Running, 2015 11 24 22:44:18, 326:16:58, 4739

hdbxsengine, HDB XSEngine, GREEN, Running, 2015 11 24 22:44:18, 326:16:58, 4742

sapwebdisp_hdb, SAP WebDispatcher, GREEN, Running, 2015 11 24 22:45:50, 326:15:26, 5281

hdbcompileserver, HDB Compileserver, GREEN, Running, 2015 11 24 22:44:15, 326:17:01, 4707

MEGHNAECC:~ #

 

Step 6:-

MEGHNAECC:~ #  vi /opt/zabbix/etc/zabbix_agentd.conf

UserParameter=check_sap_hana[*],/opt/zabbix/bin/check_sap_hana_health.sh | egrep $1

 

Step 7:-

MEGHNAECC:~ #  usermod –G sapsys zabbix

 

Step 8:-

MEGHNAECC:~ #  /etc/init.d/zabbix_agentd restart

 

Please Create below Macros:

For HANA_DB for Template: Template_SAP_HANA_DB

 

 

Step 9:-

In Zabbix Proxy:  Verificatio:

zabbix_get -s 103.241.182.215 -k check_sap_hana[h]




PLEASE WRITE A FEEDBACK OR SUGGESTIONS TO BELOW EMAIL ID’S.

prashantkumar.chawan@gmail.com

info@mytara.co.in