Q: How can I determine which programs have a given record locked?

A: Paul Conte published an RPG IV program that shows how to use the QDBRRCDL system API to get a list of all jobs holding or waiting for a lock on a particular record. You can obtain the program at
http://www.iseriesnetwork.com/features/newmf/Article.cfm?ArticleID=10383.

You'll also need RPG IV program RtvLckMsg for the above code, which is available at
http://www.iseriesnetwork.com/features/newmf/Article.cfm?ArticleID=10203.