"steve" <sm*****@hotmail.com> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...
Hello,
I am having a problem with an index controlled partitioned table. I
was altering a table using SQL. I was trying to add a partition to a
table to change it from index controlled to table controlled. This is
a new feature in version 8. Version 8 will automatically switch the
table from index controlled to table controlled if you alter the table
and add a new partition to the table. This does work because I tried
it before and it successfully changed the table. I was adding a
partition to the table so it would switch the table to table
controlled. The SQL abended with a 00C90101.
Now you can't display the table or even run an Unload against the Full
Image copies.
Has anyone else experienced this or ran accross this. Is there
anything I can do to back out the changes right now the table is pretty
much inaccessable.
If anyone else has experienced this or successfully backed out the
changes please let me know
Thanks,
Steve
When you post on a DB2 forum, it helps to mention what version of DB2 you
are using (DB2 for z/OS).