Re: Persistent File Locks when using SQLRPGLE for Neverending Programs

You're missing the point that the system is working as designed....

The problem is that you've got one program designed to work in a
high-performance multi-user environment and another that expects
basically to be the only process running and thus wants an exclusive
lock on it's resources.

Assuming the application is closing the cursors when it is done, then
the file locks are a result of the system "pseduo closing" the
cursors.

Let me guess, you've got another process trying to do a CLRPFM which
is failing do to the lock on the file...
Easiest fix, quit using CLRPFM and instead use and SQL DELETE.

Otherwise, http://archive.midrange.com/midrange-l/200902/msg00534.html

HTH,
Charles


On Tue, Jul 7, 2009 at 4:23 PM, Rick DuVall<R_C_DUVALL@xxxxxxxxxx> wrote:

Hi everybody,

  I have a number of NEPs that used to

  1. Open files
  2. perform all processing
  3. Close files
  4. Sleep for x minutes
  5. repeat.

  Since we have begun using sql, these programs maintain file locks, on those
  files opened by SQL, while sleeping.

  Since the program is not run by a CL wrapper, there appears to be no
  clear way to relinquish the locks during the sleep period.  The only
  SQL option that appears to apply is the CloSqlCsr and it only supports
  *ENDMOD or *ENDACTGRP neither of which ever occur.  Am I missing something?

  Thanks!


--
Best regards,
 Rick

Systems Manager
Dealer's Auto Auction of Okc
1028 S. Portland
Oklahoma City, OK 73108
(405) 947-2886
mailto:rick@xxxxxxxxxx
http://www.nothingisreal.com/dfki/no-word

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.