Datacom DB01314E NEWCOPY SQL external procedure
search cancel

Datacom DB01314E NEWCOPY SQL external procedure

book

Article ID: 188303

calendar_today

Updated On:

Products

Datacom Datacom/DB Datacom/AD

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.