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 ( /****)
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)
As always, please contact CA Technologies support for CA Datacom if you have further questions.
***