Sybase IQ 16 :Connection was terminated

[Former Member]

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!

[Gisung · Accepted solution]

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

[Former Member]

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