RELOAD job may abend with a 1474

Document ID : KB000012817
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

An UNLOAD/RELOAD of a user database fails during the RELOAD step.

The job abends during execution of IDMSDBL2.

The SYSLST file contains following messages :

UT010002 BEGINNING PROCESSING FOR STEP SORT1
UT009001 IDMSDBLY RELEASE 18.5 TAPE GJI50B SORT STARTED
UT009002    58,070 RECORDS WERE READ FROM SYS002
UT009004 IDMSDBLY RELEASE 18.5 SORT COMPLETED SUCCESSFULLY
UT010003 STEP SORT1    HAS COMPLETED SUCCESSFULLY
UT010002 BEGINNING PROCESSING FOR STEP IDMSDBL2
UT005001 IDMSDBL2 RELEASE 18.5 TAPE GJI50B PROCESSING STARTED
         PROGRAM NAME ----- IDMSDBL2
         ERROR STATUS ----- 1474

The Jeslog of the job also contains the following error message :

DB347003 SUBSB001 subschema not found

 

Question:

What can be the cause of this error ?

Environment:
IBM z/OS, z/VSE, z/VM
Answer:

The RELOAD step requires a subschema which describes the database structures of the database to be reloaded.

The subschema load module must be available in the RELOAD step.

Such load module resides in the DDLDCLOD area of a dictionary or (after being punched and link edited) in a load library. At least one of these must be accessible in the RELOAD step.

In this particular case, the subschema load module was not punched/link edited, and the DMCL used for the RELOAD did NOT include the dictionary segment in which the subschema load module resided, hence the 1474 / DB347003.

Solution :

a) include the dictionary segment into the Reload DMCL

b) punch and link edit the subschema load module and ensure that the load library is defined in the STEPLIB concatenation of the RELOAD job.

 

Additional Information:

Another Knowledge document concerning UNLOAD/RELOAD is  TEC490767 and can be found using following url :

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec490767.html