Re: Where's lock coming from?

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

Well there's no cursor, but other than that it looks like a possibility.
It seems like a simple enough thing to try.

Thanks

date: Tue, 5 Jan 2021 20:56:34 +0000
> from: Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
> subject: Re: Where's lock coming from?
>
> I suspect that  you are running into this.
> https://www.ibm.com/support/pages/pseudo-closed-cursor-faq
>
> On Tue, 2021-01-05 at 14:49 -0600, Justin Taylor wrote:
>
> I have a never-ending job that waits on *DTAQ requests.  That job calls an
>
> RPGLE *PGM object.  That RPG program runs in the same activation group as
>
> the caller and ends with LR set to true.  A few weeks back, I added a
>
> static SQL DELETE (delete from TABLE where KEY like :local_variable).
>
> Since then, we've had intermittent issues of these jobs holding locks on
>
> TABLE.  The program has no commitment control and "Close SQL cursor" is set
>
> to *ENDMOD (although I don't think that applies here).
>
>
> I'm trying to determine what's causing the lock and how to eliminate it.
>
> Does anyone have any suggestions to try?
>
>
> TIA