Informix Replication

I'm looking at setting up replication with HDR (High Availability Data Replication) between our production HP 9000 and our D/R HP 9000. We are running HPUX 11.23 and Informix 10.00.HC5. In the past, I've used the Ignite process from HP to make a bootable backup tape of production and restore to D/R. This took care of all my volume groups and HPUX system files. I then just restored the database with ontape. This is a long and tedious process but it does work well. This has been our Disaster Recovery procedure when preparing for oncoming hurricanes. Now I want to take advantage of replication. Our vendor, Jenzabar has told us we can not use Enterprise Replication. I can't remember why it does not work. From some of the reading I've done, it doesn't look too hard to set up HDR. We have a 100 MB pipe between our production server and D/R. I'm thinking the pipe should be sufficient for replication. Right now I have both servers on the same network so I can reach them both. I'm just not sure how to deal with some of these items. 1. HP 9000 is the hostname of production, drhp 9000 is the name of D/R 2. 10.2.24.64 IP in production, 10.2.25.64 for D/R 3. Since the secondary, D/R will be read only, can the Informix server, service and protocol be the same? Any help would be greatly appreciated. Andy Pistocchi DBA / Systems Administrator

Because your DR site is remote, I would suggest going up to 11.10 or 11.50 and setting up the DR server as an RDS server rather than as an HDR secondary. The full duplex protocol that the RDS server uses is better when the secondary is not local to the same data center. You could also set up a local HDR secondary, but that's not necessary. Art On Fri, Jan 30, 2009 at 1:39 PM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu> wrote: > I'm looking at setting up replication with HDR (High Availability Data > Replication) between our production HP 9000 and our D/R HP 9000. We are > running HPUX 11.23 and Informix 10.00.HC5. In the past, I've used the > Ignite process from HP to make a bootable backup tape of production and > restore to D/R. This took care of all my volume groups and HPUX system > files. I then just restored the database with ontape. This is a long > and tedious process but it does work well. This has been our Disaster > Recovery procedure when preparing for oncoming hurricanes. > > Now I want to take advantage of replication. Our vendor, Jenzabar has > told us we can not use Enterprise Replication. I can't remember why it > does not work. From some of the reading I've done, it doesn't look too > hard to set up HDR. We have a 100 MB pipe between our production server > and D/R. I'm thinking the pipe should be sufficient for replication. > Right now I have both servers on the same network so I can reach them > both. > > I'm just not sure how to deal with some of these items. > > 1. HP 9000 is the hostname of production, drhp 9000 is the name of > D/R > > 2. 10.2.24.64 IP in production, 10.2.25.64 for D/R > > 3. Since the secondary, D/R will be read only, can the Informix > server, service and protocol be the same? > > Any help would be greatly appreciated. > > Andy Pistocchi > > DBA / Systems Administrator > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- 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. --00504502b1941177190461b7ee00

One correction - RSS (Remote Stand-alone Secondary) is the correct term= (not RDS). RSS is designed to be used as a disaster recovery solution.= Conceptually it's same as HDR, with some added advantages. Here is info= on "When to use RSS" http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adm= in.doc/ids_admin_0989.htm Regards, Nilesh ids-bounces@iiug.org wrote on 01/30/2009 01:08:35 PM: > [image removed] > > Re: Informix Replication [14672] > > Art Kagel > > to: > > ids > > 01/30/2009 01:09 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Because your DR site is remote, I would suggest going up to 11.10 or 11.50 > and setting up the DR server as an RDS server rather than as an HDR > secondary. The full duplex protocol that the RDS server uses is bette= r when > the secondary is not local to the same data center. You could also se= t up a > local HDR secondary, but that's not necessary. > > Art > > On Fri, Jan 30, 2009 at 1:39 PM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu>= wrote: > > > I'm looking at setting up replication with HDR (High Availability D= ata > > Replication) between our production HP 9000 and our D/R HP 9000. We= are > > running HPUX 11.23 and Informix 10.00.HC5. In the past, I've used t= he > > Ignite process from HP to make a bootable backup tape of production= and > > restore to D/R. This took care of all my volume groups and HPUX sys= tem > > files. I then just restored the database with ontape. This is a lon= g > > and tedious process but it does work well. This has been our Disast= er > > Recovery procedure when preparing for oncoming hurricanes. > > > > Now I want to take advantage of replication. Our vendor, Jenzabar h= as > > told us we can not use Enterprise Replication. I can't remember why= it > > does not work. From some of the reading I've done, it doesn't look = too > > hard to set up HDR. We have a 100 MB pipe between our production se= rver > > and D/R. I'm thinking the pipe should be sufficient for replication= . > > Right now I have both servers on the same network so I can reach th= em > > both. > > > > I'm just not sure how to deal with some of these items. > > > > 1. HP 9000 is the hostname of production, drhp 9000 is the name of > > D/R > > > > 2. 10.2.24.64 IP in production, 10.2.25.64 for D/R > > > > 3. Since the secondary, D/R will be read only, can the Informix > > server, service and protocol be the same? > > > > Any help would be greatly appreciated. > > > > Andy Pistocchi > > > > DBA / Systems Administrator > > > > > > > > > ***********************************************************************= ******** > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > -- > 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 opini= ons and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither d= o > those opinions reflect those of other individuals affiliated with any= entity > with which I am affiliated nor those of the entities themselves. > > --00504502b1941177190461b7ee00 > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

