cryptic error in after the Column involved in PK was dropped

What could be the possible fix for it?
please reply ASAP, it's urgent

Rahul Babbar wrote:>
Call support, get a PMR opened with a priority fitting your urgency.
>
Cheers
Serge
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On Nov 21, 7:30 pm, Serge Rielau <srie...@ca.ibm.comwrote:>
Isn't there something that can be done right now?
the basic problem is this
>
I have accidently dropped a column that was part of the primary
key....It was dropped successfully, but the the index related to it
became invalid, and only because of that whole database is considered
'damaged'. The table can neither be dropped, nor queried, which really
is unexpected.....
>
I am looking to fix this problem right now..

>
Can anybody help?

Hi,
I am facing an issue here.
>
I had to drop a number of columns (around 20) from a table, which I
tried to do all at the same time using the following command.
>
Alter table table_name drop column <column1drop column <column2>
drop column <column3>.............................drop column <column20>
>
The above command was successful.
>
The table had a composite primary key consisting of two columns, one
of which was dropped in the above statement.
>
The subsequent Reorg on that table, gave the warning saying "SQL1279W
Some indexes may not have been recreated."
>
Any subsequent operation on that table(select, insert etc) disconnects
the user from the database giving a tcp/ip error, while any alter on
that table gives the error DB21034E "The Database is damaged" and
disconnects the user.
>
Further, trying to drop that table gives the error, "SQL0204N "1" is
an undefined name."
And recreating gives the error "Name is already used by an existing
object".
>
Further, dropping the Primary key index also disconnects the user from
the database.
>
>
>
What could be the possible fix for it?
>
please reply ASAP, it's urgent
>
Rahul