Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: Deadlock Detected. Waiting On SYSPLAN

    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

  2. #2
    Join Date
    Jun 2003
    Posts
    50
    Still stumped. Anyone got any Ideas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •