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

Document ID : KB000004447
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

 

Environment:
CA Workload Automation Agent for Databases
Cause:

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

Resolution:

Add following statement into agentparm.txt

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