Job failed with java.sql.SQLException: No suitable driver found

Products

• Workload Automation Agent
• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

When executing a  DBMON job for DB2 we are getting error like below, while running the job.

java.sql.SQLException: No suitable driver found for jdbc:db2://host.example.com:port/database

 

Environment

CA Workload Automation Agent for Databases

Cause

The agent's agentparm.txt is missing jdbc driver class for DB2.

Resolution

Ensure that the jdbc.drivers property in the agentparm.txt file includes the driver for DB2, and restart the agent;

Example:
jdbc.drivers=oracle.jdbc.OracleDriver:net.sourceforge.jtds.jdbc.Driver:com.ibm.db2.jcc.DB2Driver

Also, make sure that the jdbc driver is installed, see link for detailed.