CA XCOM Trusted DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704

Products

• XCOM Data Transport
• XCOM Data Transport - Windows
• XCOM Data Transport - Linux PC
• XCOM Data Transport - z/OS

Issue/Introduction

After upgrading to CA XCOM Version r11.6 17090 SP02 64 bit with IBM DB2 1.11, I can no longer connect to the XCOM trusted database.

The log shows the following error messages:

DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=XCOMTRST.XCOM_TRUSTED_SYS, DRIVER=3.72.30
java.lang.NullPointerException ExceptionMessage=[null] 

 

Environment

DB2 v11.1

CA XCOM for Windows Version r11.6 17090 SP02 64 bit

Cause

Known problem with DB2 v11.1

Resolution

This is a known problem with IBM DB2 v11.1 and is fixed in Db2 11.1 Mod 2 Fix Pack 2 iFix002 or higher 

Please refer to this information on the IBM website IT21578: FILEDSN IS NOT WORKING WITH V111M2FP2. DB2CLIO.DLL FAILS WITH SYSTEM ERROR 1114