This is a discussion on how to release appropriate locks using CLP within the DB2 forums, part of the Database Server Software category; --> Hi all, I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation which ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. satish |