TDM subset for VSAM file using a large set of keys

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

To use TDM to subset and mask VSAM files these steps can be used: 

1. Use CA module “File Master” or other products to: 
   • Review database contents & structure
   • Export copybook
2. Use TDM module “File Definition Manager” to 
   • Review copybook(s)
   • Enter definitions (headers, date formats)
   • Generate “Advanced Format Language output (structure for Datamaker & Mainframe modules)
3. Use TDM module “DataMaker” to 
   • Register AFL file
   • Specify Masking Rules
   • Export to Definition file for upload to Mainframe

A WHERE clause can be used to restrict the records to subset or mask:

For example: 

WHERE  "CUST_ID < '0000200'

 

 

How to specify a large set of random keys that could be more than 10k.

 

Environment

Release : 4.10

Component : CA Test Data Manager - Mainframe

Resolution

There is no "out of the box" solution for a large set of keys to be provided in the where clause.

It may be possible to create a custom solution using JCL or Shredding data into a DB2 database is also an alternative.