in C and compiled to a shared library, which has been placed in the
<DB2 dir>/functions directory. The platform is Solaris.
From the debug log it seems that the stored procedure can't be found,
although I don't know why. Using the control centre, I can see that the
procedure name is defined in the database, however it can not be
invoked.
Can anyone shed any light on what could be causing this problem, or
suggest anything for further investigation?
The procedure is being invoked from Java code via JDBC, if that has any
bearing on the problem.
2006-05-30-10.18.45.800290+000 I291952C399 LEVEL: Severe
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRoutineResolveAddress,
probe:10
RETCODE : ZRC=0x870F0038=-2029060040=SQLO_PROC_NOT_FOUND "Stored Proc
Not Found"
DIA1002C Error accessing function "" in library "".
2006-05-30-10.18.45.825335+000 I292352C399 LEVEL: Warning
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
MESSAGE : sqlerRoutineLoad (-444): input string ...
DATA #1 : Hexdump, 28 bytes
0x00072DFA : 7373 6F6C 6974 6521 7373 6F6C 6974 655F
ssolite!ssolite_
0x00072E0A : 6765 745F 7365 7175 656E 6365 get_sequence
2006-05-30-10.18.45.825917+000 I292752C331 LEVEL: Warning
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
MESSAGE : sqlerRoutineLoad (-444): instance name ...
DATA #1 : Hexdump, 16 bytes
0x00072BB2 : 5357 5F47 4554 5F53 4551 5F54 5241 4E53
SW_GET_SEQ_TRANS
2006-05-30-10.18.45.826401+000 I293084C466 LEVEL: Warning
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
MESSAGE : sqlerRoutineLoad (-444): resolved path ...
DATA #1 : Hexdump, 37 bytes
0x00072E28 : 2F65 7870 6F72 742F 686F 6D65 2F64 6232
/export/home/db2
0x00072E38 : 696E 7374 332F 7371 6C6C 6962 2F66 756E
inst3/sqllib/fun
0x00072E48 : 6374 696F 6E ction
2006-05-30-10.18.45.826955+000 I293551C323 LEVEL: Warning
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
MESSAGE : sqlerRoutineLoad (-444): resolved module ...
DATA #1 : Hexdump, 7 bytes
0x00072E50 : 7373 6F6C 6974 65 ssolite
2006-05-30-10.18.45.827417+000 I293875C396 LEVEL: Warning
PID : 4204 TID : 7 PROC : db2fmp (C) 0
INSTANCE: db2inst3 NODE : 000
MESSAGE : sqlerRoutineLoad (-444): resolved function ...
DATA #1 : Hexdump, 20 bytes
0x00072E60 : 7373 6F6C 6974 655F 6765 745F 7365 7175
ssolite_get_sequ
0x00072E70 : 656E 6365 ence