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

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

The below error can be seen when trying to run a Database Job against DB2 on AS400 host.

U2012031 The database driver returned the following error message:    

java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver

Environment

Release: 12.x 21.x

Component: Automation Engine

Sub-Component: SQL agent

Cause

This error is caused due to an incorrect JDBC driver. Ensure the right JDBC Driver for DB2 to AS400 is used.

Resolution

Workaround:

Edit the agent.ini and change the below 

From

Type = DB2

To

Type = DB2AS400

Finally, Restart the job

Additional Information

The right driver could be found in the JTOpen Package: https://sourceforge.net/projects/jt400/