search cancel

Does TDM has ability to encrypt/decrypt mainframe dataset in BLOB/CLOB format


Article ID: 213449


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We are exploring TDM capability for encryption/decryption of data pulled from our source database.
Our data is in BLOB/CLOB format.


TDM 4.8.x 4.9.x

Test Data Manager Portal


System Requirements for Mainframe Installation (

Data stored in LOBs, CLOBs, BLOBs, are not natively supported.
(Potential for unloading structured LOB data to a flat file for processing.)

comments from our Mainframe experts:
A typical customer will already have their own decryption/encryption routines that can be incorporated into the JCL flow.  
There are no Mainframe BLOB mask routines.  
What can be done with the CLOB is somewhat dependent on what the content looks like.

My expectation is that the decryption will also extract the CLOB from DB2 to a file;  
so it wouldn't be a CLOB anymore - it would just be the contents in the file
(hence my mention above about dependency on what the contents are).