Locked tables...

From: cmilner <cmilner_at_connect.com.au>
Date: Mon, 24 May 1999 16:04:08 +1000
Message-ID: <3748EBD8.3F30950A@connect.com.au>

I have a recurring problem in that one table in the database has a row called RECORD_LOCK. Often, the users phone saying they can't access a record, 'record already in use'. The procedure I go through is loggin off all users, updating all locks to 'N' in the table, and then allow them log back on.

Is there a way to trace back from row level which Unix process is locking the table? Unfortunately, simple updating the table from 'Y' to 'N' is not sufficient, the process locking table is still there.

Ta for any help

chris Received on Mon May 24 1999 - 01:04:08 CDT