Hi All,

I'm using DB2 UDB v7.1.
I kick off a set of batch reports in the morning and sometimes they seem to lock each other. Below is the result of the event monitor i set up. The SYSPLAN table seems to be the culprit.

Any Ideas,
Dave


7921) Deadlock Event ...
Number of applications deadlocked: 3
Deadlock detection time: 11-21-2006 08:02:06.384952
Rolled back Appl Id: : 132F015F.A60C.061121080159
Rolled back Appl seq number: : 0001

7922) Deadlocked Connection ...
Appl Id: 132F015F.A60C.061121080159
Appl Seq number: 0001
Appl Id of connection holding the lock: 132F015F.A40C.061121080158
Seq. no. of connection holding the lock: 0001
Lock wait start time: 11-21-2006 08:01:59.457346
Requesting lock as part of escalation: FALSE
Deadlock detection time: 11-21-2006 08:02:06.384952
Table of lock waited on : SYSPLAN
Schema of lock waited on : SYSIBM
Tablespace of lock waited on : SYSCATSPACE
Type of lock: Row
Mode of lock: X
Mode application requested on lock: NS
Node lock occured on: 0
Lock object name: 1545
Application Handle: 194

7923) Deadlocked Connection ...
Appl Id: 132F015F.A40C.061121080158
Appl Seq number: 0001
Appl Id of connection holding the lock: 132F015F.A60C.061121080159
Seq. no. of connection holding the lock: 0001
Lock wait start time: 11-21-2006 08:01:59.457700
Requesting lock as part of escalation: FALSE
Deadlock detection time: 11-21-2006 08:02:06.384952
Table of lock waited on :
Schema of lock waited on :
Tablespace of lock waited on :
Type of lock: Internal
Mode of lock: S
Mode application requested on lock: X
Node lock occured on: 0
Lock object name: 0
Application Handle: 193

Still stumped. Anyone got any Ideas