10 Replies Latest reply: May 17, 2012 3:57 AM by Ravi NameToUpdate

Help with IBM DB2 discovery

Ravi NameToUpdate May 16, 2012 6:01 AM

I am trying to set up DB2 database discovery in ADDM. Since it has to be configured as a custom driver, I followed the doc and tried but no luck. Let me mention what I have done:

1. Copy db2jcc.jar from a DB2 installation on different server

2. Created a properties file with the below content and restarted the service

driver.name= IBM DB2 UDB Driver

driver.url=jdbc:db2://host[:port]/]database_name]

driver.class=com.ibm.db2.jcc.DB2Driver

Error on UI: Invalid: The driver's configuration file contained an invalid setting: The specified JDBC URL did not contain an endpoint variable

Please help.

Thanks in advance.

1. Re: Help with IBM DB2 discovery

Andrew Waters May 16, 2012 7:59 AM (in response to Ravi NameToUpdate)
Your driver URL is more likely to be something like

driver.url=jdbc:db2://%endpoint%[:%port%][/%database%]

so that the endpoint, port and database fields can be filled in from TPL. The system is complaining about the lack of %endpoint%
Report Abuse

Like Show 0 Likes (0)
2. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 16, 2012 8:35 AM (in response to Andrew Waters)

Hi Andrew,

Thank you Andrew.

That fixed to a little extent. However I see a red cross for driver status now and an option to enable but it does not get enabled. Am I missing anything else ? where can I find a log for this

Ravi.
Report Abuse

Like Show 0 Likes (0)
3. Help with IBM DB2 discovery

Andrew Waters May 16, 2012 9:38 AM (in response to Ravi NameToUpdate)

Make sure you don't have spaces in the driver.class line.

The other thing you will need is the DB2 licence jar (which I believe is called db2jcc_licence_cu.jar)
Report Abuse

Like Show 0 Likes (0)
4. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 16, 2012 10:09 AM (in response to Ravi NameToUpdate)

No spaces and licesne jar is included. Still no luck

Thank you for helping.

Ravi.
Report Abuse

Like Show 0 Likes (0)
5. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 16, 2012 10:10 AM (in response to Ravi NameToUpdate)

Where can I find logs for this?

Thanks,
Ravi.
Report Abuse

Like Show 0 Likes (0)
6. Help with IBM DB2 discovery

Andrew Waters May 16, 2012 11:57 AM (in response to Ravi NameToUpdate)

It will log to $TIDEWAY/log/tw_integrations-ui.log though I doubt that will tell you anything as all it will try to do is load the class.

What is the name of the properties file?
Where did you put the jars?
Report Abuse

Like Show 0 Likes (0)
7. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 16, 2012 12:06 PM (in response to Andrew Waters)

Ok. db2jcc.properties.... I have put license, dirver and properties under ../tideway/data/custom/jdbcdrivers/

Thanks,
Ravi.
Report Abuse

Like Show 0 Likes (0)
8. Help with IBM DB2 discovery

Andrew Waters May 16, 2012 1:03 PM (in response to Ravi NameToUpdate)

I imagine the problem is that the system fails to load db2jcc_licence_cu.jar

Try putting only this jar file in /usr/tideway/java/integrations/lib and restarting the services.

Note: This is not supported and may break in the future.
Report Abuse

Like Show 0 Likes (0)
9. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 17, 2012 3:54 AM (in response to Andrew Waters)

No luck Andrew......I am afraid if I should get the driver jar from a correct source. I copied these jars from server containing DB2 v9.5.0.8

Thanks,
Ravi.
Report Abuse

Like Show 0 Likes (0)
10. Re: Help with IBM DB2 discovery

Ravi NameToUpdate May 17, 2012 3:57 AM (in response to Ravi NameToUpdate)

Have I posted this in the right place..... is there a more specific forum ?

Thanks,
Ravi.
Report Abuse

Like Show 0 Likes (0)