search cancel

Error while creating or modifing a DB2 connection profile

book

Article ID: 240080

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

 

Environment

Release : 4.10

Component : TDM Web Portal

Resolution

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