I have set up AWS DMS CDC Task with DB2 LUW Server. When I restart or resume a new CDC task it gets failed and gives below error.
We have confirmed that there are no changes occur at DB2. There was one more CDC task for the same source was running fine. By mistake, I have deleted that also and have created exact same Task for all same tables again but now it starts giving me the same error which was giving me for another CDC task for the same source. This issue starts occurring suddenly.
Last Error Error reading the database log. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:xxxx] [xxxxx] Error at 'Reading log records': Trying to read an invalid LSN from the DB2 LUW log. Original SQLCODE -2650: ' message SQL2650N An invalid parameter "piStartLSN" was passed to the "db2ReadLog" read log API. Reason Code = "4". ., SQLSTATE '; scan_log_timestamps: Error reading next buffer; capture_start: Error creating timestamp mapping table; Error executing command; Stream component failed at subtask 0, component st_0_P4RZFVKJAM4AZEPZWFKKZVQWWHYRSBKKWTZBCXQ ; Stream component 'st_0_P4RZFVKJAM4AZEPZWFKKZVQWWHYRSBKKWTZBCXQ' terminated [reptask/replicationtask.c:xxx] [xxxxx] Stop Reason FATAL_ERROR Error Level FATAL
I know the description of SQLCODE and Reason Code but not getting why it is giving error. I am new for DB2. Could you please help to get a possible solution and cause at DB2 or DMS end.
Note: Issue is occurring with this source only and it is giving exact same error for all CDC tasks. Full Load tasks are running perfectly.
DB2 Version: DB2 v9.7.0.2 with Fix Pack 2