# Logstash-IBM DB2-Reporting **URL:** \ **Category:** Logstash\ **Created:** [April 19, 2017, 10:56pm UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961 "2017-04-19T22:56:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![senthilyes](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@senthilyes](https://discuss.elastic.co/u/senthilyes)\ **Post date:** [April 19, 2017, 10:56pm UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/1 "2017-04-19T22:56:06Z")
Hi We got a usecase for message queue reporting requirements. Out application systems use IBM MQ for messaging services and data is stored in IBM DB2 database. We need to generate reports out of DB2 database eg. 4. Weekly Queue Statistics Report, Monthly Queue report etc. Is it possible to connect from logstash to IBM DB2 database to accomplish our requirements? Will it make sense to let logstash directly talk to IBM MQ to generate reports? Please provide your comments. Thanks. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [April 19, 2017, 11:56pm UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/2 "2017-04-19T23:56:04Z")
Can you use JDBC with DB2? ---
**Author:** ![senthilyes](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@senthilyes](https://discuss.elastic.co/u/senthilyes)\ **Post date:** [April 20, 2017, 3:26am UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/3 "2017-04-20T03:26:51Z")
Hi Mark Thanks for the input. I see some threads referring some issues in connecting to DB2 from logstash. Do you have any pointers for the logstash talking to DB2 and push to Elastic search. Finally reports are generated and viewed through Kibana. Regards Senthil ---
**Author:** ![senthilyes](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@senthilyes](https://discuss.elastic.co/u/senthilyes)\ **Post date:** [April 20, 2017, 3:28am UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/4 "2017-04-20T03:28:04Z")
Hi Mark Thanks for the input. I see some threads referring some issues in connecting to DB2 from logstash. Do you have any pointers / references for the logstash talking to DB2 and push to Elastic search. Finally reports are generated and viewed through Kibana. Regards Senthil ---
**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\ **Post date:** [April 20, 2017, 6:15am UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/5 "2017-04-20T06:15:26Z")
> I see some threads referring some issues in connecting to DB2 from logstash. Do you have any pointers / references for the logstash talking to DB2 and push to Elastic search. I'd expect the jdbc input to work just fine for this. > Finally reports are generated and viewed through Kibana. Yes. ---
**Author:** ![senthilyes](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@senthilyes](https://discuss.elastic.co/u/senthilyes)\ **Post date:** [April 20, 2017, 12:05pm UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/6 "2017-04-20T12:05:24Z")
Thanks Magnus for the clarification. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 18, 2017, 12:06pm UTC](https://discuss.elastic.co/t/logstash-ibm-db2-reporting/82961/7 "2017-05-18T12:06:40Z")
Closed on May 18, 2017, 12:06pm UTC This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.