1474 DB347003 subschema not found in JOB14
search cancel

1474 DB347003 subschema not found in JOB14

book

Article ID: 44023

calendar_today

Updated On:

Products

IDMS

Issue/Introduction

Step EMPLOAD in Job14 gets a 1474 error-status with DB347003.

Environment

Release: All supported releases.

Cause

Step EMPLOAD in Job14 executes IDMSDMLC to pre-compile COBOL program EMPLOAD. This requires access to the schema EMPSCHM V 100 and subschema EMPSS01. The dictionary segment for these components defaults to APPLDICT. By default, the configuration process will define these in APPLDICT, and will specify APPLDICT as the system default dictionary in the DBTable. For sites where these components for the EMPDEMO database are loaded into a different dictionary, or where the DBTable specifies something other than APPLDICT as the system default dictionary, step EMPLOAD will fail with DB347003 / 1474.

Resolution

To avoid this DB347003 / 1474 error in step EMPLOAD of Job14, alter the SYSIDMS DD statement in that step to include a DICTNAME parameter which specifies the dictionary which contains the EMPSCHM V 100 schema and EMPSS01 subschema. If the installation defaults were taken and these are installed in APPLDICT, that means coding DICTNAME=APPLDICT in the SYSIDMS for this step. Alternatively, another way to avoid the error is to alter the DBtable to specify this dictionary as the system default.