News
Abstract
The OBJECT_LOCK_INFO view returns one row for every lock held for every object on the partition.
The values returned for the columns in the view are closely related to the values returned by Retrieve Lock Information API and Retrieve Lock Request Information API. Refer to the APIs for more detailed information.
When querying this view, you should use a WHERE clause to restrict the result set to avoid excessive use of system resources.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.OBJECT_LOCK_INFO
For complete detail, visit this IBM Documentation page: OBJECT_LOCK_INFO view
Enhanced with IBM i 7.6 SF99960 Level 2 and IBM i 7.5 SF99950 Level 11:
- Add the JOB_NAME_SHORT, JOB_USER, and JOB_NUMBER columns
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
03 October 2025
UID
ibm11128675