CA Datacom DDUPDATE or DDOL VERIFY function failed with error DDVTBL0046 TABLE LENGTH INVALID FOR ENCRYPTION. Why?

book

Article ID: 17874

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA Ideal 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

Description:

When using the VERIFY function for a database occurrence either via CA Datacom Datadictionary Online (DDOL) or by using the batch utility DDUPDATE with a 1000 VERIFY, the following error set may result:


 	DDVTBL0046 TABLE LENGTH INVALID FOR ENCRYPTION
 ENTITY=my-table-name
 	DDWTBL0029 TBL SQL ACCESSIBLE, VERIFY FAILED
 ENTITY=my-table-name

Solution:

This problem may occur when the table has a record length less than 16.

TABLE LENGTH INVALID FOR ENCRYPTION

Reason:

The ENCRYPTION-TYPE attribute-value is B, E, or M but the LENGTH attribute value of the TABLE occurrence is less than the minimum of 16.

Action:

Either increase the length of the table or set the ENCRYPTION-TYPE attribute value to blank.

If you do not wish to increase the length of the table, batch DDUPDATE can be run to update the ENCRYPTION-TYPE attribute with the following:


-UPD DATACOM-INSTALL,NEWUSER       
-UPG TABLE,my-table-name(TEST)     
1500 ENCRYPTION-TYPE,&             
1500 ENCRYPTION-METHOD,&           
-END                               
-UPG TABLE,my-table-name(PROD)     
1500 ENCRYPTION-TYPE,&             
1500 ENCRYPTION-METHOD,&           
-END                               

Environment

Release: DATABB00200-14-Datacom/AD
Component: