468,301 Members | 1,554 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

Can't find stored procedure - help!

I'm trying to invoke a DB2 stored procedure. The stored proc is coded
in C and compiled to a shared library, which has been placed in the
<DB2 dir>/functions directory. The platform is Linux (using 64 bit DB2 UDB).
From the debug log it seems that the stored procedure can't be found,
although I don't know why. 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?

Here is the output :

2007-12-07-23.49.45.651049+000 I12584724E396 LEVEL: Severe
PID : 7075 TID : 47586765438720PROC : db2fmp
INSTANCE: db2inst1 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 "".

2007-12-07-23.49.45.651595+000 E12585121G592 LEVEL: Error (OS)
PID : 7077 TID : 4138646016 PROC : db2fmp32
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: EILSEQ (84)
DATA #1 : Library name or path, 41 bytes
/home/db2inst1/sqllib/function/RCheck
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
0
DATA #3 : String, 100 bytes
/home/db2inst1/sqllib/function/RCheck: cannot open shared object file: No such file or directory

2007-12-07-23.49.45.652163+000 I12585714E396 LEVEL: Severe
PID : 7075 TID : 47586765438720PROC : db2fmp
INSTANCE: db2inst1 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 "".

2007-12-07-23.49.45.652383+000 E12586111G592 LEVEL: Error (OS)
PID : 7077 TID : 4138646016 PROC : db2fmp32
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: EILSEQ (84)
DATA #1 : Library name or path, 41 bytes
/home/db2inst1/sqllib/function/RCheck
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
0
DATA #3 : String, 100 bytes
/home/db2inst1/sqllib/function/RCheck: cannot open shared object file: No such file or directory
Dec 8 '07 #1
0 1913

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Timppa | last post: by
6 posts views Thread by betbubble | last post: by
1 post views Thread by peaceburn | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.