search cancel

How to resolve DDSDCLM messages DDSDCE001W and DDSDCT009W

book

Article ID: 42238

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

Question: 

While preparing to upgrade my CA Datacom environment, I applied all the latest maintenance. After verifying everything, I ran the DDSDCLM program to analyze my Datadictionary. How do I resolve the many DDSDCE001W and DDSDCT009W messages?

Answer: 

In this case, there are many pairs of the DDSDCE001W and DDSDCT009W messages. Here is a sample of the output:

DDSDCE001W       ELEMENT AGGREGATE.AGR-FULL NOT IN BASIS
DDSDCT009W       TABLE AGGREGATE NUMBER OF ELEMENTS IS GREATER THAN THE BASIS (004/003)
DDSDCE001W       ELEMENT ALIAS.ALIAS-FULL NOT IN BASIS
DDSDCT009W       TABLE ALIAS NUMBER OF ELEMENTS IS GREATER THAN THE BASIS (004/003)
DDSDCE001W       ELEMENT AREA.AREA-FULL NOT IN BASIS
DDSDCT009W       TABLE AREA NUMBER OF ELEMENTS IS GREATER THAN THE BASIS (004/003)
. . .

These messages indicate that an additional element was defined for the listed Datadictionary tables by the client, and not as part of a standard CA Datacom upgrade process.

In general, these user-defined entities will not affect the upgrade, but since the upgrade is not aware of them, the client needs to review these entities following the upgrade to determine if they will need to be changed (if elements have fields added or moved, etc.).

Specifically, DDSDCE001W says that the listed element (AGR-FULL in table Aggregate, for example) was not found in the model definition provided for this release level. This usually means that someone at the client added this element to the Datadictionary table, most often for internal query or reporting usage.

Then, the DDSDCT009W message indicates that for the listed table, there were more elements found in Datadictionary than were in the model definition. This should be expected when the above DDSDCE001W message is received.

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

 

Environment

Release:
Component: DB