Meaning of Message DDPKY20001

Document ID : KB000012922
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Customer is testing new functionality APPLYCXX transaction to delete a Key and getting an undocumented message.

Question:

Error message received:

"DDPKY20001 ATTEMPT MUF DLT KEY-USAGE NOT N FGAKA" is not documented.

 

Environment:
z/os - CA Datacom/DB 15.1
Answer:

Messages and Codes 


---DSF Return Codes 

KY1 - ATTEMPT MUF BLD/DLT MSTR/NAT KEY 
Reason: 
You attempted to build or delete an index in MUF (APPLYCXX) but the KEY occurrence has a value of “Y” for the MASTER-KEY and/or NATIVE-KEY attribute(s). 
Action: 
The APPLYCXX function cannot be used to build or delete an index for a KEY occurrence that has the MASTER-KEY and/or NATIVE-KEY attributes with a value of “Y”. 

KY2 - ATTEMPT MUF DLT KEY-USAGE NOT N 
Reason: 
You attempted to delete an index in MUF (APPLYCXX) but the KEY occurrence has a value other than “N” for the KEY-USAGE attribute. 
Action: 
The APPLYCXX function cannot be used to delete an index for a KEY occurrence that has the KEY-USAAGE attribute with a value other than “N” (no access). 

KY3 - ATTEMPT MUF DLT CONSTRAINT KEY 
Reason: 
You attempted to delete an index in MUF (APPLYCXX) but the KEY occurrence is one which is used in an SQL Constraint. 
Action: 
The APPLYCXX function cannot be used to build or delete an index for a KEY occurrence that is used in an SQL Constraint. 

--- Batch Messages 
DDPKY10001 - ATTEMPT MUF BLD/DLT MSTR/NAT KEY 
Reason: 
You attempted to build or delete an index in MUF (APPLYCXX) but the KEY occurrence has a value of “Y” for the MASTER-KEY and/or NATIVE-KEY attribute(s). 
Action: 
The APPLYCXX function cannot be used to build or delete an index for a KEY occurrence that has the MASTER-KEY and/or NATIVE-KEY attributes with a value of “Y”. 

DDPKY20001 - ATTEMPT MUF DLT KEY-USAGE NOT N 
Reason: 
You attempted to delete an index in MUF (APPLYCXX) but the KEY occurrence has a value other than “N” for the KEY-USAGE attribute. 
Action: 
The APPLYCXX function cannot be used to delete an index for a KEY occurrence that has the KEY-USAAGE attribute with a value other than “N” (no access). 

DDPKY30001 - ATTEMPT MUF DLT CONSTRAINT KEY 
Reason: 
You attempted to delete an index in MUF (APPLYCXX) but the KEY occurrence is one which is used in an SQL Constraint. 
Action: 
The APPLYCXX function cannot be used to build or delete an index for a KEY occurrence that is used in an SQL Constraint.

Additional Information:

These messages are now documented in Docops at:

 https://docops.ca.com/ca-datacom/15-1/en