How to resolve DDSDCLM program errors DDSDCC100A where the entity password is missing.

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

When running DDSDCLM to analyze the Datadictionary prior to an upgrade, many errors are possible. One is DDSDC_100A (where the _ represents different entity types), which indicates that an entity password is different from our default. Here is an example of a few of these messages:

DDSDCT100A       TABLE FIELD PASSWORD DOES NOT MATCH BASIS ( /****)                
DDSDCE100A       ELEMENT FIELD.FIELD-REQRD PASSWORD DOES NOT MATCH BASIS ( /****)  
DDSDCC100A       COLUMN (FIELD) FIELD.STATS PASSWORD DOES NOT MATCH BASIS ( /****)
DDSDCC100A       COLUMN (FIELD) FIELD.STATUS PASSWORD DOES NOT MATCH BASIS ( /****) 

Instructions:

To reset the passwords for the entities to their default, you will need to create transactions for each item, and then run them through the DDUPDATE program, followed by an HSD reset.

Because passwords are used to secure these entities, we do not want to post them publicly; please contact the support team for CA Datacom with the output of the DDSDCLM report, so that they can provide the correct transactions to resolve each of these errors.

Here is an example of transactions to correct the above messages:

-USR DATACOM-INSTALL,NEWUSER
-SET RPOF
-COM --------------------------------------------------
-COM NOTE: YOU ARE STRONGLY ENCOURAGED TO BACK UP
-COM       THE DATADICTIONARY DATABASES PRIOR TO
-COM       RUNNING THESE TRANSACTIONS
-COM --------------------------------------------------
-COM
-UPD TABLE,FIELD(PROD,,xxxxxxxx)
1000 NEWPSWD,xxxxxxxx
-END
-UPD ELEMENT,FIELD.FIELD-REQRD(PROD,,xxxxxxxx)
1000 NEWPSWD,xxxxxxxx
-END
-UPD FIELD,FIELD.STATS(PROD,,xxxxxxxx)    
1000 NEWPSWD,xxxxxxxx
-END  
-UPD FIELD,FIELD.STATUS(PROD,,xxxxxxxx)  
1000 NEWPSWD,xxxxxxxx
-END

 

Here is a sample JCL step to reset the HSD (shown for version 14.0):

//L JCLLIB ORDER=CAI.CHLQ.CUSPROC
//*-------------------------------------------------------------
//*    EXECUTE DDCFBLD TO RESET THE HSD TABLE
//*-------------------------------------------------------------
//RESETHSD EXEC PGM=DDCFBLD,REGION=6M
//     INCLUDE MEMBER=B14STLIB
//     INCLUDE MEMBER=B14DDOUT
//SYSIN   DD DISP=SHR,DSN=CAI.CHLQ.CUSMAC(USRACC)
//        DD DISP=SHR,DSN=CAI.CHLQ.CUSMAC(HSDRST)   

Additional Information:

As always, please contact CA Technologies support for CA Datacom if you have further questions.

***