How can i monitor LSN/CSM status on DMS tasks?

Question

Hello
Im trying to find which boto3 call should return the SCN/LSN number being processed by a given DMS. This is important to measure the delay / keep up of DMS with the origin server
Reference: https://docs.aws.amazon.com/dms/latest/APIReference/API_DescribeReplicationTasks.html
cant find it in DescribeReplicationTasks calls
Where can i get this information? It would be nice to get it clean, insted of looking for string filtration in the logs
THanks!

Answer

please note scn number being processed wont be available in api calls. You should be able to get them in DMS task cloudwatch logs and also if you set task setting "StatusTableEnabled": true under ControlTableSettings
you should get a target table awsdms_status with required column SOURCE_CURRENT_POSITION https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.ControlTable.html

```
  "ControlTablesSettings": {
        "historyTimeslotInMinutes": 5,
        "ControlSchema": "",
        "HistoryTimeslotInMinutes": 5,
        "HistoryTableEnabled": false,
        "SuspendedTablesTableEnabled": false,
        "StatusTableEnabled": true,
        "FullLoadExceptionTableEnabled": false
```

How can i monitor LSN/CSM status on DMS tasks?

Relevant content