If you are lucky enough to be on UDB V9.1 FP4 or higher, you can try the new
registry variable kid on the block: DB2_CAPTURE_LOCKTIMEOUT.
This will log lock timeouts as they occur, in separate text files in the
DIAGPATH. The logged information identifies: the key applications involved
in the lock contention that resulted in the lock timeout, the details about
what these applications were running at the time of the lock timeout, and
the details about the lock causing the contention. Information is captured
for both the lock requestor (the application that received the lock timeout
error) and the current lock owner. Well, that's what it says in the
Information Center anyway.
Otherwise you're down to continuous snapshotting (SYSIBMADM.LOCKWAITS,
SYSIBMADM.SNAPLOCK
OR SYSPROC.SNAP_GET_LOCKWAIT at V9.1, or the more traditional GET SNAPSHOT
FOR LOCKS at V8). All of these are readily available in the Information
Center.

Regards
Alex Levy
Sustainable Software Ltd.

> -----Original Message-----
> From: pavan
> [mailto:db2udbdba-ezmlmshield-x23731876.[Email address protected]
> Sent: 27 March 2008 15:51
> To: LazyDBA Discussion
> Subject: capturing lock time out in db2
>
> All,
> I understand that we cannot capture lock time out in
> db2diag.log with a diaglevel of 3 and we do not want to pump it to 4.
>
> Can we capture in real time basis the details of a lock time out ?
> What I am looking for is:
> 1) capturing the tables involved in a lock time out
> 2) capturing the sqls involved in a lock time out
> 3) capturing the application that is responsible for the lock
> time out.
>
> Please advise me on if you could implement your idea successfully.
> I did go through lot of documents but nothing really was helpful.
>
> Thanks.
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
>
>
> E-mail message checked by Spyware Doctor (5.5.0.212) Database
> version: 5.09490 http://www.pctools.com/en/spyware-doctor/





E-mail message checked by Spyware Doctor (5.5.0.212)
Database version: 5.09490
http://www.pctools.com/en/spyware-doctor/

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