Logstash read from database table

Sometimes logs are save to database during runtime; and most of the time there are data that can be used to get status of the transaction saved in the table. Below is the sample Logtash database connection configuration that connects to IBMi DB2 for i.


input
{

jdbc{
jdbc_connection_string => "jdbc:as400://{HOSTNAME}"
jdbc_user => "{DB_USERNAME}"
jdbc_password => "{DB_PASSWORD}"
jdbc_driver_library => "/JT400DIR/jt400-6.7.jar"
jdbc_driver_class => "com.ibm.as400.access.AS400JDBCDriver"
schedule => "1 * * * *"
statement => "SELECT * FROM {DB_TABLE_NAME}"
}
}