By using AWS re:Post, you agree to the Terms of Use

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

0

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!

1 Answers
1

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
answered a month ago
  • thanks for the info. Ill look closely. hopefully the AWS engieers give a look on this and make an API to collect this info instead of needing to parse strings for atomic information

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions