Can't reorg a replicated table

I am using Enterprise Replication (cdr) and I need to reorg a replicated table. (out of extents) I created a new table and loaded it using HDL. Now I need to drop the replicated table and rename the new table. But informix will not drop the table - non exclusive access - I tried alter table and was denied because it's a replicated table. Anybody done this before? Oh yeah, here's my server info: IBM Informix Dynamic Server Version 10.00.FC8

Just stop replication for that table (replicate): cdr stop replicate my_replicate_name server1 server2 ... After you have renamed the table you can resume replication with: cdr start replicate my_replicate_name server1 server2 ... You can leave off the list of servers if you will be stopping/restarting replication for that replicate on all participating servers at the same time. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 23, 2009 at 1:11 PM, BEVIS KENNEDY <bkennedy@utah.gov> wrote: > I am using Enterprise Replication (cdr) and I need to reorg a replicated > table. (out of extents) I created a new table and loaded it using HDL. > Now I need to drop the replicated table and rename the new table. But > informix > will not drop the table - non exclusive access - > I tried alter table and was denied because it's a replicated table. > Anybody done this before? > > Oh yeah, here's my server info: > IBM Informix Dynamic Server Version 10.00.FC8 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502d6c41de0fb046f62c959

You could created clustered index or alter fragment statement to reorg the replicated table. alter index to cluster, and alter fragment statements on replicated tablesare supported in IDS 10.00. Rename column,table and database support was added from IDS 11.10 onwards. For details on supported alter operations on replicated table pls. look at developer article http://www.ibm.com/developerworks/data/library/techarticle/dm-0506inturi/ Thanks & Regards, Nagaraju From: "BEVIS KENNEDY" <bkennedy@utah.gov> To: ids@iiug.org Date: 07/23/2009 12:12 PM Subject: Can't reorg a replicated table [16487] I am using Enterprise Replication (cdr) and I need to reorg a replicated table. (out of extents) I created a new table and loaded it using HDL. Now I need to drop the replicated table and rename the new table. But informix will not drop the table - non exclusive access - I tried alter table and was denied because it's a replicated table. Anybody done this before? Oh yeah, here's my server info: IBM Informix Dynamic Server Version 10.00.FC8 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.