Monitoring Splunk

How can Splunk help in DB2 database troubleshooting, performance monitoring and tuning tasks and reporting?

kovthe
Engager

Hi,

Can splunk be used as a tool to assist in DB2 database troubleshooting,performance monitoring and tuning tasks and reporting?
What are the different ways in which Splunk can help is a SAP implementation on DB2 environment?

Regards
Kovthe

Tags (2)

dwaddle
SplunkTrust
SplunkTrust

Yes, assuming you can get the data OUT of DB2 in a meaningful/useful format. Splunk is not purpose-built for this job (like say the Optim Database Performance tools), but it can be made to do this.

One of the applications I support (NOT SAP) using Splunk has an application-level log of SQL statements issued and the amount of time they take (yes, this is a lot of data - most of our license volume). We have been able to use this to drive many different application performance troubleshooting scenarios involving slow DB2 queries. Note this is an application-level function and not a DB2 facility specifically.

One specific ways you might be able to use Splunk (and the DB Connect app) to help understand DB2 performance is to use the DB2 snapshot tables/views. DB2 provides a very nice facility for accessing some of its internal snapshot state by doing SQL against some administrative views. See http://www-01.ibm.com/support/knowledgecenter/api/content/SSEPGG_9.7.0/com.ibm.db2.luw.admin.mon.doc... . It would not be difficult to have Splunk do a periodic capture of these, index them, and use it to gain insights.

This is a case where I am not aware of any pre-built Splunk app for DB2, so you would have to spend a lot of energy on this yourself. Whether or not that is better or worse than finding/buying a tool specific to database performance is entirely situation dependent.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...