Numeric Column Validation

Use this system parameter to enable or disable the CDC Replication Engine for Db2® for i from checking decimal and numeric columns for valid formats before applying numeric data to the target table.

Versions supportedCDC Replication Engine for Db2 for i version 6.1 and later

Applies to
Target datastores
Values
Set this parameter to one of the following value:
*YES
Enables the CDC Replication Engine for Db2 for i to validate invalid packed or zoned data before applying it to the target table.
If invalid packed or zoned data is found, then the CDC Replication Engine for Db2 for i generates a message and sets the field to 0 automatically.
*NO
Disables the CDC Replication Engine for Db2 for i from validating packed/zoned data before applying it to the target table.
If you are sure that numeric data does not have to be validated, set this parameter to *NO to maintain existing performance levels.
Default Setting
*YES