Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Deadlock- how to identify who used the table?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: DB2 Deadlock- how to identify who used the table?
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: 149
Location: Ottawa Canada

PostPosted: Thu Nov 15, 2007 11:54 pm    Post subject:
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    Post subject: Reply to: DB2 Deadlock- how to identify who used the table?
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us