Hi James,
I haven't picked up the latest fixes from the head yet so if the fix you and Oliver made was in there and after the beta release then I don't have it yet.
The changes were part of the beta, so... :(
I'm not an expert on DB2 (on Windows) so I seem to have logging enabled but I'm not sure where to check for the log of all sql statements. I have opened the journal but it doesn't seem to have a lot of information. Where would I find the statement log? Also the logging I have enabled for my database is the default, called "circular logging", which may be less detailed than the other option they give me. Should I enable the other logging method? Circular logging has automatic rollover but the other method doesn't.
Unfortunately, I think you more know about DB2 than I do. I was never even able to find a working client download! DB2 should be able to offer you some sort of statement log; it will likely be a debug feature since it shouldn't normally be needed. Maybe your driver has a parameter you can pass? I'd recommend searching the web or finding a DB2 admin that you can ask. If you've got support IBM should be able to tell you straight up.
I think there are also tool available to monitor a jdbc connection and watch what's going on. Maybe you can find one of those that will monitor what's going on?
-James
Thanks, Warwick
-----Original Message-----
From: James Mason [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 9:47 PM
To: Slide Users Mailing List
Subject: Re: DB2 server not responding after short time using Slide 2.1 beta
Warwick,
This sounds suspiciously like a deadlock condition to me. I ran into something similar with MySQL, and I *thought* that Oliver and I had made changes that would ensure it couldn't happen, but maybe not.
If possible can you get a log of all the sql statements executed by Slide against the database? If your log includes a connection id look to see if the connection id suddenly changes. That should help you pinpoint the sql statement that's causing the problem .
From looking at enumerateLocks() I don't see any way that statement could cause a deadlock. This makes me think the problem is probably somewhere else and it's just surfacing when that statement runs.
-James
Warwick Burrows wrote:
Hi,
I've run into a serious problem with the slide 2.1B1 server where the DB2 server hangs executing a select statement in the enumerateLocks() method of the StandardRDBMSAdapter in the server. Once the DB server is hung it won't even respond to simple select statements from the DB2 cli. Though it will respond to "list tables" commands. When I run a select from the DB2 cli (eg. select * from URI) and it hangs I can hit ctrl-C at the DB2 cli prompt and it will cancel the request and return -- but no data comes back with it. Of course the slide server will wait indefinitely for the sql request to come back. Has anybody else had this problem with Slide 2.1B1 and DB2? A new DB2 RDBMS adapter was introduced in 2.1B1 as well as a new DB2 schema. I didn't see this problem with 2.1M1 but its happening frequently with 2.1B1. In fact its such a problem my project no longer works and we're grounded until we can find a fix.
Thanks, Warwick
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
