DB2 UDB 11 Masking

book

Article ID: 132297

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction



Our customer have DB2 with version 11.1.2.2 AIX 64 bit.

We have checked docops and found that we cannot use Datamaker for masking processes. Is that mean that we cannot do inflight masking?

I cannot find any export & import utility in FDM as well. Should we need only a golden copy for masking process?

Environment

Release:
Component: ITKOTD

Resolution

The only way to accomplish this (minus some key functions such as Hashlov and HASHLOV1) is using a Data Generator to do this.

GT-Subset doesn’t have an option for either UDB or AS400.

Note this only works well for small amounts of data such as an individual entity (Insurance Policy, Individual Customers) or small groups of them. It is not good for massive movement.

Additional Information

If i need to mask two tables in different schemas with referential integrity, what should I do it with FDM?

I cannot use xref and cross reference option.

Is it working (InPlace masking with FDM) with tables in same schema only?


You should be able to accomplish it with xref/xlookup functions, so review the documentation on those functions in publishing. 

https://docops.ca.com/ca-test-data-manager/4-8/en/reference/data-generation-functions-and-parameters