We keep getting a sysfun.right error during processing when a stored procedure runs in our DB2 UDB 7.2 FP6 database on AIX 5.2L (both 32 bit) as follows:

SQL0444N Routine "SYSFUN.RIGHT" (specific name "SQL0105151325") is implemented with code in library or path "...sqllib/function/db2clifn", function "CLI_udfRIGHT1" which cannot be accessed. Reason code: "9". SQLSTATE=42724


Data TitleQLCA PID:112978 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -444 sqlerrml: 70
sqlerrmc: SYSFUN.RIGHT SQL0105151325 ...sqllib/function/db2clifn CLI_udfRIGHT1
9
sqlerrp : sqlriuld
sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Does anyone have any suggestions on how to resolve this problem with the stored procedure? Thanks!

Scott

User Response: Given for each reason code:
.....

9 There was insufficient memory to
resolve the function name
function-code-id in the library identified
in library-or-path. Contact the routine
creator or your database administrator
to make sure the library containing the
function was correctly linked. The
system configuration may need to be
changed to make more memory
available to DB2 Server.

I checked the memory parameters in DB2 and reset the process and it ran fine. Thanks for the help

-scott

I have the same Problem with AIX5.2 and DB2 7.2.8.
The Problem occurs only sometimes. If I use functions like replace or mod.
When I restart the SQL mostly it runs correct.

I thing some of the Memory Parameters have to change. can anyone help me which one ???

We solved this problem by changing the BUFFERPOOL size and several of the database instance parameters for shared memory.