Author |
Message
|
elikatz |
Posted: Tue Jan 12, 2010 8:55 pm Post subject: sequence number - sites failover |
|
|
Voyager
Joined: 24 Feb 2009 Posts: 86
|
Hi,
We have 2 site that suppose to switch between them every 2 weeks.
On both site we have MQ version 6.0.2.7 installed on windows 2003 server cluster.
I "synchronize" the MQ using the savqmgr.
When we do the fail over between the sites we find we have a problem with the sequence number for all the server to server connectivity's.
Is there a sophisticated way to solve this issue or we have to go over the channels one by one and fix the sequence?
I'm looking for a way to synch the sequence number, is it possible?
Thanks,
Eli |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Jan 13, 2010 2:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
ms03 will generate reset channel commands if you ask it to.
read.me wrote: |
--resetChannels | -R [flags] : create RESET CHANNEL commands
flags can be any combination of the follow to create RESET for that channel type:
s (SENDER) v (SERVER) r (RECEIVER) q (REQUESTER) c (CLUSSDR) d (CLUSRCVR)
the default is to create RESET commands for all the above channel types |
|
|
Back to top |
|
 |
PeterPotkay |
Posted: Wed Jan 13, 2010 9:33 am Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
That will work for the SNDRs, as when he resets them they will reset the RCVRs on the other QMs.
But the RCVRs cannot all be reset to 1. Each has to be looked at one by one and fixed accordingly. _________________ Peter Potkay
Keep Calm and MQ On |
|
Back to top |
|
 |
elikatz |
Posted: Wed Jan 13, 2010 10:21 am Post subject: |
|
|
Voyager
Joined: 24 Feb 2009 Posts: 86
|
we are looking into do something automatically or at least have the ability to do this without contacting our clients.
is there a way to synch the sequence number from the "active" site? |
|
Back to top |
|
 |
bruce2359 |
Posted: Wed Jan 13, 2010 10:50 am Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
RESET CHANNEL, if done from the SDR/SVR channel end, will reset both ends. If done at a Receiver (RCVR), Requester (RQSTR) or Cluster-receiver (CLUSRCVR) channel, the value at the other end of the channel is NOT reset. You must reset the values separately. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
elikatz |
Posted: Thu Jan 14, 2010 6:40 am Post subject: |
|
|
Voyager
Joined: 24 Feb 2009 Posts: 86
|
well... since there are clients involved in the process and I don't want to notify them every time to reset their channel I'm looking for a way to synch the sequence number from site a to site b.
even if i reset all my senders it won't help as i'll still have to notify the clients to reset their senders.
I guess that if i find a way to "copy" the sequence number from site a to site b it will solve the problem as the number will be the same all time - I can think of only one issue with this, let's assume i'll find a way to do this (to reset the rcvr to the right number, will it work or the sender will still look for the original number? |
|
Back to top |
|
 |
PeterPotkay |
Posted: Thu Jan 14, 2010 1:27 pm Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
When their SNDRs try and talk to your RCVRs, you will see what seq # they want to us ein your error logs and can issue the rest command on your side to match. Of course you are now in reactive mode and have to wait for their channel to start up and retry before you will see the error on your side. _________________ Peter Potkay
Keep Calm and MQ On |
|
Back to top |
|
 |
SJ |
Posted: Fri Jan 15, 2010 6:04 am Post subject: |
|
|
Newbie
Joined: 02 May 2003 Posts: 8 Location: US
|
Before you cutover, I'm assuming all the receiver channels are inactive, could you save off the sequence numbers
dis chs( <channel name>) saved LSTSEQNO
and then reset the other site with them? |
|
Back to top |
|
 |
PeterPotkay |
Posted: Fri Jan 15, 2010 12:25 pm Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
SJ wrote: |
Before you cutover, I'm assuming all the receiver channels are inactive, |
An odd assumption for a DR solution. Disasters have the uncanny habit of occurring at the most inconvenient times. _________________ Peter Potkay
Keep Calm and MQ On |
|
Back to top |
|
 |
exerk |
Posted: Fri Jan 15, 2010 12:48 pm Post subject: |
|
|
 Jedi Council
Joined: 02 Nov 2006 Posts: 6339
|
PeterPotkay wrote: |
SJ wrote: |
Before you cutover, I'm assuming all the receiver channels are inactive, |
An odd assumption for a DR solution. Disasters have the uncanny habit of occurring at the most inconvenient times. |
elikatz wrote: |
...We have 2 site that suppose to switch between them every 2 weeks... |
_________________ It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
Back to top |
|
 |
PeterPotkay |
Posted: Fri Jan 15, 2010 12:51 pm Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
They aren't switching back and forth for the fun of it. I assume (there's that word again!) its so they know either site is 100% viable, in case there is a disaster. _________________ Peter Potkay
Keep Calm and MQ On |
|
Back to top |
|
 |
elikatz |
Posted: Fri Jan 15, 2010 1:23 pm Post subject: |
|
|
Voyager
Joined: 24 Feb 2009 Posts: 86
|
In this case it's not just a DR - we are suppose to work 2 weeks from site a and 2 weeks from site b (basically both are suppose to be active - for example, the database of this project works with 2 phase commit) |
|
Back to top |
|
 |
|