Using Sybase IQ with TCP/IP

TCP/IP is a suite of protocols originally implemented by the University of California at Berkeley for BSD UNIX. TCP/IP is gaining widespread use with the expansion of the Internet and the World Wide Web. Different TCP/IP implementations rely on particular data link drivers to work correctly. For example, TCP/IP for OS/2 relies on NDIS drivers as the data link protocol, whereas TCP/IP for NetWare relies on ODI drivers for correct operation.

The TCP/IP protocol is not associated with any specific software vendor. There are many implementations of TCP/IP available from different vendors, and many different programming interfaces to TCP. Consequently, 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.