View previous topic :: View next topic
|
Author |
Message |
fahir83
New User
Joined: 27 Jan 2006 Posts: 22
|
|
|
|
Hi
One of our table often went into deadlock. i want to know
1. who are all accessed the table at that time?
2. please let me know if there is any db2 system logs (with path name )showing "what are all the activities went on that table at that time"?
We are using v8.1 for z/OS
Thanks in advance for your help |
|
Back to top |
|
|
TG Murphy
Active User
Joined: 23 Mar 2007 Posts: 148 Location: Ottawa Canada
|
|
|
|
As you said yourself - the DB2 logs will tell you...
1. Who suffered the deadlock or timeout.
2. Who caused the deadlock or timeout.
3. The table or resource that was locked.
Our various DB2 subsystems can be viewed in the same way as you would view a running batch job. For example, when I want to view our unit test subsystem I select the running job DBN5MSTR and view the log.
Note that in Unit Test, use of the debugger can cause deadlock/timeouts. A debug session can last 15 minutes or so and as a result the locks taken will stay in effect for that long... |
|
Back to top |
|
|
fahir83
New User
Joined: 27 Jan 2006 Posts: 22
|
|
|
|
Hi
I got the logs.
11/15 10.07.29 D2E2MSTR DSNT501I -D2E2 DSNILMCL RESOURCE UNAVAILABLE
CORRELATION-ID=stceway.exe
CONNECTION-ID=SERVER
LUW-ID=GA0DF4D5.C350.473C191B0242=264194
REASON 00C90088
TYPE 00000304
NAME GX01GDMP.GD60S0 .X'0861DC' '.X'08'
can i know who caused the deadlock? in otherwords how can i know why the deadlock has happened (the reason for deadlock) |
|
Back to top |
|
|
|