IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Deadlock- how to identify who used the table?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
fahir83

New User


Joined: 27 Jan 2006
Posts: 22

PostPosted: Thu Nov 15, 2007 9:13 pm
Reply with quote

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
View user's profile Send private message
TG Murphy

Active User


Joined: 23 Mar 2007
Posts: 148
Location: Ottawa Canada

PostPosted: Thu Nov 15, 2007 11:54 pm
Reply with quote

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
View user's profile Send private message
fahir83

New User


Joined: 27 Jan 2006
Posts: 22

PostPosted: Fri Nov 16, 2007 3:36 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top