TDM Portal cannot connect to DB2 on AS400

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When attempting to connect to our DB2 database, we see the following:

Failed to connect.
The server replied: Could not load JDBC driver class [com.ibm.as400.access.AS400JDBCDriver]; nested exception is java.sql.SQLException

I have updated the db2jcc4.jar file in the folder \\CATDM1PRVND01\c$\Program Files\CA\CA Test Data Manager Portal\tomcat\lib. I have also stopped the portal service and restarted it, but still get the same error.

Environment

Release : 4.10 or newer

Component :TDM Portal and DB2 on AS/400

Cause

The db2jcc4,jar file is not the correct driver. When connecting to a DB2 on AS400, it requires a different driver than DB2 on z/OS. Looking at the TDM 4.10 documentation, I see that need to use the jt400.jar. 

Resolution

IBM DB2400 iSeries V7R1

• For masking, ensure that the jt400.jar file is available at the following location:
  C:\Program Files\Grid-Tools\FastDataMasker\lib\
  
  
• For subsetting, ensure that the jt400.jar file is available at the following location:
  C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
  
  
• For CA TDM Portal, ensure that the jt400.jar file is available at the following location:
  C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

 

Additional Information

For more information, see https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources/notes-on-implementation-with-specific-data-sources.html#concept.dita_1dcf72d4deca5c21cf3a2704f77ddf29624ee21f_db2400ibmdb2400iseriesv7r1