zbxdb icon indicating copy to clipboard operation
zbxdb copied to clipboard

Published 20 hours ago • verified publisher icon ikzelf

SAPhana integration

Open ikzelf opened this issue 3 years ago • 6 comments

I already made the connection and the exceptions module. Since I have no access to a SAPhana installation I can not continue this without any help. What needs to be done is verify the connection module

  • [x] $HOME/zbxdb/bin/zbxdb.py -c zbxdb.a_SAPhana.cfg -v

  • [x] I need a query to find the current main version number of hana.

  • [ ] I need a query to find the role of the database (primary/slave/standby)

  • [ ] I need queries for tablespace/volume utilisation, see oracle/primary.11.cfg for examples. (both lld and metrics)

ikzelf avatar Mar 05 '21 16:03 ikzelf

for Hana version select * from "SYS"."M_DATABASE";

lptarik avatar Jan 18 '22 07:01 lptarik

Thanks, what is the column name for the version?

ikzelf avatar Jan 18 '22 08:01 ikzelf

Never mind: I already had this: fullversion: select 'full_version', version from SYS.M_DATABASE

ikzelf avatar Jan 18 '22 08:01 ikzelf

Okay I will try to find other queries.

lptarik avatar Jan 18 '22 08:01 lptarik

There is hana db and sap exporter for prometheus. I saw queries there. Maybe you can check it out. We are trying to get from exporter to zabbix. https://github.com/SUSE/sap_host_exporter https://github.com/SUSE/hanadb_exporter

lptarik avatar Jan 25 '22 13:01 lptarik

Thanks for the suggestion but the sap_host_exporter - as far as I can see - only request soap messages from the net weaver application, where zbxdb requests SQL from the database. They are operating on different layers.

ikzelf avatar Jan 25 '22 14:01 ikzelf