Example 3

This third example is nearly the same one as the previous one. The unique difference is that a CUTOFF value has been specified and set to 2 in the MASKED COLUMNS clause, in order to limit the number of rows skipped. Thus, the CUTOFF value is set to a value smaller than the number of rows in the table having invalid values for the CCN1 column:

[i958@lat186(:) hm500_mnt]$ db2hpu -f emp_ccn.ctl -i i958
INZM031I Optim High Performance Unload for Db2 06.01.00.001(130920) 64 bits 09/20/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----+
000001 GLOBAL CONNECT TO SAMPLE
000002 DATAMASKING ODPP LOAD LOADER "/opt/odpp/bin/libODPPLoader.so.9.1"
000003                       PARSER "/opt/odpp/bin/libODPPParser.so.9.1"
000004                       ADAPTER "/opt/odpp/bin/libODPPAdapter.so.9.1"
000005                       PROVIDER "/opt/odpp/bin/libODPPProvider.so.9.1"
000006 ;
000007 UNLOAD TABLESPACE
000008 LOCK NO 
000009 FLUSH BUFFERPOOLS NO
000010 SELECT EMPNO, CCN1 FROM EMP_CCN_SMALL;
000011 MASKED COLUMNS (CCN1 "provider=ccn,flddef1=(name=ccn1,dt=char),method=rep" SKIP CUTOFF 2)
000012 OUTFILE ("outfile")
000013 FORMAT DEL;
000014

INZU462I HPU control step start: 17:45:46.523.
INZU463I HPU control step end  : 17:45:46:853.
INZU464I HPU run step start    : 17:45:46.941.
INZU645E There are too many rows containing invalid values for the masking applied on I958.EMP_CNN_SMALL (partition 0). 
INZU465I HPU run step end      : 17:45:46.944.
INZU366I HPU return code 8 (reason code 0x13ea00b)