Error -19816: Cannot perform this operation on a

I get this error when I try to drop a table. Informix version 11.50.FC5 we have HDR setup. I have tried to stopping the replication "onmode -d standard", shutting down seconday server after stopping replication. -19816: Cannot perform this operation on a table defined for replication Config DRAUTO 0 DRINTERVAL 30 DRTIMEOUT 30DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 UPDATABLE_SECONDARY 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_MAX_DYNAMIC_LOGS 0 CDR_SUPPRESS_ATSRISWARN Any ideas? Thanks,

The error message/code has nothing to do with your HDR replication which permits dropping a table. Either the table in question is defined as a replicated table using Enterprise Replication or there is an active Change Data Capture (CDC) session open that is using the CDC API to capture changes made to that table. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Dec 29, 2010 at 12:41 PM, SANDEEP MENDON <smendon@gmail.com> wrote: > I get this error when I try to drop a table. Informix version 11.50.FC5 we > have HDR setup. I have tried to stopping the replication "onmode -d > standard", > shutting down seconday server after stopping replication. > > -19816: Cannot perform this operation on a table defined for replication> > Config > > DRAUTO 0 > DRINTERVAL 30 > DRTIMEOUT 30> DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound > DRIDXAUTO 0 > LOG_INDEX_BUILDS > SDS_ENABLE > SDS_TIMEOUT 20 > UPDATABLE_SECONDARY 0 > TEMPTAB_NOLOG 0 > DELAY_APPLY 0 > STOP_APPLY 0 > LOG_STAGING_DIR > > CDR_EVALTHREADS 1,2 > CDR_DSLOCKWAIT 5 > CDR_QUEUEMEM 4096 > CDR_NIFCOMPRESS 0 > CDR_SERIAL 0 > CDR_DBSPACE > CDR_QHDR_DBSPACE > CDR_MAX_DYNAMIC_LOGS 0 > CDR_SUPPRESS_ATSRISWARN> > Any ideas? > > Thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30433efe04c8840498904e59

Hi, When I run the finderr command it returns a little more info then you supplied. -19816 Cannot perform this operation on a table defined for replication. The specified operation cannot be performed on a table if Enterprise Replication is defined on the table. If you want to perform the specified operation, you must delete all replicates defined on this table. If the table is being captured using the Change Data Capture interface, then you must use CDC API functions to stop data capture and disable full row logging on the table. The above error indicates you are using Enterprise Replication, The text you sent talks about command "onmode -d standard" an HDR or High availability Data Replication command. Are you using both ? together ? You need to either stop and drop the repl for that table ( if you are using CRD or Enterprise replication ) or you need to stop the CDC interface for that table. HDR does not care about table drops, it just replicates them to the secondary, RSS, SDS servers.. George. From: "SANDEEP MENDON" <smendon@gmail.com> To: ids@iiug.org Date: 12/29/2010 11:43 AM Subject: Error -19816: Cannot perform this operation on a [22317] Sent by: ids-bounces@iiug.org I get this error when I try to drop a table. Informix version 11.50.FC5 we have HDR setup. I have tried to stopping the replication "onmode -d standard", shutting down seconday server after stopping replication. -19816: Cannot perform this operation on a table defined for replication Config DRAUTO 0 DRINTERVAL 30 DRTIMEOUT 30DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 UPDATABLE_SECONDARY 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_MAX_DYNAMIC_LOGS 0 CDR_SUPPRESS_ATSRISWARN Any ideas? Thanks, ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

We are not using Enterprise Replication, just HDR. We have CDC but there is no CDC sessions running on the server. Where else should I look? Thanks for the response.

George, We are not using Enterprise Replication, just HDR. We have CDC but there is no CDC sessions running on the server Thank you for pointing me to look at disable full row logging on the table. I ran this function and then I was able to drop the table. execute function informix.cdc_set_fullrowlogging('<database>:<schema>.<tablename>', 0); Thank you very much for helping me resolve this issue. Sandeep