|
|
|
The Replication Agent supports setting its starting position on the source server in the Replication Agent configuration file, ctreplagent.cfg. Use the start_position configuration option. The option accepts three possible formats:
start_position #current
start_position <log number> <log position> <minimum log>
start_position <log number> <log position> <last commit log> <last commit position>
Examples
Use the source server's current transaction log position and minimum log:
start_position #current
Start with transaction log 10 at offset 62697158, and set minimum required log to 7:
start_position 10 62697158 7
The Replication API function, ctReplAgentSetConfigOption(), can be used to set the position. For example:
ctReplAgentSetConfigOption(ctRAOPT_start_position, "10 62697158 7", &repstt, lineno, configfile);
