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

kovthe — Wed, 12 Nov 2014 13:52:09 GMT

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

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

dwaddle — Wed, 12 Nov 2014 14:45:43 GMT

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/doc/r0006117.html?locale=en . 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.

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

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

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