IDMS

Back to discussions
Expand all | Collapse all

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

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

    Broadcom Employee
    Posted Aug 04, 2014 09:35 PM

    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.



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

    Broadcom Employee
    Posted Aug 05, 2014 06:12 PM

    I need to correct my previous post. The #SECRTT USRPROF parameter only applies to to batch jobs running under CV. For local mode jobs user profiles are always processed.

    In any case, if you get a DB347003/1474 error then try it with USERCAT=OFF.