By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,692 Members | 1,465 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,692 IT Pros & Developers. It's quick & easy.

how to release a table lock..?

deepuv04
Expert 100+
P: 227
hi,
One of the table in my database is got locked. actually it has many dependencies in the database. i don't know where it has get locked.

how can i unlock the table with out restarting database or system. any help is appriciated.


thanks
Jan 29 '08 #1
Share this Question
Share on Google+
6 Replies


ck9663
Expert 2.5K+
P: 2,878
hi,
One of the table in my database is got locked. actually it has many dependencies in the database. i don't know where it has get locked.

how can i unlock the table with out restarting database or system. any help is appriciated.


thanks
kill the process that locks it..

-- ck
Jan 29 '08 #2

deepuv04
Expert 100+
P: 227
kill the process that locks it..

-- ck

Thanks for reply...
can you please tell me how to know which process is get locked or what are the processes are running on the database server....?

thanks
Jan 30 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Thanks for reply...
can you please tell me how to know which process is get locked or what are the processes are running on the database server....?

thanks
on your sql 2000 enterprise manager , go to Management - Current Activity - Process Info. check the Blocked By Column to get the process id that's locking your process. click the process id. right-lick then choose Kill Process


-- ck
Jan 30 '08 #4

deepuv04
Expert 100+
P: 227
on your sql 2000 enterprise manager , go to Management - Current Activity - Process Info. check the Blocked By Column to get the process id that's locking your process. click the process id. right-lick then choose Kill Process


-- ck

Thank you for your kind reply.... it is really very helpful for me
Jan 31 '08 #5

P: 2
Yes , Killing the process the is the answer of above question which removes the lock from table in database, but

Offcourse , it will terminate the current process which saves my data into database.





My Scenarion : We are processing policies and we are having concurrentConsumers=20; so while working in concurrent environemnt,
1st consumer will locks the table for manipulation,
2nd consumers will locks the table for manipulation,
3rd consumers will locks the table for manipulation,
4th consumers will locks the table for manipulation,
5th consumers will locks the table for manipulation,
.
.
.
.
and
20th consumers will locks the table for manipulation,

Here, tables are locked so it may be possibility that 5th consumer is waiting for releasing that lock.

So I have to avoid "LockAcquistionException".

Please help me in this.

Many thanks in advance.

Waiting for quick reply.
Feb 6 '14 #6

P: 1
I am also facing the same issue .
please help on this.

Many thanks in advance
Feb 6 '14 #7

Post your reply

Sign in to post your reply or Sign up for a free account.