dbTalk Databases Forums  

version 11 in plae upgrade and HDR

comp.databases.informix comp.databases.informix


Discuss version 11 in plae upgrade and HDR in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Neil Truby
 
Posts: n/a

Default Re: version 11 in plae upgrade and HDR - 04-23-2010 , 06:13 PM






Hey, Dave, if you're out there can you answer this? I'm really intersted in
understanding your original reply.

cheers


"Neil Truby" <neil.truby (AT) ardenta (DOT) com> wrote

Quote:
david (AT) smooth1 (DOT) co.uk> wrote in message
news:21f17bed-0c3a-4311-a7d5-ec3a0f09acdc (AT) g30g2000yqc (DOT) googlegroups.com...
On 20 Apr, 14:13, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:
"Nick Lello" <nick.le... (AT) rentrakmail (DOT) com> wrote in message

news:mailman.140.1271749880.1071.informix-list (AT) iiug (DOT) org...
This is totally unsupported; but we managed to upgrade from 10.0.fc6 to
11.10.fc1 about 6 months ago in a similar situation (wide-area hdr,
database
too big to archive/restore over the network).

Here's what we did:-

All threads off, take both engines to quiescent mode
Shutdown primary; onmode -yuck
Shutdown secondary; onmode -yk
Get the new Informix software in place on both servers (we have
$INFORMIXDIR
pointing to a symbolic link so we can upgrade easily)
Bring up the primary -- allow all upgrade activity to complete
Bring up the secondary --- internal upgrade processes + updated pages
spooled through HDR appeared to perform the upgrade cleanly

I'll repeat, IBM in no way sanctioned or supported upgrading the HDR
pair
in this manner; we did this out of desperation to get the upgrade
completed.

That's interesting. In depsperation, we might need to do this too ...

This should be even easier using external backup and restore to
initiate HDR.

http://publib.boulder.ibm.com/infoce.../barmst184.htm

1. Create a third mirror for the primary at the secondary site (resync
might take several days - fine)

What kind of a mirror? A SAN replication mirror (in our case, replicating
via 2Mbs IP from London to Sydney)?
Or, am I misunderstanding (probably!) ...?

thanks

Reply With Quote
  #12  
Old   
david@smooth1.co.uk
 
Posts: n/a

Default Re: version 11 in plae upgrade and HDR - 04-26-2010 , 05:23 PM






On 22 Apr, 01:28, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:
Quote:
da... (AT) smooth1 (DOT) co.uk> wrote in message

news:21f17bed-0c3a-4311-a7d5-ec3a0f09acdc (AT) g30g2000yqc (DOT) googlegroups.com...
On 20 Apr, 14:13, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:



"Nick Lello" <nick.le... (AT) rentrakmail (DOT) com> wrote in message

news:mailman.140.1271749880.1071.informix-list (AT) iiug (DOT) org...
This is totally unsupported; but we managed to upgrade from 10.0.fc6 to
11.10.fc1 about 6 months ago in a similar situation (wide-area hdr,
database
too big to archive/restore over the network).

Here's what we did:-

All threads off, take both engines to quiescent mode
Shutdown primary; onmode -yuck
Shutdown secondary; onmode -yk
Get the new Informix software in place on both servers (we have
$INFORMIXDIR
pointing to a symbolic link so we can upgrade easily)
Bring up the primary -- allow all upgrade activity to complete
Bring up the secondary --- internal upgrade processes + updated pages
spooled through HDR appeared to perform the upgrade cleanly

I'll repeat, IBM in no way sanctioned or supported upgrading the HDR
pair
in this manner; we did this out of desperation to get the upgrade
completed.

That's interesting. In depsperation, we might need to do this too ...

This should be even easier using external backup and restore to
initiate HDR.

http://publib.boulder.ibm.com/infoce...dex.jsp?topic=....

1. Create a third mirror for the primary at the secondary site (resync

might take several days - fine)

What kind of a mirror? *A SAN replication mirror (in our case, replicating
via 2Mbs IP from London to Sydney)?
Or, am I misunderstanding (probably!) ...?

thanks
Yes a SAN mirror, you did not state the the link was only 2MB, how
much data do you have?

How do you plan to reestablish replication if the secondary server
suffers HBA failure and disk corruption?

Reply With Quote
  #13  
Old   
Nick
 
Posts: n/a

Default Re: version 11 in plae upgrade and HDR - 04-27-2010 , 07:01 AM



fyi I just found that Nick L's method did not work upgrading
from 11.50.fc4 to 11.50.fc6. When initializing the secondary, I got
errors
immediately stating that each chunk was marked down, and to revert
back to fc4 to bring the chunks online. (I did not actually try
that,
knowing that I had just cleanly shutdown.)

Too bad - this would have saved lots of time!

On Apr 20, 2:43*am, Nick Lello <nick.le... (AT) rentrakmail (DOT) com> wrote:
Quote:
This is totally unsupported; but we managed to upgrade from 10.0.fc6 to
11.10.fc1 about 6 months ago in a similar situation (wide-area hdr, database
too big to archive/restore over the network).

Here's what we did:-

* *- All threads off, take both engines to quiescent mode
* *- Shutdown primary; onmode -yuck
* *- Shutdown secondary; onmode -yk
* *- Get the new Informix software in place on both servers (we have
* *$INFORMIXDIR pointing to a symbolic link so we can upgrade easily)
* *- Bring up the primary -- allow all upgrade activity to complete
* *- Bring up the secondary --- internal upgrade processes + updated pages
* *spooled through HDR appeared to perform the upgrade cleanly

I'll repeat, IBM in no way sanctioned or supported upgrading the HDR pairin
this manner; we did this out of desperation to get the upgrade completed.

Reply With Quote
  #14  
Old   
Neil Truby
 
Posts: n/a

Default Re: version 11 in plae upgrade and HDR - 04-30-2010 , 08:21 PM



<david (AT) smooth1 (DOT) co.uk> wrote

On 22 Apr, 01:28, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:

Quote:
Yes a SAN mirror, you did not state the the link was only 2MB, how
much data do you have?

300g

Quote:
How do you plan to reestablish replication if the secondary server
suffers HBA failure and disk corruption?

Good question. It hasn't failed in the 4y 2m it's been running. So,
obviously, it never will ;-)

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.