Error when trying to run a Job on an AS400 DB Agent (DB2)

Document ID : KB000090336
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error when trying to run a Job on an AS400 DB Agent (DB2)
Resolution:

Symptoms while running a job and trying to connect to DB following Error appears

 

2012-10-08 16:16:30 - U2012031 The database driver returned the following error message:    

 

2012-10-08 16:16:30 java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver

 

Investigation;

 

Check the .ini File of the agent, especially the entries for

 

Type = DB2

 

Solution

  

Ensure the right JDBC Driver for DB2 to AS400 is used (iSeries jt400.jar)

 

Change the entry

Type = DB2

To

Type = DB2AS400

In the .ini File of the agent

 

 

Restart the Job, it will work then.