When trying execute runstats through the product, the following message is generated: ERROR [38503] [IBM][DB2] SQL0430N .
User defined function "PROCEDURE" (specific name "SYSPROC.DSNUTILU") has abnormally terminated. The procedure is in stopabn status. Starting the procedure again and generates the same error when executing runstat again.
Looking into DB2SYSDW started task WLM and generates an 0C1 when the runstats executes. The procedures were created with the WLM environment of DB2SYSDW.
There is high likelihood that the JCL does not have a SYSIN dataset defined. This is not the correct JCL to be used in the WLM address space for SYSPROC.DSNUTILU.
The JCL and SYSLOG may provide the answer.
The following advice has been suggested:
Look at the JCL that is used to run the WLM address space (DB2SYSDW) and any console messages that may occur when this address space amends.
One should consult their Systems Programmer to review the JCL in installation member DSNTIJMV. This contains the correct templates to be used for the DSNWLM_UTILS (DSNWLMU) JCL that is generated in that member. This JCL does not correspond correctly to that as it contains no SYSIN or SYSPRINT DD statements. Involve one’s systems programmer as one’s JCL seems more suited for a Java WLM rather than a Utilities WLM.
The attached attachment, ukxpwlmu.jcl, (which is our JCL used for the Utility WLM) can serve as a correct template.
