MQSeries.net :: View topic - WBIMB recconect to Broker DB

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB recconect to Broker DB

WBIMB recconect to Broker DB

« View previous topic :: View next topic »

Author

Message

lsanschargrin

Posted: Wed Mar 16, 2005 12:16 pm Post subject: WBIMB recconect to Broker DB

Newbie

Joined: 29 Aug 2003
Posts: 2
Location: florida

Hello All,

I'm working on a High Availability WBIMB configuration where the Broker is running in a seperate AIX LPAR from my Oracle Broker database. Will the Broker reconnect to the Broker DB if the connection is lost (either because of connectivity issues are DB failure and failover) ? Any Assistance is appreciated !

Thx, Len

Nizam

Posted: Wed Mar 16, 2005 12:48 pm Post subject:

Disciple

Joined: 10 Feb 2004
Posts: 160

I have read somewhere that it is a good practice to restart the broker incase of db failures.
I do not know if it can connect automatically.
_________________
Nyzam
IBM Cert. Solution Designer - WBIMB V5
IBM Cert. Administrator - WBIMB V5
IBM Cert. Administrator - WebSphere MQ V5.3

PGoodhart

Posted: Fri Mar 18, 2005 5:00 am Post subject:

Master

Joined: 17 Jun 2004
Posts: 278
Location: Harrisburg PA

If your connection is lost and you are running v5 of the broker and your are talking about "Broker" databases the connection will automatically recover. If you are running version 2.1, no it won't. If you are talking about user dataabases then no it won't do it automatically. But if you properly error handle your database calls in ESQL then you can just recall your SQL statement and if the connection can be reestablished, it will run. If the database is still not available (IE the cable isn't back connected to the machine) then it will fail again. If you can avoid having your database server and broker on seperate machines then that really does help stablity.
_________________
Patrick Goodhart
MQ Admin/Web Developer/Consultant
WebSphere Application Server Admin

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB recconect to Broker DB

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP