Using Sybase IQ with TCP/IP

Because different TCP/IP implementations rely on particular data link drivers to work correctly, Sybase IQ supports only certain TCP/IP implementations on each platform. For details, see the subsections below for each platform. All implementations described in this document do implement the same protocol suite, they are all compatible.

User Datagram Protocol

There are several entries into the TCP/IP protocol stack. IQ employs the User Datagram Protocol (UDP). Although 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.

Verified TCP/IP protocol stacks

Many vendors supply TCP/IP protocol stacks and associated software. IQ communications have been explicitly verified with Microsoft Winsock version 2.0.

Using TCP/IP with Windows

Windows NT 3.5 and later ship with TCP/IP software that uses NDIS network drivers. This software allows an IQ server for Windows or an IQ client application to use Windows TCP/IP. Install TCP/IP Protocol from the Network Settings options on the Control Panel.

Tuning Sybase IQ performance under TCP/IP

Although the default packet size for TCP/IP is 512 bytes, a larger packet size may improve query response time, especially for queries transferring a large amount of data between a client and a server process. You can set the packet size using the -p parameter on both the IQ client and the database server command lines.