DDPSV20001 COPYing a database to PROD status, also DDVKEY0017 and DDWKEY0008

Products

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

Issue/Introduction

After adding a new field to a table and to one of its keys, the Copy to Prod-status function (-CPY DATABASE xxxxxxxx(T001),PROD) fails with these error messages:

DDPSV20001 STRUCTURE VERIFY FAILED
DDVKEY0017 UNEQUAL MAX-KEY-LENGTHS FOR SAME DATACOM-ID
DDWKEY0008 WARNING MIXED FLD TYPES FOR DATACOM-ID

Environment

Release: All supported releases.

Cause

While there could be many reasons for a Database structure to fail verification, in this case, since a field was added to a table and key, the focus should be on the key definition. Here, the messages about “SAME DATACOM-ID” give a clue that there could be a problem with a Shared Key definition.

Resolution

When multiple keys have the same DATACOM-ID (also called Shared KeyIDs), there are certain considerations and restrictions about how these keys are defined.

If the intention is for these keys to be shared, further analysis of the key definitions must be made to ensure they are correct and meet the restrictions.

If these keys are not shared, the errors can be resolved by changing the DATACOM-ID of the key that is modified in this project, and repeating the process to update and copy it to production status.

Additional Information

Using the same Datacom-ID for different keys defined in different tables in a database
Designing Keys