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??

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

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.

use

db2 "attach to <instance_name>"

then get the snapshot.

regards,

mujeeb

What is your original error message when trying to drop the table ?