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

Products

• CA Workload Automation Agents

Issue/Introduction

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

java.sql.SQLException: No suitable driver found for jdbc:db2://b04db2d08:50513/dcird01

 

Cause

Agentparm.txt doesn't contain correct jdbc.driver statement for DB2.

Environment

CA Workload Automation Agent for Databases

Resolution

Add following statement into agentparm.txt

jdbc.drivers=com.ibm.db2.jcc.DB2Driver