ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

TDM masking support for DB2 version 9.7

book

Article ID: 241145

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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. 

Environment

Release : 4.9

Component :

Resolution

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 - https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/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:

    • 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.

https://www.ibm.com/support/pages/db2-distributed-end-support-eos-dates