search

ThePrez / prometheus-exporter-jdbc

Prometheus Client for IBM i
GNU General Public License v3.0
23 stars 7 forks source link

Question about "Any numeric metric available through SQL can be monitored using this client!" #37

Open AverittLogan opened 2 months ago

AverittLogan commented 2 months ago

I am wondering about this line from the README. Please forgive my ignorance on Prometheus, any info on this topic is appreciated!

"Any numeric metric available through SQL can be monitored using this client!"

We are currently trying to capture and display text/character/string data types using Prometheus. (Our use case is to get the fully qualified names of the top X jobs {job_num/user/jobname} ). Is it only possible to capture numeric data? If so, why is that? Is there any alternative way to get text information.

Thank you, Logan

krka01 commented 1 month ago

The Prometheus backend does not support non-numeric values.

For the task you try to accomplish, Prometheus is not the way to go.

One solution would be to use the QSYS2.ACTIVE_JOB_INFO() table function and forward the data to ELK, Splunk or other syslog server that support building graphs.

Another solution would be to use LPAR2RRD and the IBM i OS Agent, but you would need to setup an LPAR2RRD server on AIX or Linux: https://lpar2rrd.com/as400.php#as400-docu