Re: Find source of object lock?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SQL Pseudo-closed cursor?

*SHRRD isn't unusually now-a-days with SQL being used.  What problem is it
causing?

Charles

On Mon, Feb 8, 2021 at 3:13 PM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

> I have a never-ending program that every few weeks holds an unexpected
> object lock on a PF.  It takes several hours for the user(s) to report the
> problem, and I can't say for sure when it starts.  I've been through the
> code, but nothing obvious jumps out at me.  A 5250 WRKOBJLCK command shows
> multiple *SHRRD locks for the offending job.
>
> Can anyone offer any suggestions to track this down?
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com