I'm using DB2 v8.1 on Linux.
I'm busy writing UDF's in Java.
Following things works fine:
I make a class-file put in the folder sqllib/function, excecute the query:
CREATE FUNCTION test(a Int) RETURNS Int EXTERNAL NAME 'udfs.multiply' LANGUAGE JAVA PARAMETER STYLE java NO SQL
When I test the function, he does what I expect it to do, so far no problem, but when I want to change the class file to update the function, just replacing te class file in the sqllib/function directory is not enough. Even when I drop the function test and create it again, he stills works with the function written in the first created class-file.
When I stop the database (db2stop) and start it again, and then create the function test again, then he takes the updated function in the new class file, but I don't like thus method.
How can I become the same result, without having to restart the database?