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

Changing an index controlled partitioned table to table controlled.

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

Mar 13 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/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).
Mar 13 '06 #2

P: n/a
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
Mar 13 '06 #3

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

Mar 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.