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

All SQL's on a table hang, even a "drop table" statement.

P: n/a
Hi,

I have two tables (that I know of) in a database that seem to be
corrupted. All SQL statements on the tables hang, "select * from..",
"select count (*) from", "delete from..". I can't even drop the
tables as the "drop table..." statement, too, hangs. But the
tables do exist as they show up in "describe table <tabname> ".
A "create table" statement fails saying that the table already
exists.

I don't care about the data in the tables. How do I get rid of
the tables and re-create them? Any ideas?

DB2 8.1
AIX 5.2

Alanoly Andrews.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Alanoly J. Andrews" <al******@invera.com> wrote in message
news:e7**************************@posting.google.c om...
Hi,

I have two tables (that I know of) in a database that seem to be
corrupted. All SQL statements on the tables hang, "select * from..",
"select count (*) from", "delete from..". I can't even drop the
tables as the "drop table..." statement, too, hangs. But the
tables do exist as they show up in "describe table <tabname> ".
A "create table" statement fails saying that the table already
exists.

I don't care about the data in the tables. How do I get rid of
the tables and re-create them? Any ideas?

DB2 8.1
AIX 5.2

Alanoly Andrews.


Did you try to reboot the system.
Nov 12 '05 #2

P: n/a
tablespace state is?
select count(*) for read only with ur returns something?

Could be a lock (get snapshot for locks) or a utility using the table (list
history) ...

PM

"Alanoly J. Andrews" <al******@invera.com> a écrit dans le message de
news:e7**************************@posting.google.c om...
Hi,

I have two tables (that I know of) in a database that seem to be
corrupted. All SQL statements on the tables hang, "select * from..",
"select count (*) from", "delete from..". I can't even drop the
tables as the "drop table..." statement, too, hangs. But the
tables do exist as they show up in "describe table <tabname> ".
A "create table" statement fails saying that the table already
exists.

I don't care about the data in the tables. How do I get rid of
the tables and re-create them? Any ideas?

DB2 8.1
AIX 5.2

Alanoly Andrews.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.