Thread Control displays Replication, Replication-CDC, or CDC threads that can be acted on and displays the status for those threads.

Thread Control

You can use Thread Control to enable or disable threads. This will enable them, or prevent them from replicating.

Logging levels

  • None—No logging
  • Minimum—Writes start and stop time of replication process and writes number of records processed per cycle
  • Moderate—Minimum logging levels plus any errors
  • Extended—Moderate logging level plus warnings
  • Verbose—Extended logging level plus information for each individual replqueue record processed

Typically, logging level is set to verbose during initial implementation and testing. It is possible to for the Logs to become too large verbose mode. To avoid to avoid this, lower the logging level after your initial implementation.

Disposition

The Disposition box allows you to choose what happens to the replication record after it is processed. Typically, Queue Disposition is set to Delete Record. When Delete Record is selected, the Replication Processor deletes the replication record once it is processed. When Mark Record Applied is selected, the Replication Processor modifies the replication record by setting its “Applied” flag to true. No further action is taken on applied records with this setting and a separate PurgeQueue.p procedure needs to be run when the queue records are no longer needed and can be deleted.

Status

The Replication Status shows the status of the replication. The status shows as RUNNING when the Replication Processor is either actively cycling through the queue or is in a paused state between cycles. This is also indicated by a green status bar.

If the Processor is neither active nor sleeping, then the status is STOPPED, indicated by a red status bar.