on 10-28-2015 4:59 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.