Azure DB2 Masking throws DB2 SQL Error: SQL CODE=-206, SLSTATE=42703, SQLERRMC=CCSID, DRIVER=3.72.52
search cancel

Azure DB2 Masking throws DB2 SQL Error: SQL CODE=-206, SLSTATE=42703, SQLERRMC=CCSID, DRIVER=3.72.52

book

Article ID: 264674

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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 

Environment

Release : 4.10

Cause

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.

Resolution

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.