Network Issues for Sybase IQ Servers

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

Verified TCP/IP Protocol Stacks

For 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. Sybase IQ communications have been explicitly verified with these TCP/IP implementations:

TCP/IP For NetWare
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 Sybase IQ client application to use Windows TCP/IP. Install TCP/IP Protocol from the Network Settings options on the Control Panel.

User Datagram Protocol

There are several entries into the TCP/IP protocol stack. 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.