Use
dsi_retry to suspend replication immediately after any replication
mode fails to apply
transactions.
Set
dsi_retry to:
- 0 – the default setting where Replication Server automatically switches to
continuous replication mode when HVAR, RTL, parallel DSI, dynamic SQL or DSI
bulk copy-in fails to apply transacations.
- 1 – to stop replication when HVAR or RTL fail to apply compilable
transactions, or when parallel DSI, dynamic SQL, or DSI bulk copy-in fail to
apply any transactions.
- 2 – to stop replication when the number of commands in a group containing
failed transactions is smaller than the value of
dsi_compile_retry_threshold, and HVAR or RTL fail to
apply compilable transactions, or when parallel DSI, dynamic SQL, or DSI
bulk copy-in fail to apply transactions.
After you set dsi_retry to the value that is relevant to the
replication mode, Replication Server suspends replication when there is a failure in the
replication mode.
Example 1
An example of the message you see in the Replication Server log when you set
dsi_retry to
1:
2012/09/18 23:06:35. A grouped transaction of 538 individual transactions has failed in database 'GOME3_5551_IQ.iqrdb' with 'HVAR/RTL'.
DSI is now suspended because dsi_retry value is '1'
Example 2
An example of the message you see in the Replication Server log when you set
dsi_retry to 2:
2012/09/18 23:42:45. A grouped transaction of 20 individual transactions has failed in database 'gome0_5551.tdb2'.
It will be broken into smaller groups and retried.
2012/09/18 23:42:46. Retry of a grouped transaction of 8 individual transactions has failed in database 'gome0_5551.tdb2'.
It will be broken into smaller groups and retried.
2012/09/18 23:42:47. Retry of a grouped transaction of 4 individual transactions has failed in database 'gome0_5551.tdb2'.
It will be broken into smaller groups.
2012/09/18 23:06:35. A grouped transaction of 538 individual transactions has failed in database 'GOME3_5551_IQ.iqrdb' with 'HVAR/RTL'.
DSI is now suspended because dsi_retry value is '2'.
Example 3
An example of the message you see in the Replication Server log when
dsi_retry is set to 1 or 2, and dynamic SQL fails to apply
transactions:
I. 2012/09/18 23:13:45. A grouped transaction of 20 individual transactions has failed in database 'gome0_5551.tdb2' with 'DSQL/BULK COPY'.
DSI is now suspended because dsi_retry value is '1'.
Example 4
An example of the message you see in the Replication Server log
when
dsi_retry is set to 1 or 2, and DSI bulk copy fails to apply
transactions:
I. 2012/09/18 23:13:45. A grouped transaction of 20 individual transactions has failed in database 'gome0_5551.tdb2' with 'DSQL/BULK COPY'.
DSI is now suspended because dsi_retry value is '1'.
Example 5
An example of the message you see in the Replication Server log
when
dsi_retry is set to 1 or 2, and parallel DSI fails to apply
transaction:
A parallel transaction has failed in database 'gome0_5551.tdb2'.
DSI is now suspended because dsi_retry value is '1'.
Example 6
An example of the message you see in the Replication Server log
when
dsi_retry is set to 1 or 2, and replication with the continuous
log-order language replication mode fails even after disabling the HVAR or RTL, dynamic
SQL, and DSI bulk copy
modes:
2012/09/18 23:18:05. A grouped transaction of 20 individual transactions has failed in database 'gome0_5551.tdb2' with 'Language'.
DSI is now suspended because dsi_retry value is '1'.