DBSERVERNAME in an HDR Environment
User asked whether DBSERVERNAME must be identical or different between primary and secondary servers in an HDR environment. Experts confirmed they must be different (unique in sqlhosts file). The resolved approach was to create a group in sqlhosts or use Connection Manager, allowing clients to reference a single name that automatically points to the primary when online or secondary when offline.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance.
Original post: Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance. Reply: They would be different due to the fact that DBSERVERNAMES would need to be unique in the sqlhosts file, and each server would need to have both server names in the sqlhosts file. Jacques Renaut IBM Informix Advanced Support
Different. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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 Mon, Sep 26, 2016 at 11:34 AM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > In an HDR Environment, the DBSERVERNAME of the primary server must be the > same > of the secondary or they must be differents ? > > Thanks in advance. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11468f0cd56c2b053e13040d
Thanks you. > El 04/10/2016, a las 17:12, Art Kagel <art.kagel@gmail.com> escribió: > > Different. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.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 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 Mon, Sep 26, 2016 at 11:34 AM, Jorge Valenzuela <jorgervt@gmail.com> > wrote: > >> Hi, >> In an HDR Environment, the DBSERVERNAME of the primary server must be the >> same >> of the secondary or they must be differents ? >> >> Thanks in advance. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11468f0cd56c2b053e13040d > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Don't remember if anyone else mentioned this: if you set up a group in your sqlhosts files that includes both the primary and secondary, or you use Connection Manager to connect to the server, you can use the group or connection manager name in the synonym definition instead of the actual server name of the primary and then they will point to the primary while it is online and the secondary when the primary is offline. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, Oct 4, 2016 at 8:57 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Thanks you. > > > El 04/10/2016, a las 17:12, Art Kagel <art.kagel@gmail.com> escribió: > > > > Different. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.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 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 Mon, Sep 26, 2016 at 11:34 AM, Jorge Valenzuela <jorgervt@gmail.com> > > wrote: > > > >> Hi, > >> In an HDR Environment, the DBSERVERNAME of the primary server must be > the > >> same > >> of the secondary or they must be differents ? > >> > >> Thanks in advance. > >> > >> > >> ************************************************************ > >> ******************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > --001a11468f0cd56c2b053e13040d > > > > > > > ************************************************************ > ******************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11468f0ca2f3ac053e1ecfbc
Yes, we resolved in this way. Thanks. > El 05/10/2016, a las 07:15, Art Kagel <art.kagel@gmail.com> escribió: > > Don't remember if anyone else mentioned this: if you set up a group in your > sqlhosts files that includes both the primary and secondary, or you use > Connection Manager to connect to the server, you can use the group or > connection manager name in the synonym definition instead of the actual > server name of the primary and then they will point to the primary while it > is online and the secondary when the primary is offline. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.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 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, Oct 4, 2016 at 8:57 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: >> >> Thanks you. >> >>> El 04/10/2016, a las 17:12, Art Kagel <art.kagel@gmail.com> escribió: >>> >>> Different. >>> >>> Art >>> >>> Art S. Kagel, President and Principal Consultant >>> ASK Database Management >>> www.askdbmgt.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 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 Mon, Sep 26, 2016 at 11:34 AM, Jorge Valenzuela <jorgervt@gmail.com> >>> wrote: >>> >>>> Hi, >>>> In an HDR Environment, the DBSERVERNAME of the primary server must be >> the >>>> same >>>> of the secondary or they must be differents ? >>>> >>>> Thanks in advance. >>>> >>>> >>>> ************************************************************ >>>> ******************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>>> >>>> >>> >>> --001a11468f0cd56c2b053e13040d >>> >>> >>> >> ************************************************************ >> ******************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11468f0ca2f3ac053e1ecfbc > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >