dropping syscdr
User asked about dropping the syscdr database when migrating Enterprise Replication from Informix 9.21 to 11.7, since "cdr delete server" wasn't working. Experts confirmed dropping syscdr is usually sufficient, with one suggesting "cdr delete server XXX --force" as alternative. User reported successfully dropping syscdr but then encountered error 62 (CDR GC updateCDRState failure) when defining the primary ER server; no resolution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello everyone: We are managing an old informix database 9.21 where was activate Enterprise Replication but nowdays is off. We are trying to activate ER with our newest informix 11.7 but I need to drop syscdr because cdr delete server doen't work, it says "ER not active" and so on. So My question, Can I drop syscdr database and define a newest one with cdr define server? Should I do anything more than drop cyscdr database? Thank you in advance.
Usually dropping syscdr is all you need to do. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco González Navarro < jfrancisco.navarro@gmail.com> wrote: > Hello everyone: > > We are managing an old informix database 9.21 where was activate > Enterprise Replication but nowdays is off. > > We are trying to activate ER with our newest informix 11.7 but I > need to drop syscdr because cdr delete server doen't work, it says "ER > not active" and so on. > > So My question, Can I drop syscdr database and define a newest > one with cdr define server? > > Should I do anything more than drop cyscdr database? > > Thank you in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6148a6e0ece904c5915ba3
cdr delete server XXX --force From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org, Date: 07/24/2012 05:08 AM Subject: Re: dropping syscdr [27780] Sent by: ids-bounces@iiug.org Usually dropping syscdr is all you need to do. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinion= s and do not reflect on my employer, Advanced DataTools, the IIUG, nor an= y 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco Gonz=E1lez Navarro < jfrancisco.navarro@gmail.com> wrote: > Hello everyone: > > We are managing an old informix database 9.21 where was activate > Enterprise Replication but nowdays is off. > > We are trying to activate ER with our newest informix 11.7 but I > need to drop syscdr because cdr delete server doen't work, it says "E= R > not active" and so on. > > So My question, Can I drop syscdr database and define a newest > one with cdr define server? > > Should I do anything more than drop cyscdr database? > > Thank you in advance. > > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6148a6e0ece904c5915ba3 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Hello Thank you everyone. I'll try to night. I hope it works. Regarda El 24/07/2012 15:36, "Madison Pruet" <mpruet@us.ibm.com> escribió: > cdr delete server XXX --force > > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org, > Date: 07/24/2012 05:08 AM > Subject: Re: dropping syscdr [27780] > Sent by: ids-bounces@iiug.org > > Usually dropping syscdr is all you need to do. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinion= > s > and do not reflect on my employer, Advanced DataTools, the IIUG, nor an= > y > 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco Gonz=E1lez Navarro < > jfrancisco.navarro@gmail.com> wrote: > > > Hello everyone: > > > > We are managing an old informix database 9.21 where was activate > > Enterprise Replication but nowdays is off. > > > > We are trying to activate ER with our newest informix 11.7 but I > > need to drop syscdr because cdr delete server doen't work, it says "E= > R > > not active" and so on. > > > > So My question, Can I drop syscdr database and define a newest > > one with cdr define server? > > > > Should I do anything more than drop cyscdr database? > > > > Thank you in advance. > > > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba6148a6e0ece904c5915ba3 > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023544716f042040c04c593afdd
Hello: Thank you Everyone, Yesterday I dropped syscdr database without problems but today when i try define and connect my primary server of Enterprise Replication it says error number 100. In online.log file of this server show this error but I don't what it's mean. "CDR GC: operation updateCDRState failed (error 62)" Thank you 2012/7/24, Juan Francisco González Navarro <jfrancisco.navarro@gmail.com>: > Hello > > Thank you everyone. I'll try to night. I hope it works. > > Regarda > El 24/07/2012 15:36, "Madison Pruet" <mpruet@us.ibm.com> escribió: > >> cdr delete server XXX --force >> >> From: "Art Kagel" <art.kagel@gmail.com> >> To: ids@iiug.org, >> Date: 07/24/2012 05:08 AM >> Subject: Re: dropping syscdr [27780] >> Sent by: ids-bounces@iiug.org >> >> Usually dropping syscdr is all you need to do. >> >> Art >> >> Art S. Kagel >> Advanced DataTools (www.advancedatatools.com) >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinion= >> s >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor an= >> y >> 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco Gonz=E1lez Navarro < >> jfrancisco.navarro@gmail.com> wrote: >> >> > Hello everyone: >> > >> > We are managing an old informix database 9.21 where was activate >> > Enterprise Replication but nowdays is off. >> > >> > We are trying to activate ER with our newest informix 11.7 but I >> > need to drop syscdr because cdr delete server doen't work, it says "E= >> R >> > not active" and so on. >> > >> > So My question, Can I drop syscdr database and define a newest >> > one with cdr define server? >> > >> > Should I do anything more than drop cyscdr database? >> > >> > Thank you in advance. >> > >> > >> > >> > >> ***********************************************************************= >> ******** >> >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> > >> >> --90e6ba6148a6e0ece904c5915ba3 >> >> ***********************************************************************= >> ******** >> >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> = >> >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --0023544716f042040c04c593afdd > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Did you bounce the instance before trying to define your server after dropping syscdr? If you haven't done so please try recycle it first and re-try. (I can recall something like running ./buildsmi in v7.x or recycle the instance) jp From: "Juan Francisco Gonz疝ez Navarro" <jfrancisco.navarro@gmail.com> To: ids@iiug.org Date: 07/25/2012 03:27 AM Subject: Re: dropping syscdr [27821] Sent by: ids-bounces@iiug.org Hello: Thank you Everyone, Yesterday I dropped syscdr database without problems but today when i try define and connect my primary server of Enterprise Replication it says error number 100. In online.log file of this server show this error but I don't what it's mean. "CDR GC: operation updateCDRState failed (error 62)" Thank you 2012/7/24, Juan Francisco González Navarro <jfrancisco.navarro@gmail.com>: > Hello > > Thank you everyone. I'll try to night. I hope it works. > > Regarda > El 24/07/2012 15:36, "Madison Pruet" <mpruet@us.ibm.com> escribió: > >> cdr delete server XXX --force >> >> From: "Art Kagel" <art.kagel@gmail.com> >> To: ids@iiug.org, >> Date: 07/24/2012 05:08 AM >> Subject: Re: dropping syscdr [27780] >> Sent by: ids-bounces@iiug.org >> >> Usually dropping syscdr is all you need to do. >> >> Art >> >> Art S. Kagel >> Advanced DataTools (www.advancedatatools.com) >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinion= >> s >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor an= >> y >> 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco Gonz=E1lez Navarro < >> jfrancisco.navarro@gmail.com> wrote: >> >> > Hello everyone: >> > >> > We are managing an old informix database 9.21 where was activate >> > Enterprise Replication but nowdays is off. >> > >> > We are trying to activate ER with our newest informix 11.7 but I >> > need to drop syscdr because cdr delete server doen't work, it says "E= >> R >> > not active" and so on. >> > >> > So My question, Can I drop syscdr database and define a newest >> > one with cdr define server? >> > >> > Should I do anything more than drop cyscdr database? >> > >> > Thank you in advance. >> > >> > >> > >> > >> ***********************************************************************= >> ******** >> >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> > >> >> --90e6ba6148a6e0ece904c5915ba3 >> >> ***********************************************************************= >> ******** >> >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> = >> >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --0023544716f042040c04c593afdd > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Non sequitur! Does not compute! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) 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, Jul 25, 2012 at 10:26 AM, jpierrot@chubb.com <jpierrot@chubb.com>wrote: > > Did you bounce the instance before trying to define your server after > dropping syscdr? If you haven't done so please try recycle it first and > re-try. (I can recall something like running ./buildsmi in v7.x or recycle > the instance) > > jp > > > > From: "Juan Francisco Gonz疝ez Navarro" <jfrancisco.navarro@gmail.com> > > To: ids@iiug.org > > Date: 07/25/2012 03:27 AM > > Subject: Re: dropping syscdr [27821] > > Sent by: ids-bounces@iiug.org > > > > > > > Hello: > > Thank you Everyone, Yesterday I dropped syscdr database without > problems but today when i try define and connect my primary server of > Enterprise Replication it says error number 100. > > In online.log file of this server show this error but I don't what > it's mean. > > "CDR GC: operation updateCDRState failed (error 62)" > > Thank you > > 2012/7/24, Juan Francisco González Navarro <jfrancisco.navarro@gmail.com>: > > Hello > > > > Thank you everyone. I'll try to night. I hope it works. > > > > Regarda > > El 24/07/2012 15:36, "Madison Pruet" <mpruet@us.ibm.com> escribió: > > > >> cdr delete server XXX --force > >> > >> From: "Art Kagel" <art.kagel@gmail.com> > >> To: ids@iiug.org, > >> Date: 07/24/2012 05:08 AM > >> Subject: Re: dropping syscdr [27780] > >> Sent by: ids-bounces@iiug.org > >> > >> Usually dropping syscdr is all you need to do. > >> > >> Art > >> > >> Art S. Kagel > >> Advanced DataTools (www.advancedatatools.com) > >> Blog: http://informix-myview.blogspot.com/ > >> > >> Disclaimer: Please keep in mind that my own opinions are my own opinion= > > >> s > >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor an= > > >> y > >> 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 Tue, Jul 24, 2012 at 6:37 AM, Juan Francisco Gonz=E1lez Navarro < > >> jfrancisco.navarro@gmail.com> wrote: > >> > >> > Hello everyone: > >> > > >> > We are managing an old informix database 9.21 where was activate > >> > Enterprise Replication but nowdays is off. > >> > > >> > We are trying to activate ER with our newest informix 11.7 but I > >> > need to drop syscdr because cdr delete server doen't work, it says "E= > > >> R > >> > not active" and so on. > >> > > >> > So My question, Can I drop syscdr database and define a newest > >> > one with cdr define server? > >> > > >> > Should I do anything more than drop cyscdr database? > >> > > >> > Thank you in advance. > >> > > >> > > >> > > >> > > >> ***********************************************************************= > > >> ******** > >> > >> > Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > >> > > >> > >> --90e6ba6148a6e0ece904c5915ba3 > >> > >> ***********************************************************************= > > >> ******** > >> > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> = > >> > >> > >> > >> > > > ******************************************************************************* > > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > --0023544716f042040c04c593afdd > > > > > > > ******************************************** > > K