pascal wrote:
"Jan Suchanek" <ja**********@gmx.de> wrote in message
news:41********@news.uni-ulm.de...
Jan Suchanek wrote:
Hi,
I am using the DB2 GUI to delete all entries of a table (delete from
table). The table has app. 900 enties and the removeal takes "forever".
The table gets lock (so no select is possible) and I can not cancel the
command.
a) What takes this long (at the moment I am waiting nearly an hour for
900 rows to be deleted)
b) can I cancel the command
c) where can I find out whats going on
I am using DB2 ESE V8.1 on a linux box
I just stopped the database so the command was terminated and issued the
command in th CLP - it returned in nearly no time... is the CC buggy?
I think in "real life" you cant use such software. I just cannot risk to
block my database or restart it just because i wanted a sql statement to
be executed...
The user interfaces are very bad. We have a lot of problems with them. i.e.
tables stay locked when viewing a sample contents in the control center
etc....
Just praying that the programmers at IBM which created this garbage are not
programming on the database kernal.
--
Pascal
I have used DB2 for about two years now, and have mostly ignored the CC.
It is tempting to try it in place of RTFM, but after a few such attempts
I found the latter to be excellent and reliable and the former to be too
frustrating to use. Your prayers are unnecessary, since the engine and
the interfaces are of extremely high quality.
N. Shamsundar
University of Houston