DB - UDB V8.1 on AIX

I have got 2 users in my db. One is the instance owner (A) other (B) has got dbadm on the db.

If I register an UDF under B and then compile it I am still having to keep the executable under - home of A/sqllib/function though in my .profile for the user B DB_FUNCTION_BIN is set to - home of B/sqllib/function/

Can anyone tell me what needs to be done so that I can keep the executable under home of B/sqllib/function/ instead of having to keep the executables under the instance owner.

hmmm ... Try adding B/sqllib/function to the PATH in your .profile

Not sure if this will work, just a try

Cheers
Sathyaram