Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

Changing an index controlled partitioned table to table controlled.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
steve - 13 Mar 2006 02:30 GMT
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 - 13 Mar 2006 03:13 GMT
> Hello,
>
[quoted text clipped - 19 lines]
> 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 - 13 Mar 2006 10:47 GMT
>> Hello,
>>
[quoted text clipped - 22 lines]
> 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. ;-)

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

steve - 13 Mar 2006 23:39 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.