Direct Load Materialization Configuration Parameter

alter connection is modified to include a configuration parameter for direct load materialization.

See Direct Load Materialization in the Administration Guide Volume 1 for more information about this configuration parameter, and alter connection in the Reference Manual.

Configuration parameter	Description
dsi_check_unique_key	Checks for unique key in the primary database tables during direct load materialization. If this parameter is set to on, the primary tables with no unique key must not have any activity, otherwise the subscription may fail during the catch-up phase and the subscription is aborted, and marked with error. When the subscription is aborted, it must be dropped and recreated. Before recreating the subscription, cleaning up the replicate table (like truncate table) is required. Default: on

Configuration parameter

Description

dsi_check_unique_key

Checks for unique key in the primary database tables during direct load materialization. If this parameter is set to on, the primary tables with no unique key must not have any activity, otherwise the subscription may fail during the catch-up phase and the subscription is aborted, and marked with error.

When the subscription is aborted, it must be dropped and recreated. Before recreating the subscription, cleaning up the replicate table (like truncate table) is required.

Default: on