Network Issues for SAP Sybase IQ Servers

Properly configured UNIX servers run under the TCP/IP protocol, which enables non–UNIX clients to communicate with the server.

Verified TCP/IP Protocol Stacks

For SAP Sybase IQ to run properly, the protocol stack on the client and server computers must be compatible at each layer. Many vendors supply TCP/IP protocol stacks and associated software. SAP Sybase IQ communications have been explicitly verified with these TCP/IP implementations:

TCP/IP For NetWare
Microsoft Winsock version 2.0

User Datagram Protocol

There are several entries into the TCP/IP protocol stack. SAP Sybase IQ employs the User Datagram Protocol (UDP). While it is called a transport protocol here and elsewhere, UDP provides little more than a user interface to the network layer IP. In particular, UDP is not a guaranteed transmission protocol.

Tuning Performance Under TCP/IP

Although the default packet size for TCP/IP is 1460 bytes, a larger packet size may improve query response time, especially for queries that transfer a large amount of data between a client and a server process. You can set the maximum packet size using the database server command lines or CommBufferSize (CBSIZE) in the client connection string. This option may be used with the start_iq command.