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
+---