search cancel

TDM masking support for DB2 version 9.7


Article ID: 241145


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We are attempting to mask a table in DB2 9.7, and seeing an error caused due to the column FILE_DATA of table PS_PY_SS_HOWTO_FLE, which is having a data type of LONG VARCHAR FOR BIT DATA. This column has data in binary format. When we are trying to FORMATENCRYPT, it's throwing an error as below

Thread:PS_PY_SS_HOWTO_FLE - Error executing select statement for update
Thread:PS_PY_SS_HOWTO_FLE - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=37;varchar(2000) ccsid;ASCII, DRIVER=3.69.78
Thread:PS_PY_SS_HOWTO_FLE - selectSQL:SELECT cast("FILE_DATA" as varchar(2000) ccsid 37),"U_ROWID" FROM "CDPPSH01"."PS_PY_SS_HOWTO_FLE" order by "U_ROWID"

According to our DBA, ccsid is not supported by DB2 version 9.7 but supported by versions 10.5 and above. 


Release : 4.9

Component :


Looking at the TDM 4.9.1 documentation and TDM 4.10 documentation, we do not support DB2 9.7, which is why you are running into the issue.

According to the documentation, which can be found at:

TDM 4.9.1 -, or

TDM 4.10 -, we support the following releases of DB2:

    • IBM DB2/400 iSeries V7R1
    • IBM DB2 11 for z/OS
    • IBM DB2 12 for z/OS
    • IBM DB2 UDB 11.1


Additional Information

According to IBM, support for DB2 9.7 reached end-of-support on September 30, 2017, and extended support reached end-of-life on September 30, 2020.