DB2 UDB 11 Masking


Article ID: 132297


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Our customer have DB2 with version 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?


Component: ITKOTD


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.