Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added FILTERING, CDCAUDIT, LIST STATS, updated LIST CONFLICT|

All keywords are case-insensitive.

...

List the current conflict(s). This information is obtained from Dbvisit Replicate internal table DBRSAPPLY_CONFLICT_LOG on the apply side. 

Image Added

Display statistics for number of rows processed/minute and/or lag between mine and apply. The lag can be displayed in terms of time or SCN difference; the number of rows per minute can be shown globally or for specified table.

By default, the number of rows processed/minute represents APPLY performance; use LIST STATS TOTAL MINE to see mine statistics.

EXIT, QUIT

Exits dbvrep.

WAIT

...

  1. Remove and already existing EXCLUDE CREATE TABLE rule 
  2. Add an exception to the EXCLUDE CREATE TABLE rule. For example, EXCLUDE CREATE TABLE SCOTT.TEMP%, but INCLUDE CREATE TABLE SCOTT.TEMP_REPL

FILTER

Image Added

Set filtering rules for an already prepared table/schema. The usual way how to configure filtering is using Setup wizard (which in turn uses this very command). 

CDCAUDIT

Image Added
Configure CDC/Aduit for an already prepared table/schema. The usual way how to configure this is using Setup wizard (which in turn uses this very command). 
This command sets this feature for insert/update/delete operations, sets the prefix for new/old value columns and configures additionall added columns (operation type, transaction, session audit information).

LICENSE

Shows current license, as set by LICENSE_KEY variable.
The optional FULL keyword specifies the verbosity of the command:

...

The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.

SHOW_CONFLICT_HANDLERS

Shows current setting of conflict handlers for given table (schema.name refers to table at mine).

...