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
What can be the cause of this error ?
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.