Filter
Top Products
Chapter 13. Using SQL Remote with Replication Server
Configuring Replication Server
This section describes how to configure Replication Server for use with the
SQL Remote Open Server
The Replication Server connection to the SQL Remote Open Server must
have several configuration parameters set.
Set the dsi_xact_group_size parameter
By default, Replication Server groups multiple transactions into larger
transactions. The dsi_xact_group_size parameter controls the maximum
size of a grouped transaction.
The dsi_xact_group_size parameter must be set to –1 to disable transaction
grouping. Transactions that originate from different remote databases in a
SQL Remote setup must not be grouped together.
How to set the parameter You can set the parameter using the following statement:
CONFIGURE CONNECTION TO "ssqueue_server"
SET dsi_xact_group_size TO ’-1’
Set the dsi_num_threads parameter
The SQL Remote Open Server does not support multiple DSI threads.
Replication Server should not be configured to use multiple DSI threads on
SQL Remote connections.
Create replication definitions for SQL Remote data
Replication definitions for tables being replicated by SQL Remote must have
certain characteristics. This section describes those characteristics.
In some circumstances SQL Remote replicates an UPDATE operation as an
INSERT or a DELETE (see “Replication of updates” on page 78). This is
referred to as subscription migration in the Replication Server
documentation. In order to replicate an UPDATE as an INSERT,
SQL Remote requires the full pre-image of the row. This means that
Replication Server must specify the values of every column in the WHERE
clause of any UPDATE to a table that might need to be replicated as an
INSERT.
The simplest way to achieve this is to list all columns in the PRIMARY
KEY of the replication definition. This forces Replication Server to include
every column in the WHERE clause of every update. REPLICATE
MINIMAL COLUMNS can be used on these replication definitions to
285