| Author |
Message
|
| smeunier |
 Posted: Tue Mar 10, 2009 1:56 pm Post subject: Database crash, broker needs to be recycled?!?!? |
 |
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
We have had a situation in the past where our database crashed & had to be restarted. Because of this we had to recycle our broker so that the flows could re-connect to the database. Is there a way to re-connect the flows to a database without having to recycle the broker?
It appears the broker by proxy makes the connection rather than the flow itself. |
|
| Back to top |
|
 |
| smeunier |
| Posted: Tue Mar 10, 2009 4:45 pm Post subject: |
|
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
| Just to clarify, when I say database, this is not the Broker Db, but a user Db that crashed. The broker needed to be restarted to regain access. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Mar 10, 2009 4:47 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Just to clarify, the behavior here is radically different between different versions of Message Broker. |
|
| Back to top |
|
|
| WMBEAI |
| Posted: Tue Mar 10, 2009 8:29 pm Post subject: |
|
|
Acolyte
Joined: 02 Mar 2009
Posts: 66
|
| If the database is not Broker DB and it is Application Database then instead of reloading the broker i think an mqsisetdbparms should do the taks of the broker identifying the database and doing the connection part of it |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Mar 11, 2009 12:20 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| WMBEAI wrote: |
| i think an mqsisetdbparms should do the taks of the broker identifying the database and doing the connection part of it |
Depends on which version of broker is in use (as my most worthy associate mentioned).
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smeunier |
| Posted: Wed Mar 11, 2009 4:34 am Post subject: |
|
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
| This is V6 broker with latest Fix pacs. I'll investigate mqsisetdbparms, but what I'm hearing is that connectivity to an application DB should not require Broker to be recycled. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Mar 11, 2009 4:37 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Remember that "the broker" is composed of more than one running process, and that none of these running processes are "the flow".
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Mar 11, 2009 5:25 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
A v6.0 broker should not require a full restart to re-establish connections to a User database.
But, the flows may have to retry enough times to identify all of the active connections in the connection pool as needing to be reconnected. And it may be simpler, given that you know there is a database issue, to mqsireload or mqsistop/mqsistart. |
|
| Back to top |
|
|
|
|
