topic Re: Table with locks in Application Development and Automation Discussions

Table with locks

Former Member — Fri, 01 Jun 2007 08:46:20 GMT

Hello

I have locked my table TAB1 using enqueue_lockedObject. Now in my code I would like to check if there are any locks on table TAB1. I don't want to use transaction sm12, but I want to know the name of table where information about locks are store.

Greetings

Re: Table with locks

Former Member — Fri, 01 Jun 2007 08:58:13 GMT

Hi,

ABAP locks are logical, not physical, so if you use an ENQUEUE function to lock a table, table updates do not release the locks. You have to use a DEQUEUE function to release the lock.

And since they are logical, not physical, the database is not enforcing the locks. It's up to individual programs to set, check and release them.

it's not the way ABAP works. The commit does not release the ABAP locks.

There will be physical locks at the database level, but we don't have much control over them.

Regards

Re: Table with locks

santhosh_patil — Fri, 01 Jun 2007 09:00:29 GMT

Hi,

Check with FM

<b>ENQUEUE_READ

ENQUE_READ</b>

Patil

Re: Table with locks

Former Member — Fri, 01 Jun 2007 09:13:44 GMT

Hi all

My problem is not to release the lock that I have made but I want to know the table where is information what locks are active.

I will try FM enqueue_read.

Thanks

Re: Table with locks

santhosh_patil — Fri, 01 Jun 2007 09:20:21 GMT

Hi,

Try to debug the sm12 transaction.

U may get any hint...

---Patil

Re: Table with locks

Former Member — Mon, 04 Jun 2007 06:37:18 GMT

read_enqueue solved problem.