How do I use table statistics to monitor an AWS DMS task?

Resolution

1. Open the AWS DMS console, and then choose Database migration tasks.
2. Choose the name of the task that you want to monitor.
   Note: If your table had an issue that you corrected, select the table, and then choose Reload table data. This action reloads one or more tables, so you don't have to restart the task.
3. From the Table statistics section, you can view column details for your table.

The Load state column has the following states:

• Table does not exist: AWS DMS can't find the table on the source endpoint.
• Before load: The full load process is enabled, but it hasn't started yet.
• Full load: The full load process is in progress.
• Table completed: Full load is completed.
• Table cancelled: Loading of the table is canceled.
• Table error: An error occurred when loading the table.

The Inserts, Deletes, Updates, and DDLs columns show the number of these statements that were replicated during the change data capture (CDC) phase.

The Full load rows column shows the total number of rows that were migrated during the full load phase.

The Total column shows the total number of rows that were migrated during the full load and the applied Insert, Update, or Delete statements during the CDC phase.

The Validation state column shows the state of the validation, such as Not enabled, Pending records, Validated, or Error.

The Validation pending, Validation failed, and Validation suspended columns show the number of transactions for each transaction type. For example, this value represents the number of rows that failed validation, are suspended, or are in pending state. For more information, see Validating AWS DMS tasks.

The Last updated column shows the date and time that the information contained in the table statistics tab was last updated.

If you stop and restart a task, the table statistics are reset. For example, if you perform a CDC with entries for inserts, updates, and deletes, stopping and resuming a task resets the count to 0.

Related information

Monitoring AWS DMS tasks