Error while creating or modifing a DB2 connection profile
search cancel

Error while creating or modifing a DB2 connection profile


Article ID: 240080


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Error while creating or modifying a DB2 connections profile, no message in the portal GUI but in the log there's an error : Error retrieving database version

If we specify a specific schema name in the DB2 connection, the value is delete while saving the connection profile.

We did a test with an Oracle connection profile and we didn't have any issue, even when we add a specific schema, the filed value is not delete.

Connection profile used for the test: _DB2_test and 

Portal release : 4.10.12

It's not a new install but am upgrade. And it was working before with 4.9.405
We tested on three different servers and we have the same issue.

We have these drivers: db2jcc4.jar , db2jcc_license_cisuz.jar and db2jcc_license_cu.jar in <CATDMWEB_HOME>\tomcat\jdbc-drivers\ and <CATDMWEB_HOME>\tomcat\lib\

After removing db2jcc_license_cisuz.jar and db2jcc_license_cu.jar from both directories, there's no more error in the log. But we cannot still specify a schema in the DB2 connection profile.

I attached the files requested. For the test, I edited an existing DB2 connection, specified a schema, save it and the schema info disappeared.



Release : 4.10

Component : TDM Web Portal


The fixed binary is available at  Please contact Support to get this or a later version.