• Subject: File Lock Problem
  • From: "Vijosh A." <vijosh@xxxxxxxxxxxx>
  • Date: Tue, 19 Dec 2000 14:36:13 +0530
  • Importance: Normal


We are developing java based application. The programs access DB2/400 thru
as400JDBC driver. One connection to the database is made at user login. This
connection is used by all calling programs  for accessing data from the
database. I face the following problem  -
                We continously insert/update records into a physical file. 
After a few
records, Insert/Update fails. Now to enter a record we need to exit out of
the whole application.
                'wrkobjlck' on the file shows that for each update/insert a 
shared lock is
made. I tried an explicit commit. But the lock remains. This is what the
wrkobjlck sceen shows -

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

Can anybody suggest a solution for this problem.



>From the Desk of :

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

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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.