1. Background on what happened to prod.

We have received -450 error while executing the UDF function against CLAIM BLOBS that are greater than 5 MB in size. Per below error explanation we need to check whether we need to make any code changes or UDF setting changes to increase maximum length of the parameter to prevent overlay of storage.

1. What error was received

-450 USER-DEFINED FUNCTION OR STORED PROCEDURE name, PARAMETER NUMBER parmnum, OVERLAYED STORAGE BEYOND ITS DECLARED LENGTH.

Explanation

Upon return from a specific function name or a stored procedure name, DB2® has detected an overlay storage beyond a parameter's declared length. The parameter number is specified for a stored procedure or function. This is not permitted.

System action

Execution of the SQL statement is terminated.

Programmer response

Contact the author of the function or your database administrator. Until it is fixed, the function should not be used.

1. We would also like to know what maximum Java heap size should be set for the Java WLM environment if the UDF blob max size is changed from 5 MB to 50 MB. Current setting of Java WLM is “Min 128m Max 1024M”