Hi

Take a snapshot in case of lock

GET SNAPSHOT FOR {DATABASE MANAGER | ALL [DCS] DATABASES |
ALL [DCS] APPLICATIONS | ALL BUFFERPOOLS | [DCS] APPLICATION
{APPLID appl-id | AGENTID appl-handle} | FCM FOR ALL DBPARTITIONNUMS |
LOCKS FOR APPLICATION {APPLID appl-id | AGENTID appl-handle} |
{ALL | [DCS] DATABASE | [DCS] APPLICATIONS | TABLES |
TABLESPACES | LOCKS | BUFFERPOOLS | DYNAMIC SQL [write to file]}
ON database-alias} [AT DBPARTITIONNUM db-partition-number | GLOBAL]

And I guess you can check the app handle by

DB2 LIST APPLICATIONS

Hope this helps you


Thanks,
Nadeem Khan
-----Original Message-----
From: Balrinder Singh Balwant Singh
[mailto:db2udbdba-ezmlmshield-x66732919.[Email address protected]
Sent: Friday, August 24, 2007 6:54 AM
To: LazyDBA Discussion
Subject: Deathlocks ( Urgent )

Dear Guru's,



I would like to check, currently I have lots of deathlocks on the
application connected to the DB. Is there anyway I can check for the
Application Handler Number which causes the deathlocks so that I can
force it out.



Thanks.



Regards,

Balrinder Singh



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.


DB2 & UDB email list listserv db2-l LazyDBA home page