MQSeries.net :: View topic

narendra · Posted: Tue Feb 04, 2003 8:01 am Post subject: SQL State '08007'

I have a message flow to query data from db2 database and breakup each row into XML then propagate.
This works fine for rows approximately less than 100000.
Any thing over that it gives the following DB2 error and rolls back the whole transaction.

( PWD.MODEL_1 ) Database error: SQL State '08007'; Native Error Code '-30081'; Error Text '[IBM][CLI Driver][DB2/6000] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.111.17.32". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001
'.

The error has the following diagnostic information: SQL State '08007' SQL Native Error Code '-30081' SQL Error Text '[IBM][CLI Driver][DB2/6000] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.111.17.32". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001
'

This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

Please let know, if any one has come across this problem

Narendra