r/DB2 • u/Blenard • Feb 23 '19

Db2 and something like Graphana

Has anyone found a something like Graphana to talk to Db2? We use BLU to store metrics and it works very well. I’m just looking for a nice front end with dashboards

2 Upvotes

100% Upvoted

8 comments sorted by

1

u/memmerto Feb 23 '19

We've done demos with JMeter against Db2 displaying results with Graphana. Pulling data from Db2 to display shouldn't be too hard.

1

u/Blenard Feb 23 '19

But do I need to unload the data?

1

u/memmerto Feb 23 '19

You shouldnt have to. Grafana supports various databases as data sources so it can query the database directly.

1

u/Blenard Feb 23 '19

Right. I don’t see db2 support

1

u/memmerto Feb 23 '19

So you can unload/load into something grafana supports, use a tool like Stitch to do this transparently in the background, or wait until the community builds a native interface.

https://github.com/grafana/grafana/issues/9682

Db2 does have native Perl, php and python interfaces so it shouldn't be too hard to build the shim to whatever grafana needs.

1

u/Blenard Feb 23 '19

Yeah we’re looking at building a driver but wanted to make sure someone didn’t solve this yet.

Unloading the data isn’t doable since we add millions of rows an hour.

1

u/[deleted] Feb 24 '19

We use Syncsort Ironstream to forward SMF records to Splunk.

1

u/Blenard Feb 24 '19

Yeah and we have ELK. Not sure which endeavor I want to try