DB2 SQL-Error: -443
SQLState: 42724
Short Description: ROUTINE SPECIFIC NAME HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT C E SQL USER PROGRAM COULD NOT BE FOUND
An SQLSTATE of the form 38xxx was returned by routine routine-name, along with message text msg-text. If the third character is not 5 (for example, Â’385xxÂ’) then the last 3 characters of the SQLSTATE value were chosen by the function to indicate the reason of the failure. SQLSTATEs values of the form 385xx are issued by IBM with a different SQLCODE. System action: Execution of the SQL statement is terminated. Programmer response: Contact the author of the function or your database administrator. Until the problem is resolved, the function should not be used. SQLSTATE: 38xxx (the SQLSTATE that was returned by the routine). Explanation: DB2 received an SQL CALL statement for a stored procedure or an SQL statement containing an invocation of a user-defined function, and found the row in the SYSIBM.SYSROUTINES catalog table associated with the requested procedure name. However, the MVS load module identified in the EXTERNAL_NAME column of the SYSIBM.SYSROUTINES row could not be found. name The name of the MVS load module that could not be foundSystem action: The statement cannot be executed. Programmer response: If the EXTERNAL_NAME column value in the SYSIBM.SYSROUTINES table is incorrect, use the ALTER FUNCTION or ALTER PROCEDURE statement to correct the value. If the EXTERNAL_NAME column value is correct, use the MVS linkage editor to create the required MVS load module in one of the MVS load libraries used by your installation for stored procedures. 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.