Re: Tracking open connections

[Donald Whittaker <donald_whittaker@xxxxxxxxx>]

Perhaps if you journalled the table (including opens
and closes) you might be able to prove (or disprove)
this theory.
If the lock is encountered from the JT400 side, and if
the code is still in development, maybe a CommandCall
for wrkobjlck could be inserted.

Good luck,
Don

--- David Gibbs <david@xxxxxxxxxxxx> wrote:

> I'm trying to help some non iSeries oriented
> developers track down a 
> problem with DB2 400 using JT400.
> 
> The problem is: We are issuing an alter table
> command, but getting a 
> "Row or table xxxx is in use" error.
> 
> I'm 99.9% sure the problem is that we still have a
> connection open to 
> the database that is holding a lock on the XXX table
> when are try to 
> issue the alter table command.
> 
> Any suggestions on how I can prove this and/or
> identify the connection?
> 
> The operations happen quite fast, so I can't really
> just monitor the 
> QZDASOINIT jobs.
> 
> Thanks!
> 
> david
> 
> --
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 



                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail