Properly configured Sybase IQ UNIX servers run under the TCP/IP protocol, which enables non–UNIX clients to communicate with a UNIX database server.
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
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 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.
For more information about server startup switches, see the Utility Guide. For more information about connection parameters, see the Sybase IQ System Administration Guide.
