CA Datacom DB01314E NEWCOPY SQL external procedure

book

Article ID: 188303

calendar_today

Updated On:

Products

Datacom DATACOM - AD Datacom/DB INFOCAI MAINTENANCE

Issue/Introduction

CA 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

Release : 15.1

Component : CA DATACOM/DB

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.