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. As all TCP/IP implementations 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 the following TCP/IP implementations.

Using TCP/IP with Windows

Windows NT 3.5 and later ship with TCP/IP software that uses NDIS network drivers. Install TCP/IP Protocol from Control Panel, Network Settings.

This software allows an IQ server for Windows or an IQ client application to use Windows TCP/IP.

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.