All Apps and Add-ons

DB Connect (almost) no new data

nipel
New Member

I'm connecting to Informix database which has dozens of new rows every minute. Rising column is startdatetime and timestamp is taken from this column as well. Execution frequency is every 60 seconds.
Initial input load seems gone well and even checkpoint works as it should. But later I get just couple of new rows per hour.
Which are the ways to troubleshoot such weird behavior?

Tags (1)
0 Karma

ivanreis
Builder

Per the db connection document, the rising column is not supported under Informix database ->
https://docs.splunk.com/Documentation/DBX/3.2.0/DeployDBX/Createandmanagedatabaseinputs#Supported_ri...

In additional here is a link to troubleshoot the db connect -> https://docs.splunk.com/Documentation/DBX/3.2.0/DeployDBX/Troubleshooting#DB_Connect_logging

0 Karma