Replication Considerations for DB2 for Linux, UNIX, and Windows Targets
Replication Considerations for DB2 for Linux, UNIX, and Windows Targets
Review the following replication considerations for DB2 targets:
DB2 targets use a period (.) as the decimal separator to store float values. If you run an Applier or InitialSync task that uses the ODBC driver, ensure that the
db2.odbc.enable_decimal_period
runtime parameter is set to 1. If you set this parameter to 0, the ODBC driver uses the decimal separator that corresponds to the system locale settings. If the system locale settings use a decimal separator other than the period (.), the Applier and initialSync task cannot load float values to the target.
If a DB2 target table does not contain a primary key or unique index, ensure that distribution by tables is set in one of the following ways:
On the
Map Columns
tab, select the
Distribute by tables
option.
On the
Map Tables
tab, click
Settings
to open the
Customize Settings for the Selected Tables
window. In the
Distribute By
column, select
Tables
.
Distribution by tables is the default option for DB2, Microsoft SQL Server, and Merge Apply targets. For Oracle targets, the default is distribution by rows.