If you're using datasources to connect, i suggest you use the trace
See Taking a Trace with the Universal JDBC Driver
There is also a tool called db2drdat (DRDA Trace) that could help you see
(os command line tool)
To get mode output in the db2diag.log file, you can set db2 Diaglevel to 4
(db2 update dbm cfg using diaglevel 4)
Are you using the driver with type=4 or ?? (default is 2)
This would tell us if networking problems is a possibility.
When it hangs, you can also see if you get locking problems using
db2 get snapshot for locks ....
Any Jboss logs information available?
"Thomas Sigdestad" <_delete_tsienonic.com> a écrit dans le message de
news:3f61cab6$1news.wineasy.se...server.log> I'm running my application on two separate RH8 linux bokses using Jboss
> 3.0.7 on the appserver and db2 8.1 fp3 on the db server.
> I am also running db2 8.1 fp2 on my appserver which seems to be working
> perfectly fine towards the same apps.
> My problem is that randomly the connection seems to stop up for 10-20
> seconds before it continues. I also get the following error in myThere> file
> (jboss)2003-09-12 15:04:47,498 ERROR [STDERR] -99999
> . And it seems to occur approx. at the same time as the server hangs.server.> are no error messages in the db2diag.log files.
> It is really strange that this only fails when accessing the remotelocal> I am using the latest fp3 jcc driver to connect both locally and to the
> remote db server.
> The databases are exactly the same since I am using a restored db on the
> remote host. The instances on both servers have been set up with the same
> parameters, as well as the databases.
> I do not reakon this to be a jboss problem, as it works fine with the> databases.
> If this is a fp3 problem is the solution to reinstall db2 with fp2?
> Hope someone out there has an answer.
> I would be truly greatful.
> Thomas Sigdestad