Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Collector Studio DB2 JDBC driver issue

Created: 03 Oct 2012 • Updated: 04 Oct 2012 | 2 comments
This issue has been solved. See solution.

I am running into an issue with collector studio when attempting to access a DB2 database via jdbc. I connected to this database using jdbc via SQL Squirrel and following the instructions on this site. http://ashraffouad.blogspot.com/2012/02/configure-squirrel-sql-to-connect-to.html

The problem I am running into is that it appears I need both jars (db2jcc.jar and db2jcc_license_cu.jar) for the jdbc connection to function properly. I tried removing db2jcc_license_cu.jar from the SQL squirrel driver I created and it does not work in that case. Is it possible to include both jars in the Sensor Property List?

When I attempt to just put in these values for the sensor I get an error when testing the sensor:

JDBC Drivers Directory | C:\Program Files\IBM\SQLLIB\java

DatabaseDriver | db2jcc.jar

JdbcDriverFiles | com.ibm.db2.jcc.DB2Driver

com.symantec.cas.ucf.sensors.InitSensorException: Cannot find JDBC driver class "db2jcc.jar". It is possible an incorrect "JDBC Drivers Directory" was specified. at com.symantec.cas.ucf.sensors.DB.DBSensor.init(DBSensor.java:1852) at

Odd error because I can see db2jcc.jar in that directory.

Comments 2 CommentsJump to latest comment

sviridov's picture

Use property:

JdbcDriverFiles = db2jcc.jar;db2jcc_license_cu.jar

All my posts are made by google translator!

SOLUTION
DMX Engineer's picture

Hi all,

I am a new starter to IBM DB2 collector, if I choose to install the collector on Information Manager, do I need to install Symantec Event Agent on DB2 Machine???

Could you please provide the full steps on DB2 collector installation