How to resolve DDSDCLM messages DDSDCE001W and DDSDCT009W

Products

• Datacom
• DATACOM - AD
• Datacom/DB
• Datacom/AD

Issue/Introduction

While preparing to upgrade my 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?

 

Resolution

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 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.