ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 213449

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

Environment

TDM 4.8.x 4.9.x

Test Data Manager Portal
Datamaker
Mainframe

Resolution

System Requirements for Mainframe Installation (broadcom.com)

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).