MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Connectivity



fixed

<Luis>
I've just tried to create a quick table, and keep getting the following
informational message: (seemingly one per read)
:

JDBCGATE: SQLCODE: 0 SQLSTATE 00000 DBORAP ActivationGroup: 2

Any ideas?
</Luis>

that's no bug, it's a feature. ArdGate is writing to the joblog the original SQLSTATE coming from the remote database and the SQLCODE, which is derived from ArdGate from the original SQLSTATE. I've changed this a couple of months ago, because DB2 makes its decisions based on the SQLCODE and sometimes it exchanges the SQLSTATE, coming from the ARDPGM with some value, it likes better and the original information has disappeared. This message should be the first source of information if something unexpected is happening, second step would be to google with this SQLSTATE and the brand of your remote database. Third step would be to have a look to the java logfile, final step would be to change log4j.properties to debug level and send the logfile, a minimized example and some description to D*B to his well known eMail adresse and hopefully he has some hints and in rare cases a patch for a bug.

D*B





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact