RE: Finding offending RPG program causing locks on files

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 06/28/2019
02:57:07 PM:

It looks like this link is more likely something I would want. I
wonder if the that lock detection thing is what the
QSYS2.RECORD_LOCK_INFO view is doing under the covers. Unfortunately
when I issue the following SQL it never returns any data. Been
running for about over 3 minutes now without returning lock details:

SELECT * FROM QSYS2.RECORD_LOCK_INFO

Is anyone able to successfully execute that SQL statement?

RECORD_LOCK_INFO is a user-defined table function. So, you must
wrap it with the SQL TABLE() function (and probably add some parameters).


Sincerely,

Dave Clark