I want to monitor our exception table via logstash. but I have got this error.
[2018-02-07T15:43:11,344][ERROR][org.logstash.beats.BeatsHandler] Exception: Connection reset by peer
[2018-02-07T15:44:00,478][INFO ][logstash.inputs.jdbc ] (0.161000s) SELECT * FROM EXCEPTION
here is my logstash configure:
jdbc {
jdbc_driver_library => "etc/logstash/lib/db2jcc4.jar"
jdbc_driver_class => "com.ibm.db2.jcc.DB2Driver"
jdbc_connection_string => "jdbc:db2://ip:port/db"
jdbc_user => "usr"
jdbc_password => "pass"
schedule => "* * * * *"
statement => "SELECT * FROM EXCEPTION"
type => "EXCEPTION"
}
I really appreciate it if anyone can help me. thank you