DB2 Data pool fails with SQL state [56038]; error code [-4743]during publish

Products

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

Issue/Introduction

While publishing the datapool against the DB2 database it is giving errors as:

SQL state [56038]; error code [-4743];
DB2 SQL Error: SQLCODE=-4743, SQLSTATE=56038, SQLERRMC=null, DRIVER=4.12.55;
nested exception is com.ibm.db2.jcc.am.SqlException:
DB2 SQL Error: SQLCODE=-4743, SQLSTATE=56038, SQLERRMC=null, DRIVER=4.12.55>

However, when we tried to run the same query in the generator it is working as expected and no errors

Environment

TDM Portal 4.10+
Component: Web Portal - Publishing

Cause

The DB2 drivers being used are old and need to be updated.

 

Resolution

Need to update the DB2 client install on the TDM machine to a more current version for the target DB2 database.

Additional Information

Below is a link to an IBM article on this error that you should have your DB2 DBA review and comment on.
IT10646: DB2SQLJCUSTOMIZE MAY RETURN ERROR -4743 WHEN THE SQLJ APPLICATION USES A NEW DB2 V11 FUNCTIONALITY (ibm.com)