By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Very slow delete using GUI

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
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.