Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
--View Object Locks
SELECT * FROM QSYS2.OBJECT_LOCK_INFO
WHERE SYSTEM_OBJECT_NAME = 'CUSTOMER';
--View Record Locks
SELECT JOB_NAME, COUNT(*) AS ROWS_UPDATING
FROM QSYS2.RECORD_LOCK_INFO
WHERE FILE_NAME = 'CUSTOMER' AND
LIBRARY_NAME = 'PRODUCTION' AND
LOCK_STATE = 'UPDATE'
GROUP BY JOB_NAME
ORDER BY ROWS_UPDATING DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.