While publishing the datapool against the DB2 database it is giving errors as:
SQL state ; 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
TDM Portal 4.9.1
Component: Web Portal - Publishing
The DB2 drivers being used were old and needed to be updated.
Need to update the DB2 client install on the TDM machine to a more current version for the target DB2 database.
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)