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!

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2025 SplunkTrust is officially open! If you ...

Splunk Answers Content Calendar, June Edition II

Get ready to dive into Splunk Dashboard panels this week! We'll be tackling common questions around ...

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...