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: 05-08-2025

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Azure DB2 masking in FDM 4.10.100/111 is throwing the below error:

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

A fix is provided in FDM 4.10.114.0.

You can download it from the Test Data Manager (TDM) Support Patches page.