Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock waiting

Status
Not open for further replies.

lsuciu

Programmer
May 14, 2002
2
RO
If a connection is in "lock waiting" status it never obtain the lock. Maybe is something misconfigured?
 
It can't be "never"...One of the applications connected to your database is holding your resources and doesn't free them.If you are connecting to your database by a program you create,don't forget to commit the changes after successful modification such as an update or a delete etc.
Also there is a parameter named as lock timeout.It is the period of time of an application waiting to get a lock.If the time becomes up,then db2 raises an error message indicating that lock time out had occurred. Salih Sipahi
Software Engineer.
City of Istanbul Turkey
openyourmind77@yahoo.com
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Replies
3
Views
136
Member 310024
M

Part and Inventory Search

Sponsor

Back
Top