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

Article Id: 4447

Status: Published

Updated On: 14-02-2018 08:19

Legacy Id: TEC1730756

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