Datacom DB01314E NEWCOPY SQL external procedure
Article ID: 188303
Updated On:
Products
Issue/Introduction
Datacom NEWCOPY command for an SQL external procedure fails with error:
DB01311I - NEWCOPY proc_name
DB01335I - CONSOLE SCHEDULED - NEWCOPY proc_name
DB01314E - NEWCOPY proc_name ERROR NOT IN LIST
The load module is in a load library included in the STEPLIB.
Environment
z/OS
Resolution
The NEWCOPY command can be used to load a SQL external procedure but only if it has been loaded before, otherwise it will fail with the DB01314E error.
The procedure can be loaded from the NEWCOPY DD statement in the MUF or from the STEPLIB. The NEWCOPY DD is optional but recommended. It is explained in the NEWCOPY documentation:
The NEWCOPY function allows you to replace procedures or modules within the MUF (MUF) without recycling the MUF. This means that critical solutions can be applied to a working system without any downtime. Request the NEWCOPY function by using a NEWCOPY console command.
In z/OS, the NEWCOPY process first looks to see if the MUF has a DD statement for NEWCOPY. If a DD statement for NEWCOPY is not present, the load occurs using the STEPLIB or JOBLIB. This is usually not a problem, but if the module was replaced in the library and caused the library to be extended, the NEWCOPY LOAD fails because the STEPLIB or JOBLIB are opened at execution and do not have the new extent opened. Because of this condition, we recommended that every MUF execution JCL include a NEWCOPY DD statement that points to the library set that contains every module that is eligible for NEWCOPY.
Feedback
