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

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: