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

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

book

Article ID: 9992

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/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 ( /****) 



Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Resolution

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.

***