RE: Finding offending RPG program causing locks on files

That doesn't appear to be the case, it appears to be exposed as a SQL View that you can query directly as indicated here:

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqviewrcdlockinfo.htm

-----Original Message-----
From: dlclark@xxxxxxxxxxxxxxxx <dlclark@xxxxxxxxxxxxxxxx>
Sent: Friday, June 28, 2019 2:10 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: 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