Tim,
You need an "event monitor," which is a standard part of DB2 UDB. See
"CREATE EVENT MONITOR" in the SQL Reference manual. In addition, the
"System Monitor Guide and Reference" has a detailed description of how to
create an event monitor for deadlocks, collect and analyze the statistics.
Steve Westfall
Equifax, Inc.
Lombard, Illinois
Tim_Traxson@jb
hunt.com To: [EMAIL PROTECTED]
Sent by: cc:
owner-db2eug@l Subject: [DB2EUG] Timeout/Deadlock
Tracking
ugwash.org
01/31/2002
12:25 PM
Please respond
to Tim_Traxson
Hello list,
I am wanting to know how to track timeout/deadlock numbers on a monthly
basis
on DB2 UDB for NT and AIX. Is this something that I would have to have a
third party
tool to accomplish or is there a setting or switch I can enable on the
server to write
a message to a log file on the server every time there is a timeout
/deadlock? Or is
this something that is already done as a standard installation of DB2 UDB
on the
distributed environments.
We currently run UDB version 7.2 and 6.1 on AIX and version 6.1 only on NT.
Any help or suggestions would be appreciated.
Thanks,
Tim Traxson
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
