How to tell if a dms table is doing a full reload

Question

Let's say I've got a dms task with 2 tables doing full-load-and-cdc with postgres target.  One of my tables gets suspended due to an error.  Then I go into the console, select that table, and do a full reload on it, which takes 5 minutes to finish.  During those 5 minutes, how do I tell by running queries in my target database that a full reload is occurring and when it finishes?  awsdms_status still shows CHANGE PROCESSING, awsdms_history shows FULL LOAD but even when the reload finishes it doesn't show CHANGE PROCESSING again for a while.

Answer

The load state will show:

"Full load" when the reload is in progress.
"Table completed" once the full reload is finished.

You can also check the replication task status. It will show "CHANGE PROCESSING" during an ongoing replication, and will switch back to this state from "LOADING" once the full reload is complete.

The DMS API operation 
describe-replication-tasks
 can be used to get details of a task programmatically. You can check the table-statistics for the load state or overall task status.

Some other options are to use DMS events through EventBridge or custom monitoring solutions like CloudWatch to detect state changes in the task or tables. This allows integrating with automation workflows.

How to tell if a dms table is doing a full reload

Contenuto pertinente