delete query taking time

[j***@gmail.com]

Hi,

Morning i ran one delete statement. That is still going on. I don't no wheather it is still running on the background or not. I want to know wheather it will take this much of time to delete rows also. There are 3400 rows in the table.

I am connecting db through db2client from offshore.
Thanks in advance!
jai

[d***@njit.edu]

Are you sure its not in a deadlock situation? Try checking the number of locks on the table. Use the get snapshot command.

[Knut Stolze]

Post by j***@gmail.com
Hi,
Morning i ran one delete statement. That is still going on. I don't no
wheather it is still running on the background or not. I want to know
wheather it will take this much of time to delete rows also. There are
3400 rows in the table.

A table with just 3400 rows is very small. Deleting from that table should
be very quick. I guess that you have a lock-wait situation (or deadlock
with an extremely huge deadlock detection interval). Have you set the lock
timeout in the DB CFG to a reasonable value? (The default is -1, which
means to wait forever.)