DDWKEY0013 on DDCFBLD on DDD database CA Datacom/DB Version 15.0 upgrade job BDUPG06 STEP6C

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

Question:

Running -CXX BUILD,DATABASE,DDD-DATABASE(PROD,DD,PRIV) in STEP6C of BDUPG06 during the latest CA Datacom/DB VERsion 14.0. to 15.0 upgrade,  I received these warning messages: 

*** VERIFY WARNING MESSAGES *** 
DDWKEY0013 SIGNED NUMERIC FIELD IN KEY 
ENTITY=SYSCONSTROBJ.RAAT-KEY 
DDWKEY0013 SIGNED NUMERIC FIELD IN KEY 
ENTITY=SYSCONSTROBJ.SQLNAME-KEY 
DDWKEY0013 SIGNED NUMERIC FIELD IN KEY 
ENTITY=SYSCONSTRSRC.SOURCE-KEY 
DDWKEY0013 SIGNED NUMERIC FIELD IN KEY 
ENTITY=MSG-TABLE.MSGKY

Is this something expected or is this something I should be concerned?

 

Answer:

The DDWKEY0013 message is a warning that a key contains signed numeric fields. It just tells you that a field that makes up a key is signed numeric.

This is normal for the DDD-DATABASE and can be ignored.

You may have seen the same warnings with prior releases of CA Datacom as well.

 

From the CA Datacom/DB Message Reference Guide :

DDWKEY0013:  SIGNED NUMERIC FIELD IN KEY

Reason:

During the verification of a DATABASE structure, a KEY substructure was detected that contains a FIELD entity-occurrence with a TYPE attribute-value of N or D and a SIGN attribute-value of Y. Use of a signed numeric FIELD entity-occurrence in a key can cause the data records to be sorted and retrieved in a different sequence than expected.

Action:

This is a warning message only. No action is required if this manner of sorting and retrieval is acceptable. To obtain a logical sorting sequence, change the KEY entity-occurrence DATA-SENSITIVE attribute-value to Y.