2.41 DEFERAPPLYINTERVAL
Valid For
Replicat
Use the DEFERAPPLYINTERVAL
parameter to set an amount of time that
Replicat waits before applying captured transactions to the target database. To
determine when to apply the transaction, Replicat adds the delay value to the commit
timestamp of the source transaction, as recorded in the local GMT time of the source
system.
You can use DEFERAPPLYINTERVAL
for such purposes as to prevent the
propagation of erroneous changes made to the source data, to control data arrival
across different time zones, and to allow time for other planned events to occur
before the data is applied to the target.
Note that by using DEFERAPPLYINTERVAL
, you are purposely building
latency into the target data, and it should be used with caution if the target
applications are time-sensitive.
To find out if Replicat is deferring operations, use the SEND
REPLICAT
command with the STATUS
option and look for
Current status: Waiting Deferred Apply
.
GGSCI can be used to get info about or alter the delay.
Default
0
(no delay)
Syntax
DEFERAPPLYINTERVAL n unit
Exmple
This example directs Replicat to wait ten hours before posting its transactions.
DEFERAPPLYINTERVAL 10 HOURS
If a transaction completes at 08:00:00 source GMT time, and the delay time is 10 hours, the transaction will be applied to the target at 18:00:00 target GMT time the same day.