Example 1
The ODPP interface usage is specified through a DATAMASKING clause containing the ODPP path and version involved. A table called EMP_CCN contains employees credit card numbers in a column called CCN1, which Db2 data type is CHAR(20). Its values must be masked using the 'Credit Card' service provider. The effective values stored into this column are shown below, before the Optim™ High Performance Unload execution. The masked values unloaded are shown after the Optim High Performance Unload execution, and are different from the effective ones.
[i958@lat186(:) hm500_mnt]$ db2 "select empno, ccn1 from emp_ccn"
EMPNO CCN1
------ --------------------
000010 18002748513298
000020 30000019965395
000030 12345678901234
000040 12345678901234
000050 12345678901234
4 record(s) selected.
[i958@lat186(:) hm500_mnt]$ db2hpu -f emp_ccn.ctl -i i958
INZM031I Optim High Performance Unload for Db2 06.01.00.001(130912)
64 bits 09/13/2013 (Linux lat186 x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
000001 GLOBAL CONNECT TO SAMPLE
000002 DATAMASKING ODPP PATH "/opt/odpp" VERSION "9.1"
000003 ;
000004 UNLOAD TABLESPACE
000005 SELECT EMPNO, CCN1 FROM EMP_CCN;
000006 MASKED COLUMNS (CCN1 "provider=ccn,flddef1=(name=ccn1,dt=char),method=random")
000007 OUTFILE ("outfile")
000008 FORMAT DEL;
000009
INZU462I HPU control step start: 16:36:57.430.
INZU463I HPU control step end : 16:36:57:784.
INZU464I HPU run step start : 16:36:57.887
INZU410I HPU utility has unloaded 5 rows on lat186 host for I958.EMP_CCN in outfile.
INZU468I HPU run step end : 16:36:57.890.
INZI441I HPU successfully ended: Real time -> 0m0.459566s
User time -> 0m0.44993s : Parent -> 0m0.44993s, Children -> 0m0.00000s
Syst time -> 0m0.14997s : Parent -> 0m0.14997s, Children -> 0m0.00000s
[i958@lat186(:) hm500_mnt]$ cat outfile
"000010","6011080000000014 "
"000020","4170260000000014 "
"000030","374246000000015 "
"000040","4795290000000024 "
"000050","5632190000000024 "