All Apps and Add-ons

Splunk DB2 connect rising option error

abhijitsaoji
Explorer

I have successfully set-up the connection with DB2 database on Z OS, there are two options Batch and Rising. Batch option is working fine however its very risky and I want to configure Rising option however it is not working. I get below error.

com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10145][10844][4.13.127] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815

any help will be highly appreciated.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What is your query? What are you using for the rising column?

---
If this reply helps you, Karma would be appreciated.
0 Karma

abhijitsaoji
Explorer

hi, thanks for your reply. My query is
SELECT *
FROM "XX01"."LOG"
WHERE EVENTTIMESTAMP > '2019-01-01 00:00:00.000'
ORDER BY EVENTTIMESTAMP ASC

I am using EVENTTIMESTAMP as rising column, it is defined as timestamp field.

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...