Results 1 to 5 of 5

Thread: DeadLock

  1. #1
    Join Date
    May 2005
    Posts
    18

    Unanswered: DeadLock

    I created a table in our DB2 database,
    Then I tried to drop the table I had just created.... and I can't drop it, I get a deadlock error!!!

    How can I get a deadlock error for trying to drop a table that I have just created??? No one is using this table! I just created it and tried to drop it.

    I don't understand deadlock errors in DB2 - why on earth would I get a deadlock error for doing this??

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Try doing a lock snapshot, that should tell you who or what is using the table.

    Are you doing this from the Control Center by any chance? I've seen some ... interesting ... lock behaviour from it at times.

    jono
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    May 2005
    Posts
    18
    I've tried it from the command prompt and control center.

    connect to db_name
    update monitor switches using LOCK on
    get snapshot for locks on db_name

    --- SQL1427N An instance attachment does not exist.

    What am I doing wrong? I'm new to snapshots perhaps I'm not taking it correctly.

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    use

    db2 "attach to <instance_name>"

    then get the snapshot.

    regards,

    mujeeb

  5. #5
    Join Date
    Oct 2005
    Posts
    109
    What is your original error message when trying to drop the table ?
    Juliane

Posting Permissions

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