Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: [IBM][CLI Driver][DB2/LINUX] SQL30081N

    hi
    we access the db2 stored procedures (sql) using type 2 driver. If the db2 server is on windows, the procedures execute normally but when we installed the server on linux, on some procedures we get the following error.

    [IBM][CLI Driver][DB2/LINUX] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "0.168.5.51". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001


    The db2 server terminates on the invocation of the stored procedure. This is also the case when we invoke the procedure from the stored procedure builder.

    any help?

    thanks
    harjan

  2. #2
    Join Date
    Jul 2002
    Posts
    3
    hi again

    was trying out different things..and managed to get it working..

    installed fix pack 7 and it works

  3. #3
    Join Date
    Jan 2003
    Posts
    3

    Re: [IBM][CLI Driver][DB2/LINUX] SQL30081N

    Hi ,
    Did you got the solutions for this prorblem ? if u got may i know the sollution. I have same problem....

    Thanks





    Originally posted by harjan
    hi
    we access the db2 stored procedures (sql) using type 2 driver. If the db2 server is on windows, the procedures execute normally but when we installed the server on linux, on some procedures we get the following error.

    [IBM][CLI Driver][DB2/LINUX] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "0.168.5.51". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001


    The db2 server terminates on the invocation of the stored procedure. This is also the case when we invoke the procedure from the stored procedure builder.

    any help?

    thanks
    harjan

  4. #4
    Join Date
    Jan 2003
    Posts
    3

    Re: [IBM][CLI Driver][DB2/LINUX] SQL30081N

    Originally posted by t_simha
    Hi ,
    Did you find the solutions for this prorblem ?
    We are also facing same problem...
    We already installed fix pack 7 and still getting this problem....

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •