Azure DB2 masking issue(our observation, FDM v4.10.75.0 don’t have issues working fine, whereas 4.10.100/111 having issue with Azure DB2 masking mentioned in my previous comments)
FDM Log shows:
2023-04-17 17:12:21.586 pool-4-thread-1 - Error occurred while fetching the encoding of the columns.
2023-04-17 17:12:21.589 pool-4-thread-1 - DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CCSID, DRIVER=4.25.1301
2023-04-17 17:12:21.613 pool-4-thread-1 - SQL:select name, ccsid from SYSIBM.SYSCOLUMNS where tbname='T_DSBL_CLM' and tbcreator='PROD'
2023-04-17 17:12:21.622 pool-4-thread-1 - exit value = 1
Release : 4.10
There was a problem with the FDM Code causing FDM to see this as DB2 on z/OS. The CCSID in DB2 is the Character Conversion SID, used for character set. From our research it's used in DB2 for zOS on the mainframe, in the SYSIBM.SYSCOLUMNS table, but it's not found in the DB2 LUW databases.
Engineering found the problem and provided a fix in FDM 4.10.114.0. You can download it from the TDM Patches page at https://support.broadcom.com/group/ecx/support-content-view/-/support-content/Release%20Announcements/Test-Data-Manager--TDM--Support-Patches/16649.