Changing an index controlled partitioned table to table controlled.

[steve]

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

[Mark A]

"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).

[Knut Stolze]

Mark A wrote:

"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).

That explains why I had no idea what the OP was talking about. ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[steve]

Had to aply a fix to the DB2 system to fix the problem. Aparently if
your table, tablepaces, or index's are version 5 or older you can have
problems with the Alter table Add partition command.

Problem resolved