Skip to Content
avatar image
Former Member

Sybase IQ 16 :Connection was terminated

Hi experts , we have some load process to sybase iq 16(using SAP Data Services) , but sometimes , not always, some process show the message:

SQL submitted to database <RDE> resulted in error <[Sybase][ODBC Driver][Sybase IQ]Connection was terminated>. The SQL

  submitted is <our sql statement>.

Is there any way to audit connection problems? i searched the iqmsg file but it shows nothing about this error, are there any parameters that i have to set in order to be able to have multiple connections running for a long time?

Thank you so much!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 04:19 AM

    Hi,

    You can get more details using -z switch as follows.


    Here are steps :


    1. specify the following switch in cfg file

        -z  //display debugging information

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


    2. TDS debugging information is shown in srvlog


    This switch "-z" displays diagnostic communication messages, and other messages, for troubleshooting purposes.

    Information is logged to standard output in the srvlog file.


    **Example


    [srvlog]

    I. 06/01 10:11:42. Trying to start SharedMemory link ...

    I. 06/01 10:11:42.     SharedMemory link started successfully

    I. 06/01 10:11:42. Trying to start TCPIP link ...

    I. 06/01 10:11:42. Could not bind to address (::):4444

    I. 06/01 10:11:42. TCPIP communication link not started

    I. 06/01 10:11:42. Unable to initialize requested communication links

    E. 06/01 10:11:42. Unable to initialize requested communication links

    I. 06/01 10:11:42. Database server shutdown due to startup error


    ==

    Gi-Sung Jang


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 04:19 PM

    There are a few issues with SAP DS working with IQ v16.  Make sure you're using IQ v16.0 SP8 PL35+ and DS 4.2 SP4+

    jason

    Add comment
    10|10000 characters needed characters exceeded