Data changing after the load from DB2 table to DB2 table with subset process

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While using generator in TDM Portal that extracts data from one DB2 z/OS schema and publish it to another DB2 z/OS schema, we noticed certain columns, which contain HEX values, are getting changed during the publish. We suspect that this is because the data is being translated during the transferred from DB2 z/OS to a distributed system running SQL Server, and then back to a DB2 z/OS database. What can we do to prevent the data translation?

The TDM data repository is SQL server
The source and target Databases are DB2 on z/OS.

 

 

Environment

All supported releases of TDM Portal

Cause

The data translation issue has nothing to do with the TDM Product. This is due to the DB2 JDBC driver and the SQL Select statement being run. 

Resolution

This is not a TDM related issue, but a DB2 JDBC driver issue. Work with the DB2 admin to ensure the correct SQL statement is being used with the proper JDBC driver parameters.

For more information, review the following IBM Knowledge article for the SQL Statement parameters used by the JDBC driver.