We are migrating the data from DB2 LUW to Aurora PostgreSQL database using AWS DMS.
For few tables we have a column with data type varchar(22) and the value of the column could end up having ending spaces (Trailing Spaces).
DMS is migrating the data as it is from DB2 to PostgreSQL and validation also successful.
Looks like DB2 is not bother about the trailing spaces and giving us the data, but PostgreSQL is bit strict on this and not giving the data.

I’m doing migration from DB2 LUW to Aurora PostgreSQL using AWS DWS
Source – IBM DB2 LUW
Target – Aurora PostgreSQL