I am trying to debug a database input I created to pull from a JDBC compliant DB. I set it up as a Tail so it pulls records incrementally. I need to see the SQL statements that this input is generated automatically. Is there a log file of some sort that captures the SQL statements? I tried looking in the _internal index and nothing is coming up. Thanks!
Have you taken a look at: http://docs.splunk.com/Documentation/DBX/2.1.0/DeployDBX/Troubleshooting#What_DB_Connect_logs
Looks like it should be enabled by default, but you'll want to verify dbx_logging.conf