Yes, RSS. Senior moment. Art On Fri, Jan 30, 2009 at 4:07 PM, Nilesh Ozarkar <nilesho@us.ibm.com> wrote: > One correction - RSS (Remote Stand-alone Secondary) is the correct term= > > (not RDS). RSS is designed to be used as a disaster recovery solution.= > > Conceptually it's same as HDR, with some added advantages. Here is info= > on > "When to use RSS" > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adm= > in.doc/ids_admin_0989.htm > > Regards, > Nilesh > > ids-bounces@iiug.org wrote on 01/30/2009 01:08:35 PM: > > > [image removed] > > > > Re: Informix Replication [14672] > > > > Art Kagel > > > > to: > > > > ids > > > > 01/30/2009 01:09 PM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > Because your DR site is remote, I would suggest going up to 11.10 or > 11.50 > > and setting up the DR server as an RDS server rather than as an HDR > > secondary. The full duplex protocol that the RDS server uses is bette= > r > when > > the secondary is not local to the same data center. You could also se= > t up > a > > local HDR secondary, but that's not necessary. > > > > Art > > > > On Fri, Jan 30, 2009 at 1:39 PM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu>= > > wrote: > > > > > I'm looking at setting up replication with HDR (High Availability D= > ata > > > Replication) between our production HP 9000 and our D/R HP 9000. We= > are > > > > running HPUX 11.23 and Informix 10.00.HC5. In the past, I've used t= > he > > > Ignite process from HP to make a bootable backup tape of production= > and > > > > restore to D/R. This took care of all my volume groups and HPUX sys= > tem > > > files. I then just restored the database with ontape. This is a lon= > g > > > and tedious process but it does work well. This has been our Disast= > er > > > Recovery procedure when preparing for oncoming hurricanes. > > > > > > Now I want to take advantage of replication. Our vendor, Jenzabar h= > as > > > told us we can not use Enterprise Replication. I can't remember why= > it > > > does not work. From some of the reading I've done, it doesn't look = > too > > > hard to set up HDR. We have a 100 MB pipe between our production se= > rver > > > > and D/R. I'm thinking the pipe should be sufficient for replication= > .. > > > Right now I have both servers on the same network so I can reach th= > em > > > both. > > > > > > I'm just not sure how to deal with some of these items. > > > > > > 1. HP 9000 is the hostname of production, drhp 9000 is the name of > > > D/R > > > > > > 2. 10.2.24.64 IP in production, 10.2.25.64 for D/R > > > > > > 3. Since the secondary, D/R will be read only, can the Informix > > > server, service and protocol be the same? > > > > > > Any help would be greatly appreciated. > > > > > > Andy Pistocchi > > > > > > DBA / Systems Administrator > > > > > > > > > > > > > > > ***********************************************************************= > ******** > > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > > > > > > -- > > 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 opini= > ons > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither d= > o > > those opinions reflect those of other individuals affiliated with any= > > entity > > with which I am affiliated nor those of the entities themselves. > > > > --00504502b1941177190461b7ee00 > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > >= > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- 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. --001636c5bf72167be00461b9a49f