HDR between different versions
Mark asked whether an HDR pair could run between IDS 11 and IDS 9.4UC7, so he could fall back to 9.4 if the upgrade caused performance problems. Answers were clear: no — HDR requires both servers to run identical binaries, and logical log record differences between versions would break recovery. Enterprise Replication, however, works across 11 and 9.4 and can keep servers in sync during an upgrade. Art Kagel also outlined the in-place HDR upgrade steps: install the new version in a new directory on both machines, copy/adjust ONCONFIG and SQLHOSTS, shut both servers down, repoint INFORMIXDIR, then start the primary followed by the secondary.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Is it possible to set an HDR pair between and IDS 11 server and an IDS 9.4UC7 server? We are having an issue with IDS 11 (posted in another thread) and want to be able to fall back to 9.4 if there are speed issues after the upgrade. Thanks, Mark
>Is it possible to set an HDR pair between and IDS 11 server and an IDS 9.4UC7 server? We are having an >issue with IDS 11 (posted in another thread) and want to be able to fall back to 9.4 if there are speed issues >after the upgrade. > >Thanks, >Mark No it's not. There are going to be logical log record differences that would break recovery between the 2 versions. IBM IDS Advanced Support APD Team
No HDR requires that the primary and secondary be running the same executa= ble binaries. ER, however will work just find between 11 and 9.4 = "MARK NEWNAM" = <mnewnam@carolina = handling.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect HDR between different versions = 06/02/2009 01:38 [15895] = PM = = = Please respond to = ids@iiug.org = = = Is it possible to set an HDR pair between and IDS 11 server and an IDS 9.4UC7 server? We are having an issue with IDS 11 (posted in another thread) a= nd want to be able to fall back to 9.4 if there are speed issues after the upgr= ade. Thanks, Mark ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Can we upgrade the two servers to IDS 11.1 without breaking HDR? If we bring both servers down, perform the upgrade and bring them back up, will HDR still be intact or do we need to break it, upgrade and then create the HDR pair? If it can be done, is there a specific order that the servers should be upgraded? Thanks, Mark
No, HDR pairs must be identical. You can use ER to maintain sync between servers during an upgrade. If you don't have ER (ie you are using Express or Workgroup Edition for example), you may be able to get a short term license for ER from IBM just for the upgrade period. Contact IBM. 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. On Tue, Jun 2, 2009 at 2:38 PM, MARK NEWNAM <mnewnam@carolinahandling.com>wrote: > Is it possible to set an HDR pair between and IDS 11 server and an IDS > 9.4UC7 > server? We are having an issue with IDS 11 (posted in another thread) and > want > to be able to fall back to 9.4 if there are speed issues after the upgrade. > > Thanks, > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5a501062191046b64484e
You have to: - Install 11.50 or 11.10 on both servers into new directories (not the existing INFORMIXDIR). - Copy the ONCONFIG file and SQLHOSTS file from the existing INFORMIXDIR to the new one. - Make any adjustments to the ONCONFIG file to take advantage of new features. - Shut down both servers. - Point the INFORMIXDIR link to the new installation. - Start the primary using the new version. - Start the secondary using the new version. Art 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. On Tue, Jun 2, 2009 at 4:11 PM, MARK NEWNAM <mnewnam@carolinahandling.com>wrote: > Can we upgrade the two servers to IDS 11.1 without breaking HDR? If we > bring > both servers down, perform the upgrade and bring them back up, will HDR > still > be intact or do we need to break it, upgrade and then create the HDR pair? > > If it can be done, is there a specific order that the servers should be > upgraded? > > Thanks, > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e6d27c9050eb60046b645e6a