I try to run one user define function on db2 zos.
this function is one of the sample db2 function on dsn710.sdsnsamp.
when i try to run this function i got following message:
DSNT408I SQLCODE = -444, ERROR: USER PROGRAM DSN8DUTI COULD NOT BE FOUND
DSNT418I SQLSTATE = 42724 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
I checked sysibm.sysrutins it was ok and extername was correct.
This error can also occur if you are invoking a WLM-managed stored
procedure that is not APF authorized, and the DB2 load libraries are not
in the STEPLIB concatenation because they are being loaded from LINKLIST.
In this case, if you want the stored procedure program to run
APF-authorized, link-edit it with AC=1 into an MVS APF authorized library.
If you do not want the stored procedure program to run APF authorized, add
the DB2 load library to the STEPLIB concatenation of the JCL used to start
the WLM-managed address space.
Make sure your WLM JCL concatenated with the right step libs in your shop.