Skip to content

Instantly share code, notes, and snippets.

@phpdave

phpdave/ViewingLocksinDb2forIbmiV7R2TR3 V7R1TR11.sql

Created October 5, 2015 15:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phpdave/74f419f54b0e335836fd to your computer and use it in GitHub Desktop.
Save phpdave/74f419f54b0e335836fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ViewingLocksinDb2forIbmiV7R2TR3 V7R1TR11.sql
--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