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

book

Article ID: 35379

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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