| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Please help: DB2 connection error |
« View previous topic :: View next topic » |
| Author |
Message
|
| fnl |
 Posted: Wed May 29, 2002 11:16 am Post subject: Please help: DB2 connection error |
 |
|
Newbie
Joined: 20 Jan 2002
Posts: 6
Location: Waterloo, ON.
|
Hi,
I created a flow to access DB2 on OS/390 from WMQI v2.1. An error occurrs sometimes. Following is an copies of the error. If anybody knows about it, please let me know.
Database error: SQL State '40003'; Native Error Code '-30081'; Error Text '[IBM][CLI
Driver][DB2] SQL30081N A communication error has been detected. Communication
protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Locat
ion where the error was detected: "". Communication function detecting the erro
r: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001: EID
C.6280f5ba-ec00-0000-0080-d425ba7c6bf1: /build/S210_P/src/DataFlowEngine/ImbOdbc
.cpp: 234: ImbOdbcHandle::checkRcInner: :
Thank you in advance for helping!
Fanny. |
|
| Back to top |
|
 |
| JLRowe |
| Posted: Wed May 29, 2002 12:41 pm Post subject: |
|
|
Yatiri
Joined: 25 May 2002
Posts: 664
Location: South East London
|
It happens occasionally?
Looks more like a network or TCP/IP problem to me... |
|
| Back to top |
|
|
| fnl |
| Posted: Wed May 29, 2002 1:23 pm Post subject: |
|
|
Newbie
Joined: 20 Jan 2002
Posts: 6
Location: Waterloo, ON.
|
The flow sometimes works fine. I have got some data from the mainframe.
I have no idea why it happens sometimes daily. We guess maybe connection timeout. If it's the case, what action starts it again? |
|
| Back to top |
|
|
| michaelpatton |
| Posted: Wed May 29, 2002 2:40 pm Post subject: DB2 Connection Error |
|
|
Apprentice
Joined: 21 May 2002
Posts: 25
Location: East Coast USA
|
Fanny, the error you are experiencing may have to do more with DB2
rather than MQSI. If you have at least CSD1 installed on your
WMQI 2.1 system, then WMQI should be handling the error properly.
If not, I recommend that you download and install the latest CSD
for WMQI. It can be found at
http://www-.ibm.com/software/ts/mqseries/support/summary/mqsi.html
The fix involves the way that MWMQI handles the communication error.
As for why this happens, I have seen where a DELETE or an UPDATE
command was issued against a non-existant row in the table, and is
an issue with DB2 and not with WMQI |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
