By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

Can't find stored procedure - help!

P: 6
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
Share this question for a faster answer!
Share on Google+

Post your reply

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