News
Abstract
The RECORD_LOCK_INFO view returns one row for every record lock for the partition.
The values returned for the columns in the view are closely related to the values returned by Retrieve Record Locks 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.RECORD_LOCK_INFO
For complete detail, visit this IBM Documentation page: RECORD_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
ibm11128681