Who is locking the Record:

Facing record lock problem on iSeries is very. Assume that there is a physical file that can be accessed by a number of users at the same time; you want to update a record that is locked by another user. How do you know which user has locked that particular record?
DSPRCDLCK command on the iSeries that gives you this information Type DSPRCDLCK on the command line and take a prompt by pressing function key F4. Fill the required parameters, such as the name of physical file, library name, member name, etc. and press enter.
It's as simple as that!
You will get a screen that shows you the locked record number, name of the job and the user who has locked that record, the job number, status, and the type of lock.