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.10, 1.11
Component : FDM
Looking at the TDM 4.10 and 4.11 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.11 - https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-11/installing/supported-data-sources.html, or
TDM 4.10 - https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/supported-data-sources.html, we support the following releases of DB2:
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.
https://www.ibm.com/support/pages/db2-distributed-end-support-eos-dates