Export DB2 table to NLS

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
Linuxlogger
Posts: 32
Joined: Thu Jun 23, 2016 4:33 pm

Export DB2 table to NLS

Post by Linuxlogger »

I have a db2 database. Can I log the transaction/trace log to NLS directly or do I have to export it as a csv then export that?
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Export DB2 table to NLS

Post by hsmith »

Does the DB2 server have the ability to forward logs?
Former Nagios Employee.
me.
Top
Linuxlogger
Posts: 32
Joined: Thu Jun 23, 2016 4:33 pm

Re: Export DB2 table to NLS

Post by Linuxlogger »

The server has rsyslog running and is forwarding other logs. I just am wondering about how to extract the DB2 data.
Top
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Export DB2 table to NLS

Post by rkennedy »

Does the DB2 machine log it's DB2 logs to the same output for your messages, or does it have a log file of it's own?
Former Nagios Employee
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Export DB2 table to NLS

Post by hsmith »

We don't have anything here running DB2 for me to test against, but I found a couple of articles that might be helpful.

https://www.elastic.co/guide/en/logstas ... -jdbc.html
https://www.elastic.co/blog/logstash-jdbc-input-plugin
https://discuss.elastic.co/t/logstash-a ... es/39042/4
Former Nagios Employee.
me.
Top
Locked

Return to “Nagios Log Server”