cmsm in a cluster + switchover? DRAUTO=1+3 ???
Alexandre asked whether, with Connection Manager (CMSM) handling failover in an 11.50 cluster (primary + SDS + HDR), automatic switchover back to the original primary is possible, since docs warn against also setting DRAUTO=1/2. Art Kagel explained you should use only one arbitrator: let CM manage failover (it's more robust and lets you prioritise the SDS node), but failing back to the original layout is normally a manual step. Alexandre tested stopping cmsm, running 'onmode -d make primary' on the old primary, restarting the downed SDS instance, then restarting cmsm, which worked. For automatic failback he was told to file a feature request with IBM (a new request tool was due to be announced at IIUG).
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello. He have a cluster, version 11.50 (plans to upgrade soon) with one primary, one SDS, and one HDR. I have a simple question, but didn´t find the answer yet, so maybe someone could help me. If I enable DRAUTO=1, I can easily see the changes rolling from hdr secondary to primary, and vice versa, as expected if a failure occurs. But now, I am trying to do a lab (in informix VA cluster demonstration), but... there is no way to do an automatic switchover (like DRAUTO=1+3) with cmsm enabled? Documentation says it is even not recommended: "You should configure only one failover arbitrator; either the built-in Informix failover arbitrator or the Connection Manager. You should not set DRAUTO to 1 or 2 if you have configured failover using the Connection Manager." Does it means that if I use cmsm features, I cannot retrieve the same physical design as I had, before the node failure? Thanks!
No. It means that you have to use the CMSM failover configuration and let Connection Manager manage the failover. This has the advantage that you can have CM set the SDS secondary as the first choice to make into primary and leave the HDR secondary as is unless the SDS also fails then upgrade the HDR secondary to primary. Having the CM manage failover is more robust than DR_AUTO. I makes additional checks before failing over, and in 11.70 more so and in 12.10 you can specify alternative communications paths to insure that you never end up with two primaries. 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI <alexandre@briug.org>wrote: > Hello. > He have a cluster, version 11.50 (plans to upgrade soon) with one primary, > one > SDS, and one HDR. > > I have a simple question, but didn´t find the answer yet, so maybe someone > could help me. > > If I enable DRAUTO=1, I can easily see the changes rolling from hdr > secondary > to primary, and vice versa, as expected if a failure occurs. > > But now, I am trying to do a lab (in informix VA cluster demonstration), > but... there is no way to do an automatic switchover (like DRAUTO=1+3) with > cmsm enabled? > > Documentation says it is even not recommended: > "You should configure only one failover arbitrator; either the built-in > Informix failover arbitrator or the Connection Manager. You should not set > DRAUTO to 1 or 2 if you have configured failover using the Connection > Manager." > > Does it means that if I use cmsm features, I cannot retrieve the same > physical > design as I had, before the node failure? > > Thanks! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0115fe5c1b43f404da7f7f09
Thanks very much, Art.
We always like to prior our primary instance, in a physical "site A" location,
that´s what I tried to say.
What if I just move the "old primary node", now an SDS secondary (after the
failover is finished), to a primary node?
onmode -d make primary [node]Couldn´t it work? Cmsm wouldn´t do the automatic changes? I will try that
later... just an idea.
Thanks, anyway.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30072]
> Date: Tue, 16 Apr 2013 15:37:30 -0400
>
> No. It means that you have to use the CMSM failover configuration and let
> Connection Manager manage the failover. This has the advantage that you
> can have CM set the SDS secondary as the first choice to make into primary
> and leave the HDR secondary as is unless the SDS also fails then upgrade
> the HDR secondary to primary.
>
> Having the CM manage failover is more robust than DR_AUTO. I makes
> additional checks before failing over, and in 11.70 more so and in 12.10
> you can specify alternative communications paths to insure that you never
> end up with two primaries.
>
> 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI <alexandre@briug.org>wrote:
>
> > Hello.
> > He have a cluster, version 11.50 (plans to upgrade soon) with one primary,
> > one
> > SDS, and one HDR.
> >
> > I have a simple question, but didn´t find the answer yet, so maybe someone
> > could help me.
> >
> > If I enable DRAUTO=1, I can easily see the changes rolling from hdr
> > secondary
> > to primary, and vice versa, as expected if a failure occurs.
> >
> > But now, I am trying to do a lab (in informix VA cluster demonstration),
> > but... there is no way to do an automatic switchover (like DRAUTO=1+3) with
> > cmsm enabled?
> >
> > Documentation says it is even not recommended:
> > "You should configure only one failover arbitrator; either the built-in
> > Informix failover arbitrator or the Connection Manager. You should not set
> > DRAUTO to 1 or 2 if you have configured failover using the Connection
> > Manager."
> >
> > Does it means that if I use cmsm features, I cannot retrieve the same
> > physical
> > design as I had, before the node failure?
> >
> > Thanks!
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e0115fe5c1b43f404da7f7f09
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Ok good news, it worked (as not as I would enjoy, but):
1) I´ve stopped the cmsm
2) I´ve run "onmode -d make primary c1primary" into the c1primary instance,
that was an SDS secondary after failover
3) It became an HDR primary, but.... my previous HDR primary went off.
Curiously, only the c1sds1 instance went down. As soon as I´ve
started it again, it became online as an SDS node, as I expected to see
in automatic way.
4) Restarted the cmsm, just fine
Is this something unusual? Did I hit a shoot in the dark?
Thanks a lot for your attention.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: alexandre@briug.org
> Subject: RE: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30085]
> Date: Wed, 17 Apr 2013 06:41:05 -0400
>
> Thanks very much, Art.
> We always like to prior our primary instance, in a physical "site A"
location,
> that´s what I tried to say.
> What if I just move the "old primary node", now an SDS secondary (after the
> failover is finished), to a primary node?
> onmode -d make primary [node]> Couldn´t it work? Cmsm wouldn´t do the automatic changes? I will try that
> later... just an idea.
>
> Thanks, anyway.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30072]
> > Date: Tue, 16 Apr 2013 15:37:30 -0400
> >
> > No. It means that you have to use the CMSM failover configuration and let
> > Connection Manager manage the failover. This has the advantage that you
> > can have CM set the SDS secondary as the first choice to make into primary
> > and leave the HDR secondary as is unless the SDS also fails then upgrade
> > the HDR secondary to primary.
> >
> > Having the CM manage failover is more robust than DR_AUTO. I makes
> > additional checks before failing over, and in 11.70 more so and in 12.10
> > you can specify alternative communications paths to insure that you never
> > end up with two primaries.
> >
> > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> <alexandre@briug.org>wrote:
> >
> > > Hello.
> > > He have a cluster, version 11.50 (plans to upgrade soon) with one
primary,
> > > one
> > > SDS, and one HDR.
> > >
> > > I have a simple question, but didn´t find the answer yet, so maybe
someone
> > > could help me.
> > >
> > > If I enable DRAUTO=1, I can easily see the changes rolling from hdr
> > > secondary
> > > to primary, and vice versa, as expected if a failure occurs.
> > >
> > > But now, I am trying to do a lab (in informix VA cluster demonstration),
> > > but... there is no way to do an automatic switchover (like DRAUTO=1+3)
> with
> > > cmsm enabled?
> > >
> > > Documentation says it is even not recommended:
> > > "You should configure only one failover arbitrator; either the built-in
> > > Informix failover arbitrator or the Connection Manager. You should not
set
> > > DRAUTO to 1 or 2 if you have configured failover using the Connection
> > > Manager."
> > >
> > > Does it means that if I use cmsm features, I cannot retrieve the same
> > > physical
> > > design as I had, before the node failure?
> > >
> > > Thanks!
> > >
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e0115fe5c1b43f404da7f7f09
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
CM will hadle the initial failover, failing back to "normal" is usually a
manual process.
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, Apr 17, 2013 at 6:41 AM, Alexandre Marini <alexandre@briug.org>wrote:
> Thanks very much, Art.
> We always like to prior our primary instance, in a physical "site A"
> location,
> that´s what I tried to say.
> What if I just move the "old primary node", now an SDS secondary (after the
> failover is finished), to a primary node?
> onmode -d make primary [node]> Couldn´t it work? Cmsm wouldn´t do the automatic changes? I will try that
> later... just an idea.
>
> Thanks, anyway.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30072]
> > Date: Tue, 16 Apr 2013 15:37:30 -0400
> >
> > No. It means that you have to use the CMSM failover configuration and let
> > Connection Manager manage the failover. This has the advantage that you
> > can have CM set the SDS secondary as the first choice to make into
> primary
> > and leave the HDR secondary as is unless the SDS also fails then upgrade
> > the HDR secondary to primary.
> >
> > Having the CM manage failover is more robust than DR_AUTO. I makes
> > additional checks before failing over, and in 11.70 more so and in 12.10
> > you can specify alternative communications paths to insure that you never
> > end up with two primaries.
> >
> > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> <alexandre@briug.org>wrote:
> >
> > > Hello.
> > > He have a cluster, version 11.50 (plans to upgrade soon) with one
> primary,
> > > one
> > > SDS, and one HDR.
> > >
> > > I have a simple question, but didn´t find the answer yet, so maybe
> someone
> > > could help me.
> > >
> > > If I enable DRAUTO=1, I can easily see the changes rolling from hdr
> > > secondary
> > > to primary, and vice versa, as expected if a failure occurs.
> > >
> > > But now, I am trying to do a lab (in informix VA cluster
> demonstration),
> > > but... there is no way to do an automatic switchover (like DRAUTO=1+3)
> with
> > > cmsm enabled?
> > >
> > > Documentation says it is even not recommended:
> > > "You should configure only one failover arbitrator; either the built-in
> > > Informix failover arbitrator or the Connection Manager. You should not
> set
> > > DRAUTO to 1 or 2 if you have configured failover using the Connection
> > > Manager."
> > >
> > > Does it means that if I use cmsm features, I cannot retrieve the same
> > > physical
> > > design as I had, before the node failure?
> > >
> > > Thanks!
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e0115fe5c1b43f404da7f7f09
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c382ccc2134104da8f0d96
Ok Art, I understand.
But for keeping the "no downtime feature + automatic redirection" of cmsm, I
would like to suggest this automatic switchover, the same way as it works with
DRAUTO=1, for example, for maybe a future release request.
Is there some contact to should I report this?
Thanks a lot!
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30088]
> Date: Wed, 17 Apr 2013 10:11:26 -0400
>
> CM will hadle the initial failover, failing back to "normal" is usually a
> manual process.
>
> 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, Apr 17, 2013 at 6:41 AM, Alexandre Marini <alexandre@briug.org>wrote:
>
> > Thanks very much, Art.
> > We always like to prior our primary instance, in a physical "site A"
> > location,
> > that´s what I tried to say.
> > What if I just move the "old primary node", now an SDS secondary (after the
> > failover is finished), to a primary node?
> > onmode -d make primary [node]> > Couldn´t it work? Cmsm wouldn´t do the automatic changes? I will try that
> > later... just an idea.
> >
> > Thanks, anyway.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Informix Senior DBA - Orizon Brasil
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30072]
> > > Date: Tue, 16 Apr 2013 15:37:30 -0400
> > >
> > > No. It means that you have to use the CMSM failover configuration and let
> > > Connection Manager manage the failover. This has the advantage that you
> > > can have CM set the SDS secondary as the first choice to make into
> > primary
> > > and leave the HDR secondary as is unless the SDS also fails then upgrade
> > > the HDR secondary to primary.
> > >
> > > Having the CM manage failover is more robust than DR_AUTO. I makes
> > > additional checks before failing over, and in 11.70 more so and in 12.10
> > > you can specify alternative communications paths to insure that you never
> > > end up with two primaries.
> > >
> > > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> > <alexandre@briug.org>wrote:
> > >
> > > > Hello.
> > > > He have a cluster, version 11.50 (plans to upgrade soon) with one
> > primary,
> > > > one
> > > > SDS, and one HDR.
> > > >
> > > > I have a simple question, but didn´t find the answer yet, so maybe
> > someone
> > > > could help me.
> > > >
> > > > If I enable DRAUTO=1, I can easily see the changes rolling from hdr
> > > > secondary
> > > > to primary, and vice versa, as expected if a failure occurs.
> > > >
> > > > But now, I am trying to do a lab (in informix VA cluster
> > demonstration),
> > > > but... there is no way to do an automatic switchover (like DRAUTO=1+3)
> > with
> > > > cmsm enabled?
> > > >
> > > > Documentation says it is even not recommended:
> > > > "You should configure only one failover arbitrator; either the built-in
> > > > Informix failover arbitrator or the Connection Manager. You should not
> > set
> > > > DRAUTO to 1 or 2 if you have configured failover using the Connection
> > > > Manager."
> > > >
> > > > Does it means that if I use cmsm features, I cannot retrieve the same
> > > > physical
> > > > design as I had, before the node failure?
> > > >
> > > > Thanks!
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --089e0115fe5c1b43f404da7f7f09
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c382ccc2134104da8f0d96
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
You would have to enter a "feature request" with IBM support.
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, Apr 17, 2013 at 10:50 AM, Alexandre Marini <alexandre@briug.org>wrote:
> Ok Art, I understand.
> But for keeping the "no downtime feature + automatic redirection" of cmsm,
> I
> would like to suggest this automatic switchover, the same way as it works
> with
> DRAUTO=1, for example, for maybe a future release request.
> Is there some contact to should I report this?
>
> Thanks a lot!
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30088]
> > Date: Wed, 17 Apr 2013 10:11:26 -0400
> >
> > CM will hadle the initial failover, failing back to "normal" is usually a
> > manual process.
> >
> > 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, Apr 17, 2013 at 6:41 AM, Alexandre Marini
> <alexandre@briug.org>wrote:
> >
> > > Thanks very much, Art.
> > > We always like to prior our primary instance, in a physical "site A"
> > > location,
> > > that´s what I tried to say.
> > > What if I just move the "old primary node", now an SDS secondary (after
> the
> > > failover is finished), to a primary node?
> > > onmode -d make primary [node]> > > Couldn´t it work? Cmsm wouldn´t do the automatic changes? I will try
> that
> > > later... just an idea.
> > >
> > > Thanks, anyway.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Infosphere DataStage Technical Professional
> > > Informix Senior DBA - Orizon Brasil
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: art.kagel@gmail.com
> > > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30072]
> > > > Date: Tue, 16 Apr 2013 15:37:30 -0400
> > > >
> > > > No. It means that you have to use the CMSM failover configuration and
> let
> > > > Connection Manager manage the failover. This has the advantage that
> you
> > > > can have CM set the SDS secondary as the first choice to make into
> > > primary
> > > > and leave the HDR secondary as is unless the SDS also fails then
> upgrade
> > > > the HDR secondary to primary.
> > > >
> > > > Having the CM manage failover is more robust than DR_AUTO. I makes
> > > > additional checks before failing over, and in 11.70 more so and in
> 12.10
> > > > you can specify alternative communications paths to insure that you
> never
> > > > end up with two primaries.
> > > >
> > > > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> > > <alexandre@briug.org>wrote:
> > > >
> > > > > Hello.
> > > > > He have a cluster, version 11.50 (plans to upgrade soon) with one
> > > primary,
> > > > > one
> > > > > SDS, and one HDR.
> > > > >
> > > > > I have a simple question, but didn´t find the answer yet, so maybe
> > > someone
> > > > > could help me.
> > > > >
> > > > > If I enable DRAUTO=1, I can easily see the changes rolling from hdr
> > > > > secondary
> > > > > to primary, and vice versa, as expected if a failure occurs.
> > > > >
> > > > > But now, I am trying to do a lab (in informix VA cluster
> > > demonstration),
> > > > > but... there is no way to do an automatic switchover (like
> DRAUTO=1+3)
> > > with
> > > > > cmsm enabled?
> > > > >
> > > > > Documentation says it is even not recommended:
> > > > > "You should configure only one failover arbitrator; either the
> built-in
> > > > > Informix failover arbitrator or the Connection Manager. You should
> not
> > > set
> > > > > DRAUTO to 1 or 2 if you have configured failover using the
> Connection
> > > > > Manager."
> > > > >
> > > > > Does it means that if I use cmsm features, I cannot retrieve the
> same
> > > > > physical
> > > > > design as I had, before the node failure?
> > > > >
> > > > > Thanks!
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --089e0115fe5c1b43f404da7f7f09
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c382ccc2134104da8f0d96
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
******************************
There's a new tool for feature requests which will be announced during
IIUG. I'd suggest waiting for the announcement and use it for this.
M.P.
From: "Art Kagel" <art.kagel@gmail.com>
To: ids@iiug.org,
Date: 04/17/2013 11:24 AM
Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [30090]
Sent by: ids-bounces@iiug.org
You would have to enter a "feature request" with IBM support.
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 Wed, Apr 17, 2013 at 10:50 AM, Alexandre Marini
<alexandre@briug.org>wrote:
> Ok Art, I understand.
> But for keeping the "no downtime feature + automatic redirection" of
cmsm,
> I
> would like to suggest this automatic switchover, the same way as it w=
orks
> with
> DRAUTO=3D1, for example, for maybe a future release request.
> Is there some contact to should I report this?
>
> Thanks a lot!
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [3008=
8]
> > Date: Wed, 17 Apr 2013 10:11:26 -0400
> >
> > CM will hadle the initial failover, failing back to "normal" is usu=
ally
a
> > manual process.
> >
> > 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, no=
r
any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect thos=
e of
> > other individuals affiliated with any entity with which I am affili=
ated
> nor
> > those of the entities themselves.
> >
> > On Wed, Apr 17, 2013 at 6:41 AM, Alexandre Marini
> <alexandre@briug.org>wrote:
> >
> > > Thanks very much, Art.
> > > We always like to prior our primary instance, in a physical "site=
A"
> > > location,
> > > that=B4s what I tried to say.
> > > What if I just move the "old primary node", now an SDS secondary
(after
> the
> > > failover is finished), to a primary node?
> > > onmode -d make primary [node]> > > Couldn=B4t it work? Cmsm wouldn=B4t do the automatic changes? I w=
ill try
> that
> > > later... just an idea.
> > >
> > > Thanks, anyway.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Infosphere DataStage Technical Professional
> > > Informix Senior DBA - Orizon Brasil
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: art.kagel@gmail.com
> > > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [=
30072]
> > > > Date: Tue, 16 Apr 2013 15:37:30 -0400
> > > >
> > > > No. It means that you have to use the CMSM failover configurati=
on
and
> let
> > > > Connection Manager manage the failover. This has the advantage =
that
> you
> > > > can have CM set the SDS secondary as the first choice to make i=
nto
> > > primary
> > > > and leave the HDR secondary as is unless the SDS also fails the=
n
> upgrade
> > > > the HDR secondary to primary.
> > > >
> > > > Having the CM manage failover is more robust than DR_AUTO. I ma=
kes
> > > > additional checks before failing over, and in 11.70 more so and=
in
> 12.10
> > > > you can specify alternative communications paths to insure that=
you
> never
> > > > end up with two primaries.
> > > >
> > > > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> > > <alexandre@briug.org>wrote:
> > > >
> > > > > Hello.
> > > > > He have a cluster, version 11.50 (plans to upgrade soon) with=
one
> > > primary,
> > > > > one
> > > > > SDS, and one HDR.
> > > > >
> > > > > I have a simple question, but didn=B4t find the answer yet, s=
o
maybe
> > > someone
> > > > > could help me.
> > > > >
> > > > > If I enable DRAUTO=3D1, I can easily see the changes rolling =
from
hdr
> > > > > secondary
> > > > > to primary, and vice versa, as expected if a failure occurs.
> > > > >
> > > > > But now, I am trying to do a lab (in informix VA cluster
> > > demonstration),
> > > > > but... there is no way to do an automatic switchover (like
> DRAUTO=3D1+3)
> > > with
> > > > > cmsm enabled?
> > > > >
> > > > > Documentation says it is even not recommended:
> > > > > "You should configure only one failover arbitrator; either th=
e
> built-in
> > > > > Informix failover arbitrator or the Connection Manager. You
should
> not
> > > set
> > > > > DRAUTO to 1 or 2 if you have configured failover using the
> Connection
> > > > > Manager."
> > > > >
> > > > > Does it means that if I use cmsm features, I cannot retrieve =
the
> same
> > > > > physical
> > > > > design as I had, before the node failure?
> > > > >
> > > > > Thanks!
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
***********************************************************************=
********
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > > >
> > > > >
> > > >
> > > > --089e0115fe5c1b43f404da7f7f09
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
**************************************************
Is it just me, or that site (Keshav Murthy already twit it) and other
DeveloperWorks sites show up terribly unformatted? Looks like a CSS issue...
Regards
On Wed, Apr 17, 2013 at 5:32 PM, Madison Pruet <mpruet@us.ibm.com> wrote:
> There's a new tool for feature requests which will be announced during
> IIUG. I'd suggest waiting for the announcement and use it for this.
>
> M.P.
>
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org,
> Date: 04/17/2013 11:24 AM
> Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [30090]
> Sent by: ids-bounces@iiug.org
>
> You would have to enter a "feature request" with IBM support.
>
> 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 Wed, Apr 17, 2013 at 10:50 AM, Alexandre Marini
> <alexandre@briug.org>wrote:
>
> > Ok Art, I understand.
> > But for keeping the "no downtime feature + automatic redirection" of
> cmsm,
> > I
> > would like to suggest this automatic switchover, the same way as it w=
> orks
>
> > with
> > DRAUTO=3D1, for example, for maybe a future release request.
> > Is there some contact to should I report this?
> >
> > Thanks a lot!
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Informix Senior DBA - Orizon Brasil
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [3008=
> 8]
> > > Date: Wed, 17 Apr 2013 10:11:26 -0400
> > >
> > > CM will hadle the initial failover, failing back to "normal" is usu=
> ally
> a
> > > manual process.
> > >
> > > 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, no=
> r
> any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect thos=
> e of
>
> > > other individuals affiliated with any entity with which I am affili=
> ated
>
> > nor
> > > those of the entities themselves.
> > >
> > > On Wed, Apr 17, 2013 at 6:41 AM, Alexandre Marini
> > <alexandre@briug.org>wrote:
> > >
> > > > Thanks very much, Art.
> > > > We always like to prior our primary instance, in a physical "site=
> A"
> > > > location,
> > > > that=B4s what I tried to say.
> > > > What if I just move the "old primary node", now an SDS secondary
> (after
> > the
> > > > failover is finished), to a primary node?
> > > > onmode -d make primary [node]> > > > Couldn=B4t it work? Cmsm wouldn=B4t do the automatic changes? I w=
> ill try
> > that
> > > > later... just an idea.
> > > >
> > > > Thanks, anyway.
> > > >
> > > > Alexandre Marini
> > > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > > >
> > > > IBM Information Management Informix Technical Professional
> > > >
> > > > IBM Infosphere DataStage Technical Professional
> > > > Informix Senior DBA - Orizon Brasil
> > > > BRIUG website administrator
> > > > Informix independent consultant
> > > >
> > > > > To: ids@iiug.org
> > > > > From: art.kagel@gmail.com
> > > > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [=
> 30072]
>
> > > > > Date: Tue, 16 Apr 2013 15:37:30 -0400
> > > > >
> > > > > No. It means that you have to use the CMSM failover configurati=
> on
> and
> > let
> > > > > Connection Manager manage the failover. This has the advantage =
> that
>
> > you
> > > > > can have CM set the SDS secondary as the first choice to make i=
> nto
> > > > primary
> > > > > and leave the HDR secondary as is unless the SDS also fails the=
> n
> > upgrade
> > > > > the HDR secondary to primary.
> > > > >
> > > > > Having the CM manage failover is more robust than DR_AUTO. I ma=
> kes
> > > > > additional checks before failing over, and in 11.70 more so and=
> in
> > 12.10
> > > > > you can specify alternative communications paths to insure that=
> you
>
> > never
> > > > > end up with two primaries.
> > > > >
> > > > > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> > > > <alexandre@briug.org>wrote:
> > > > >
> > > > > > Hello.
> > > > > > He have a cluster, version 11.50 (plans to upgrade soon) with=
> one
>
> > > > primary,
> > > > > > one
> > > > > > SDS, and one HDR.
> > > > > >
> > > > > > I have a simple question, but didn=B4t find the answer yet, s=
> o
> maybe
> > > > someone
> > > > > > could help me.
> > > > > >
> > > > > > If I enable DRAUTO=3D1, I can easily see the changes rolling =
> from
> hdr
> > > > > > secondary
> > > > > > to primary, and vice versa, as expected if a failure occurs.
> > > > > >
> > > > > > But now, I am trying to do a lab (in informix VA cluster
> > > > demonstration),
> > > > > > but... there is no way to do an automatic switchover (like
> > DRAUTO=3D1+3)
> > > > with
> > > > > > cmsm enabled?
> > > > > >
> > > > > > Documentation says it is even not recommended:
> > > > > > "You should configure only one failover arbitrator; either th=
> e
> > built-in
> > > > > > Informix failover arbitrator or the Connection Manager. You
> should
> > not
> > > > set
> > > > > > DRAUTO to 1 or 2 if you have configured failover using the
> > Connection
> > > > > > Manager."
> > > > > >
> > > > > > Does it means that if I use cmsm features, I cannot retrieve =
Great news! I will ask some friend to take note of this (unfortunately I
cannot join the conf this year).
Thanks a lot, MP, and Art.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: mpruet@us.ibm.com
> Subject: Re: cmsm in a cluster + switchover? DRAUTO=1+3 ??? [30091]
> Date: Wed, 17 Apr 2013 12:32:37 -0400
>
> There's a new tool for feature requests which will be announced during
> IIUG. I'd suggest waiting for the announcement and use it for this.
>
> M.P.
>
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org,
> Date: 04/17/2013 11:24 AM
> Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [30090]
> Sent by: ids-bounces@iiug.org
>
> You would have to enter a "feature request" with IBM support.
>
> 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 Wed, Apr 17, 2013 at 10:50 AM, Alexandre Marini
> <alexandre@briug.org>wrote:
>
> > Ok Art, I understand.
> > But for keeping the "no downtime feature + automatic redirection" of
> cmsm,
> > I
> > would like to suggest this automatic switchover, the same way as it w=
> orks
>
> > with
> > DRAUTO=3D1, for example, for maybe a future release request.
> > Is there some contact to should I report this?
> >
> > Thanks a lot!
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Informix Senior DBA - Orizon Brasil
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [3008=
> 8]
> > > Date: Wed, 17 Apr 2013 10:11:26 -0400
> > >
> > > CM will hadle the initial failover, failing back to "normal" is usu=
> ally
> a
> > > manual process.
> > >
> > > 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, no=
> r
> any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect thos=
> e of
>
> > > other individuals affiliated with any entity with which I am affili=
> ated
>
> > nor
> > > those of the entities themselves.
> > >
> > > On Wed, Apr 17, 2013 at 6:41 AM, Alexandre Marini
> > <alexandre@briug.org>wrote:
> > >
> > > > Thanks very much, Art.
> > > > We always like to prior our primary instance, in a physical "site=
> A"
> > > > location,
> > > > that=B4s what I tried to say.
> > > > What if I just move the "old primary node", now an SDS secondary
> (after
> > the
> > > > failover is finished), to a primary node?
> > > > onmode -d make primary [node]> > > > Couldn=B4t it work? Cmsm wouldn=B4t do the automatic changes? I w=
> ill try
> > that
> > > > later... just an idea.
> > > >
> > > > Thanks, anyway.
> > > >
> > > > Alexandre Marini
> > > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > > >
> > > > IBM Information Management Informix Technical Professional
> > > >
> > > > IBM Infosphere DataStage Technical Professional
> > > > Informix Senior DBA - Orizon Brasil
> > > > BRIUG website administrator
> > > > Informix independent consultant
> > > >
> > > > > To: ids@iiug.org
> > > > > From: art.kagel@gmail.com
> > > > > Subject: Re: cmsm in a cluster + switchover? DRAUTO=3D1+3 ??? [=
> 30072]
>
> > > > > Date: Tue, 16 Apr 2013 15:37:30 -0400
> > > > >
> > > > > No. It means that you have to use the CMSM failover configurati=
> on
> and
> > let
> > > > > Connection Manager manage the failover. This has the advantage =
> that
>
> > you
> > > > > can have CM set the SDS secondary as the first choice to make i=
> nto
> > > > primary
> > > > > and leave the HDR secondary as is unless the SDS also fails the=
> n
> > upgrade
> > > > > the HDR secondary to primary.
> > > > >
> > > > > Having the CM manage failover is more robust than DR_AUTO. I ma=
> kes
> > > > > additional checks before failing over, and in 11.70 more so and=
> in
> > 12.10
> > > > > you can specify alternative communications paths to insure that=
> you
>
> > never
> > > > > end up with two primaries.
> > > > >
> > > > > 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, Apr 16, 2013 at 2:25 PM, ALEXANDRE MARINI
> > > > <alexandre@briug.org>wrote:
> > > > >
> > > > > > Hello.
> > > > > > He have a cluster, version 11.50 (plans to upgrade soon) with=
> one
>
> > > > primary,
> > > > > > one
> > > > > > SDS, and one HDR.
> > > > > >
> > > > > > I have a simple question, but didn=B4t find the answer yet, s=
> o
> maybe
> > > > someone
> > > > > > could help me.
> > > > > >
> > > > > > If I enable DRAUTO=3D1, I can easily see the changes rolling =
> from
> hdr
> > > > > > secondary
> > > > > > to primary, and vice versa, as expected if a failure occurs.
> > > > > >
> > > > > > But now, I am trying to do a lab (in informix VA cluster
> > > > demonstration),
> > > > > > but... there is no way to do an automatic switchover (like
> > DRAUTO=3D1+3)
> > > > with
> > > > > > cmsm enabled?
> > > > > >
> > > > > > Documentation says it is even not recommended:
> > > > > > "You shou