Page 1 of 1

Export DB2 table to NLS

Posted: Thu Jul 07, 2016 12:38 pm
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?

Re: Export DB2 table to NLS

Posted: Thu Jul 07, 2016 12:57 pm
by hsmith
Does the DB2 server have the ability to forward logs?

Re: Export DB2 table to NLS

Posted: Thu Jul 07, 2016 1:28 pm
by Linuxlogger
The server has rsyslog running and is forwarding other logs. I just am wondering about how to extract the DB2 data.

Re: Export DB2 table to NLS

Posted: Thu Jul 07, 2016 1:30 pm
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?

Re: Export DB2 table to NLS

Posted: Thu Jul 07, 2016 1:32 pm
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