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.
Release : 4.9
Component :TDM Portal and DB2 on AS/400
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.9 documentation, I see that need to use the jt400.jar.
IBM DB2400 iSeries V7R1