| Author |
Message
|
| skydoor |
 Posted: Wed Jan 23, 2008 11:37 pm Post subject: ESQL database disconnect problem |
 |
|
Apprentice
Joined: 24 Jul 2007
Posts: 43
Location: Cape Town
|
I have the following flow: mqinput->computenode. I receive messages and I update an oracle db with the data via stored procedures called in the esql.
Everything works well until the oracle dba decides to reboot the oracle db server.
At this point my messages starts building up in the delivery queue. I have not found errors that could point me in a direction.
My theory is that the flow loses the connection to the db (obviously) but still keeps the old connection pointer. I have had a look for an explicit disconnect, reconnect or timeout property or command but I can not find any in the documentation (which does not mean it is not there, I might be looking in the wrong places).
Is there a explicit disconnect/reconnect/timeout that I am missing somewhere or must I follow another procedure? |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jan 25, 2008 1:23 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
DB's are meant for high availability.
This means you may have to restart the flow if there was an interruption in connectivity...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 25, 2008 1:59 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version of Broker, please.
The behavior and tolerance of a message flow for a dropped connection are very very different in for example 2.1 than in 6.1.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| skydoor |
| Posted: Sun Jan 27, 2008 10:57 pm Post subject: |
|
|
Apprentice
Joined: 24 Jul 2007
Posts: 43
Location: Cape Town
|
fjb_saper:
| Quote: |
| DB's are meant for high availability |
I don't quite understand what you mean with regards to this problem... could you elaborate?
jefflowrey:
Versions below. I am assuming from your comment that there are procedures/methods to deal with this kind of scenario?
Thanks
C:\IBM\MQSI\6.0\bin>mqsiprofile
MQSI 6.0.0.1
C:\IBM\MQSI\6.0
C:\IBM\MQSI\6.0\bin>dspmqver
Name: WebSphere MQ
Version: 6.0.2.1
CMVC level: p600-201-070323
BuildType: IKAP - (Production)
_________________
The answer to the question is 42 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Jan 28, 2008 7:31 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should probably upgrade to at least MB 6.0.0.3... if not latest MB FP.
There are some fixes in this area in the later FPs.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| skydoor |
| Posted: Mon Jan 28, 2008 7:41 am Post subject: |
|
|
Apprentice
Joined: 24 Jul 2007
Posts: 43
Location: Cape Town
|
jefflowrey:
| Quote: |
| You should probably upgrade to at least MB 6.0.0.3... if not latest MB FP. |
I did in my test environment to enable some needed features but I had so many problems I rolled it back and I did not want to touch it again out of fear for the beast.
Do you know of any procedures/methods I can use off the top of your head?
_________________
The answer to the question is 42 |
|
| Back to top |
|
|
| VivekMeshram |
| Posted: Sat Feb 02, 2008 5:22 am Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
I have one suggestion before processing/connecting to Oracle DB, attach a subflow with compute node [Input=>ComputeNode=>Output] in the compute node, pass the Data Source name and check the connection to Database using ESQL SET Environment.temp.ConnTest[] = PASSTHRU('SELECT count(*) FROM Database. DUAL’)......
See whether this can be helpful to you… |
|
| Back to top |
|
|
|
|
