Hello,

I have problem with calling user defined function.

The function is custom defined and the function calls Java function from installed JAR.

When running functions it says about fenced user.

UPDATE EMPLOYER SET PESEL = ENCRYPT_STRING(PESEL);

Response:

SQL Error [     ]: A routine failed because the fenced user ID cannot access required files in the sqllib directory or other instance or database directories.. SQLCODE=-1646, SQLSTATE=     , DRIVER=4.35.11

i checked and jars are somewhere  in database/…/sqllib directory.

Is it permission problem ? If so what to change?

I am using Mac OS on Apple M1 chip and DB2 goes in Docker image - 12.1.

Hello,

What's the result of the following query?

SELECT IMPLEMENTATION
FROM SYSCAT.ROUTINES
WHERE ROUTINESCHEMA NOT LIKE 'SYS%' AND ROUTINENAME = 'ENCRYPT_STRING' AND ORIGIN = 'E'