DDPSV20001 error with a COPY of a Database to PROD status, also with messages DDVKEY0017 and DDWKEY0008

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

Issue

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

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:

For more information about using Shared DATACOM-ID values (Shared Keys), please refer to Knowledge Base document TEC1081311, with the title "Can I use the same Datacom-ID for different keys defined in different tables in my database?"

For more information about designing Keys, please refer to the following Guides:

CA Datacom/DB Version 14.02 Database and System Administration Guide, in the section “Designing Keys”
CA Datacom/DB Version 15.00 Database and System Administration Guide, in the section “Designing Keys”

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

Environment

Release:
Component: DB