467,199 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

Very slow delete using GUI

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

Thanks.

Greetings, Jan
Nov 12 '05 #1
  • viewed: 3338
Share:
5 Replies
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...
Greetings, Jan
Nov 12 '05 #2
"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

Nov 12 '05 #3
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
Nov 12 '05 #4
Hi Jan,
Can you provide the exact details as to how you are deleting the rows? For
example, are you deleting them by executing a "delete from..." from the
Command Center? Or are you using the Query Results tab in the Command
Center? etc...

Just to confirm, I'm assuming your running the GUI on the server as well?
Thanks,
Bevon

Jan Suchanek wrote:
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...

Greetings, Jan


Nov 12 '05 #5
Hi Jan,
Can you provide the exact details as to how you are deleting the rows? For
example, are you deleting them by executing a "delete from..." from the
Command Center? Or are you using the Query Results tab in the Command
Center? etc...

Just to confirm, I'm assuming your running the GUI on the server as well?
Thanks,
Bevon

Jan Suchanek wrote:
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...

Greetings, Jan


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Google Mike | last post: by
16 posts views Thread by mamo74@gmail.com | last post: by
reply views Thread by roiavidan@gmail.com | last post: by
6 posts views Thread by Rory Campbell-Lange | last post: by
2 posts views Thread by Brock Henry | last post: by
50 posts views Thread by diffuser78@gmail.com | last post: by
2 posts views Thread by hikums@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.