DB2 "get snapshot for locks on xxxxxx" will give you the application
handle that is holding the lock xxxxx is the database name






"Khan Nadeem " <db2udbdba-ezmlmshield-x75217549.[Email address protected]
08/24/2007 01:36 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Deathlocks ( Urgent )







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.



---------------------------------------------------------------------
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



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