SQLCODE=-901, SQLSTATE=58004, SQLERRMC=index on expression package not found!

[grahamutrc]

Hi,
I'm running DB2 LUW 10.5 on Linux with DB2_COMPATIBILITY_VECTOR=ORA and am haing trouble executing DML from our java application. This error comes up for most statements.

17:26:09.370 [calculationScheduler_Worker-1] WARN c.v.i.c.s.s.s.QuartzMonitorImpl - Quartz Job: CALCULATION_JOB_CALCULATION_GROUP completed but exception occurred, Exception message: Exception encountered will running settlement position CalculationJob for settlement cycle : PreparedStatementCallback; SQL [

UPDATE t_transaction pay
SET batch_id = 123
WHERE TRUNC(pay.actual_settlement_date) = TO_DATE('2014-11-11','yyyy-MM-dd')
AND pay.settling_currency_code = 123
AND pay.actual_settlement_cycle = 12;


]; DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=index on expression package not found!, DRIVER=4.19.26; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=index on expression package not found!, DRIVER=4.19.26

--- And in the db2diag.log:

2015-11-09-11.25.13.718794-300 I1669004E927 LEVEL: Severe
PID : 2687 TID : 139787138754304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IPSDB2
APPHDL : 0-3336 APPID: 172.17.106.236.6738.151109162508
AUTHID : DB2INST1 HOSTNAME: ip-10-106-4-208.localdomain
EDUID : 473 EDUNAME: db2agent (IPSDB2) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 38
sqlerrmc: index on expression package not found!
sqlerrp : SQLRA1D3
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFEC51 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)

Any ideas?

[CRPence]

On 11-Nov-2015 10:23 -0600, grahamutrc wrote:
> <<SNIP>> DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=index
> on expression package not found! <<SNIP>> Any ideas?

Report the issue to your service provider; as I suggested so very
recently, with an attempt at explaining the same code\state [but
different associated text], here:
[https://groups.google.com/d/msg/comp.databases.ibm-db2/pkcMezTewbw/J7Xd9Z7BBgAJ]

--
Regards, Chuck

[grahamutrc]

Thanks, Chuck. We're still getting our support arrangements sorted out, so in the meantime I was hoping that this was something obvious. Clearly not!

[CRPence]

On 16-Nov-2015 03:38 -0600, grahamutrc wrote:
> <<SNIP>> so in the meantime I was hoping that this was something
> obvious. Clearly not!

Merely as a SWAG: I would expect possibly, that the implication of
the failure reflects that the database is missing the definition of an
INDEX that is expected to have been defined previously as:

create index index_name
on t_transaction
( TRUNC(actual_settlement_date) )

--
Regards, Chuck