DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704 connecting to the CA XCOM trusted database after upgrading to DB2 v11.1

Document ID : KB000009099
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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