Errors encountered while Ececuting a procedure

[synap1974]

SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.80.10.46". Communication function detecting
the error: "recv". Protocol specific error code(s): "10054", "*", "0".
SQLSTATE=08001

 

[MarcLodge]

IBM have a Connectivity Problem Determination here:

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/tutorial_conn.d2w/toc

which might help.

Marc

 

[synap1974]

I have run that this problem comes
when we execute a particular procedure and the database goes down

the procedure has

DECLARE sql_statement VARCHAR(5000);

DECLARE rowcount_cursor CURSOR FOR v_stmt1;
DECLARE rate_filter_refcur CURSOR WITH RETURN TO CALLER FOR v_stmt;

PREPARE v_stmt FROM sql_statement;
OPEN rate_filter_refcur

is the clause 'with return to caller' is ommited it works fine but my application will fail..

what could be the problem.....