Hi all
today while maintaining purchase orders we got an error 601 refrence table lockaed. cannot continue tdpur4101m000.
can ne body help us how to solve this problam.
and what could b the possible reason of this problam.
thanx in advance
regds
Gaurav gupta

Hi,

Error 601:
-------------
601 EREFLOCKED
Reference table is locked action: wait until lock will be released or remove lock
Maybe you can do it by TTSTPDELLOCKS.

GN

Maybe there is a process that is holding a lock on the record?

You could take a look into the Application Locks session (ttadv9598m000), maybe that helps?

If there is no application lock or no process is currently running that should lock the table, re-boot the server. That should clear the table lock.

Yes you have to shutdown the system to clear table lock. but in Informix you can find the process which is having lock on the table and if u kill that process the lock would be removed.

Rebooting a system to clear a table lock is a bit of a drastic action. If you use Oracle you can check v$locked_object to give you more information on current locks. With that information you may be able to determine which process is holding the lock. At most, restarting your database and clearing the 'Application Lock' table should do the trick.