Skip to Content
avatar image
Former Member

Any known issues connecting between Linux Redhat and IQ16 on Windows?

Hi, I am trying to help troubleshoot an issue our developers are having with connection between Linux Redhat servers and IQ16 on Windows. They are running many jobs written in C and some of them are consistently failing with the connections terminating. They are receiving errors Operating-system error (29), DB-Library error(20004) and Net-Library operation terminated due to disconnect.

They say the error occurs when they execute dbcancel function in the C code.

Any thoughts?

Thank you,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 21, 2015 at 12:03 AM

    Hi

    Here are short description of this error from Manual.

    When error is shown, any other messages in iqmsg or sqltrace file?

    --------------------------------------------------------------------

    Appendix B: DB-Library Error Messages

    20004

    Symbolic constant

    - SYBEREAD

    Message text

    - Read from the server failed.

    Possible cause

    - Internal I/O error

    Action/solution

    - Contact Sybase Technical Support.

    Additional information

    Versions

    - All

    ----------------------------------------------------------------------

    If you want to get more detail information, you need to add the following switch for debugging purpose.


    This switch "-z" displays diagnostic communication messages, and other messages, for troubleshooting purposes. Information is logged to standard output in the srvlog file.


    Here are steps to test.


    1. specify the following switch in cfg file (need to restart IQ)

        -z  //display debugging information

        -zr ALL or SQL //Enables request-level logging of operations.


    2. Run program again


    3. TDS debugging information is shown in srvlog


    [Caution]


    - This should only be used when tracking problems.

    - SUPPRESS_TDS_DEBUGGING restricts the debugging information about TDS that appears in the server window.


    ==

    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Chris Baker

      Hello, yes these jobs are mostly using DB-LIB. According to the job owner switching to CT-LIB would be a 'massive undertaking'. They worked with IQ15.2, and are not working with IQ16. So are there known issues with DB-LIB and IQ16?

      Thank you