I'm trying to clear record one of the physical member files. i used the commands CLRPFM but i got the message: FILE *** in LIBRARY *** is in use. How should I go about to check who is using or unlock the file so I can clear the record?
Use WRKOBJLCK OBJ(library/file) OBJTYPE(*FILE)

End the job, then use WRKOBJLCK again to verify that there are no locks for the specified object.

This was first published in April 2008