|
View previous topic :: View next topic
|
| Author |
Message |
soumen2255
New User
Joined: 25 Jun 2008
Posts: 24
Location: Pune
|
|
|
|
Hi,
Can some one help me in guiding how to view the deadlock state for any tables?Do we have any tables in SYSIBM which gives me the table status.
Appreciate the help. |
|
| Back to top |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
| You can view that in your DB2 Master Log. |
|
| Back to top |
|
|
soumen2255
New User
Joined: 25 Jun 2008
Posts: 24
Location: Pune
|
|
|
|
Hi,
Where can we find the DB2 master catalog? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| Deadlock is not a state of a table, it is a state of two threads. |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello soumen,
U can check DB2 MASTER log from Spool |
|
| Back to top |
|
|
|
|
