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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

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.