RE: File Lock Problem

Running out of ideas. What OS/400 release are you on? Are you up to date on
PTFs (cumulative package, DB2/400 group PTF and Toolbox PTFs)? What
transaction isolation level are you running at on your connection?

You are sure you are covered with respect to commits? I think on the Work
with Job screen for the QZDASOINIT job you can use option 16 to display the
commitment control status. Take option 5 and then hit PF6 and then select
Record level (and later maybe object level), and see if there are any
pending changes.

Frances Stewart
WebSphere Application Server for iSeries 400
IBM Rochester


"Vijosh A." <vijosh@systsoft.com>@midrange.com on 12/21/2000 12:27:50 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   <JAVA400-L@midrange.com>
cc:
Subject:  RE: File Lock Problem



Thanks for the reply.

Initially at application login time this is the wrkobjlck screen dump -

Opt   Job          User         Lock      Status          Scope     Thread

  (There are no locks for the specified object)


Frances, I tried using ALCOBJ. This is the screen dump of wrkobjlck.

Opt   Job          User         Lock      Status          Scope     Thread
      QPADEV0001   QSECOFR      *SHRRD     HELD           *JOB
      QZDASOINIT   QUSER        *SHRRD     HELD           *JOB


The first line (QPADEV0001) is the lock obtained by ALCOBJ. *Excl lock
could
not be obtained, so just to illustrate my problem i have obtained a shared
lock.

Here the second lock  (QZDASOINIT) is the lock obtained by the java
program.
I have closed all the prepare statements and resultsets. Exited the
program.
But the lock remains. I'm still in the application and so the connection is
alive.

Can any one suggest a solution for  this problem ?

Thanks

Cheers
Vijosh



>From the Desk of :

Vijosh A.
Systems & Software
123, SDF 4, SEEPZ
Andheri (E), Mumbai.

Tel : (91-22) 829 0803/0075
Fax : (91-22) 829 2578





-----Original Message-----
From: owner-java400-l@midrange.com
[mailto:owner-java400-l@midrange.com]On Behalf Of Frances Stewart
Sent: Wednesday, December 20, 2000 9:18 PM
To: JAVA400-L@midrange.com
Subject: Re: File Lock Problem



That works as well. Depends on what you are used to regarding ease I
suppose. ALCOBJ OBJ(library/file *FILE *EXCL *FIRST)  should do the trick.
You need to follow up with a DLCOBJ also (whereas with interactive SQL, I
just exit the SQL session).

Actually I couldn't remember the command and so I was being lazy :-)

Frances Stewart
WebSphere Application Server for iSeries 400


"James H. H. Lampert" <jamesl@hb.quik.com>@midrange.com on 12/20/2000
08:42:00 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:
Subject:  Re: File Lock Problem



Frances Stewart wrote:
> . . .  One easy way to determine if a lock is a pseudo lock
> or a real lock is to attempt to get an exclusive lock on
> the object using interactive SQL specifying SQL statement
> LOCK TABLE lib/file IN EXCLUSIVE MODE.
. . .

Wouldn't an ALCOBJ be even easier?

--
James H. H. Lampert
Professional Dilettante
http://www.hb.quik.com/jamesl
Have you visited http://www.thehungersite.com today?
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



--------------------------------------------------------------
Systems & Software, Mumbai, India

     Sent using "The PostMaster" by QuantumLink Communications

   One Internet account, unlimited personal e-mail addresses
Get your free copy of "The PostMaster" at http://www.qlcomm.com/


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---