Starting Replication

Start replication using the deployed model under the RAXContainer.

1. Right-click the model and select Start Replication menu item.
   You see a dialog indicating that replication has started. The model begins to:

   • Create the triggers, shadow tables, and trigger queues at the primary database.
   • Create CDC tables at the replicate database, if you are using either the CDC or the Transactional CDC strategy.
   • Create or replace tables at the replicate database, deferring the creation of those tables that are empty if you have selected the Defer option
   • Materialize the data from the primary to the replicate database.
   • Apply the trigger data from the primary to the replicate database.
2. Return to the Materialization Status and Replication Options window and click Refresh to see the overall materialization progress.

   Once the materialization completes, replication of the trigger data begins.

   Note: For the transactional CDC strategy, application of the trigger data to the replicate database cannot begin until materialization completes for all tables.
3. To monitor replication progress, right-click the model and select Replication Status menu item.

   On the Replication Status window, you can view the primary database activity, including transaction information that is written to the primary database and from the primary database to the shadow tables.

   The Table Replication Status panel provides information about tables being replicated with only an active transaction. You can view:

   • Tasks – the number of tasks (equivalent to process threads) dedicated to scanning the shadow tables.

   • Transactions – the number of transactions that have been executed for the table.

   • Inserts, Updates, and Deletes – the number of data manipulation language (DML) commands executed the tables.

   • Errors – the number of errors encountered while scanning the tables.
   • Queue Depth – the number of commands in the shadow table for the table.

   The Apply Statistics panel provides detailed statistics for the selected table. You can view:

   • Task Statistics – displays the activity of the task that reads from the transaction log, and the trigger queue.
   • Data Processing Statistics – displays the time spent in writing data to the corresponding CDC table.
   • Shadow Table Statistics – displays the time spent in reading data from the shadow tables and the number of operations currently in the shadow table.
4. To view the replication status of trigger data, right-click the model and select Scanner and Apply Task Status menu item.

   The Scanner and Apply Task Status window monitors activity at the replicate database.

   On the Inflight Apply Tasks panel, you can view transactions that are written to the CDC tables.

   The Scanner Statistics panel displays:

   • Status – the status of the scanner that reads from the trigger queue.
   • Tasks – tracks the number of apply tasks the scanner has executed and information on the results of those tasks.
   • Trigger Queue – provides information on the trigger queue, how many records have been read, deleted, and are still in the queue, how much time has been spent reading and deleting from the trigger queue in total and on average, and the high-water mark (HWM) for the trigger queue.