BCV5 - Data Scrambling Print
DB2 Products

BCV5 allows for hi-speed copies of DB2 data-bases and table spaces. However, you may not always want or even be allowed to copy sensitive data from a production system to a testing or QA system. You have to adhere to data privacy regulations.

When you copy data like account balances or medical records to a development environment, the actual names of your customers should not be visible to an application programmer. You probably want to replace the name andother sensitive information with random data. Sometimes it is desirable to replace characters according to a given pattern, so you still have the ability to derive the original name if you test the latest version of an in-house application on a copy of your database and it produces faulty results on some records.

The data manipulation component of BCV5 allows you to specify rules how to manipulate the content of DB2 tables. The integrated copy facility of BCV5 takes care of these specified rules and performs the manipulation on the fly during the copy process. The target environment only contains the manipulated contents. This process works behind the back of DB2 and makes it very fast. It does not require additional free DASD space and most important it does not write any DB2 log records that could be used to recover the target to the original values which would be possible if update SQLs would be used to manipulate the data.