search cancel

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

Datacom DATACOM - AD Ideal 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

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: