We are connecting AWS DMS with db2 to migrate the data. In source we have a freeze period for around 8 hours, so we are stopping and resuming the DMS service.
Once we resume the DMS most of the tables will be resumed but some of the tables will still be locked due to some changes it leads to "Table Error" state. After this we can't resume the table only option is reload.
we can't define the table list or time when those table will be released.
In that case can we check the table status whether DMS can successfully connect with tables or not using python script or some other methods.
Is there any other way we can resolve this issue?
The above is the detailed content of AWS DMS Table failure due to freeze period in source. For more information, please follow other related articles on the PHP Chinese website!