Hi All,
db2 v8.2.3 and aix 5.2 and compiler is 6.0.0

Recently we convert our box (server) from 32 bit to 64 bit and then we compiled UDF in 64 library and created new module and put in /home/v8i2/sqllib/fuction library. when I try to use UDF I get error:

SQL0444N Routine "USER1.FUN" (specific name "FUN") is implemented with
code in library or path ".../sqllib/function/cbfun1", function "fun" which
cannot be accessed. Reason code: "4". SQLSTATE=42724

have I missed something? your help really appriciated.

has todo with ld_library_path and ld_library_path_64
have a look at infocenter : there is a chapter on this
serach on ld_library_path and check..