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

book

Article ID: 4447

calendar_today

Updated On:

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