Network issues for 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.

In order 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 the following TCP/IP implementations:

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.

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 option on both the client and the database server command lines. This option may be used with either the start_asiq or the asiqsrv12 command. For more information about server startup options, see the Sybase IQ Utility Guide.