topic Re: Table Locks in Application Development and Automation Discussions

Table Locks

Former Member — Thu, 23 Nov 2006 21:04:59 GMT

Hi Folks,

I was wondering if a Insert stament releases db table locks. For example:

1. Lock DB Table ZXX1

2. Insert to DB Table ZXX2.

Does step 2 releases the lock set in the step 1?

Thanks for your help.

Kind Regards,

Gilberto Li

Re: Table Locks

Former Member — Thu, 23 Nov 2006 21:08:54 GMT

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.

Rob

Message was edited by:

Rob Burbank

Re: Table Locks

Former Member — Thu, 23 Nov 2006 21:16:55 GMT

Hi Rob,

Thanks for your reply.

Your answer makes sense.

Although i'm thinking if an Insert statement on ABAP is still logical and not physical and it becomes physical until a commit work. As a consequence of this, a Insert statement could release a lock?

Does this makes sense at all?

Regards,

Gilberto Li

Re: Table Locks

Former Member — Thu, 23 Nov 2006 21:30:30 GMT

Yes, I suppose it makes sense, but 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.

Rob

Re: Table Locks

Former Member — Thu, 23 Nov 2006 22:15:56 GMT

Thanks Rob.

Regards,

Gilberto Li

Re: Table Locks

Former Member — Thu, 23 Nov 2006 22:35:21 GMT

Glad to help.

rob