-
1. Re: Help with IBM DB2 discovery
Andrew WatersMay 16, 2012 7:59 AM (in response to Ravi NameToUpdate)
1 of 1 people found this helpfulYour 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%
-
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.
-
3. Help with IBM DB2 discovery
Andrew WatersMay 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)
-
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.
-
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.
-
6. Help with IBM DB2 discovery
Andrew WatersMay 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?
-
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.
-
8. Help with IBM DB2 discovery
Andrew WatersMay 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.
-
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.
-
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.