CA Tuesday Tip: (CA IDMS) Loading subschemas from dictionary load area in batch - DB347003 or 1474

Discussion created by Eddy_G Employee on Aug 5, 2014
Latest reply on Aug 5, 2014 by Eddy_G

CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for August 5, 2014


If you are trying to load subschemas from the dictionary load area in batch you  may sometimes see error message DB347003 subschema not found or error status 1474. In batch you need to specify the dictionary name in the DICTNAME parameter in the SYSIDMS DD statement.You also need to make sure LOADAREA=OFF is not specified, it defaults to ON.


The reason for getting a DB347003/1474 is that user profiles are processed in batch if the #SECRTT  specifies USRPROF=(USER,ON). The user profile may specify a different dictionary name to the one in SYSIDMS and will override it. To resolve this situation you also need to specify USERCAT=OFF in SYSIDMS so that user profiles are not processed.