473,224 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

how to release appropriate locks using CLP

Hi all,
I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation
which results in a deadlock created by appl1 & appl2.Now, I want to
release one of the locks (using CLP, not Control Center) so as to
release the deadlock.now how can I be sure that I am releasing the
appropriate lock held by one of the aplication (say appl2). Using
Control center -Application list -show lock chains we can say which
applications hold which lock & we kill the appropriate applications so
as to release the appropriate lock.now how to do this using CLP?

Any suggestions are highly appreciated.

Thanks in Advance.

Nov 13 '06 #1
1 2964
"satish mullapudi" <sa***************@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
Hi all,
I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation
which results in a deadlock created by appl1 & appl2.Now, I want to
release one of the locks (using CLP, not Control Center) so as to
release the deadlock.now how can I be sure that I am releasing the
appropriate lock held by one of the aplication (say appl2). Using
Control center -Application list -show lock chains we can say which
applications hold which lock & we kill the appropriate applications so
as to release the appropriate lock.now how to do this using CLP?

Any suggestions are highly appreciated.

Thanks in Advance.
You cannot "release the deadlock" because as soon as a deadlock is detected
by DB2, one of the applications is cancelled to let the other one continue.

Maybe you are talking about an infinite lock wait. By default, locktimeout
is set to infinity (-1) in the db config. If you change that to 30, all lock
waits will be resolved by DB2 in 30 seconds, etc.

db2 connect to database-name
db2 update db cfg using locktimeout 30
Nov 13 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: db2group88 | last post by:
hi, we are using db2 udb v8.1 on windows with type 4 db2jcc driver, our application use jdbc to create statement and execute query, i would like to know when the application connect to DB2 blow up...
1
by: Carlos Lozano | last post by:
Hi, I have a multithreading application that reads and writes to com ports. The debug version works with no problems, but the release version don't. They are the same code, the difference is...
3
by: John C Kirk | last post by:
I've come across an odd situation, where doing a floating point division produces different results for the same numbers. Basically, there are 4 ways to run this application: A) Debug build,...
1
by: Jürgen Kahrs | last post by:
Hello, The beta alpha release (xgawk-3.1.5-beta.20060401) of the xmlgawk project is now available at SourceForge. http://sourceforge.net/projects/xmlgawk/...
4
by: rawheiser | last post by:
Existing Stored Procedure, has been running well on SQL since 7.0. (but needed some tweaking to migrate to 2000). Now all of a sudden after installing SP4 of SQL 2000, this process slows down,...
0
by: satish mullapudi | last post by:
Hi all, I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation which results in a deadlock created by appl1 & appl2.Now, I want to release one of the locks (using CLP, not Control...
1
by: janki | last post by:
When through one webservice we are doing "update" operation and before doint "commit" , that instance crashes..now if i want to create some recovery service..i need to release locks ..but when i try...
2
by: Piotr Sobolewski | last post by:
Hello, I have such program: import time import thread def f():     global lock     while True:         lock.acquire()         print thread.get_ident()
6
by: Delaney, Timothy (Tim) | last post by:
Piotr Sobolewski wrote: 1. You should use the threading module. 2. No need for the "global lock" statement here - you're not rebinding the name "lock". 3. These aren't daemon threads, so...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.