Sybase IQ uses shared memory for two purposes:
When the client and Sybase IQ are on the same system, shared memory is the default communication mechanism, not TCP/IP.
When you specify the server command-line option -iqwmem, shared memory is used to provide wired memory.
If the -iqwmem option is used, you need to increase the maximum shared memory segment size parameter in the /etc/system configuration file. Sybase recommends that you specify a configuration for the largest amount of wired memory you expect your system to support.
For example, you could create a shared segment to support a maximum physical memory of 3350MB for your system by adding the following line to the /etc/system file:
set shmsys:shminfo_shmmax=0xffffffff
Never set shmmax to a value greater than 7/8 of physical memory.
Local connections through shared memory are not supported for Sun Solaris x64 systems. Use standard network connectivity by adding the parameters -host <hostname> and -port <portnumber> to the client connection string.
See the Sybase IQ System Administration Guide for more information on using the -host and -port parameters.
