Previous Topic: Opening and Backing Up Encrypted TablesNext Topic: How to Use


DBUTLTY LOAD and REORG BASIC Encryption Functions

Each DBUTLTY LOAD (or REORG) copies the current CXX key 1 information to the data area control block and uses that information for all basic encryption. A REPLACE function uses the basic encryption information in the control block, if it has been set. If not set, REPLACE copies the key 1 information from the CXX and sets the area as not openable by releases before Version 14.0.

In addition to the CXX encryption information, the data area has table level information also preserved to help ensure that data can be accessed correctly.

The addition of the CXX information and table information can cause the data block size to be insufficient to load the data. If this occurs, a return code is issued and the load terminated. This is likely only for areas with a high number of tables (the maximum is 240) and areas that have a small block size, for example, less than 4096.

A data area loaded with encryption is set at a ‘level’ that is not openable by releases of CA Datacom/DB before Version 14.0, ensuring that back-level code does not try to read or add data out of sync with encryption options.

Similar to the REPORT AREA=CXX,TYPE=K that can print the encryption information stored in the CXX, the copy stored in the data area can be reported. Because they are intended to always match, this should be a rare need. As such, it is added to the REPORT TYPE=U function where a DD statement is provided to a data set considered as unknown. The execution for a data set that contains encrypted data formats the information similarly to the TYPE=K report.