SAND CDBMS Administration Guide
Installing and Configuring SAND CDBMS

 

Previous Topic:
System Configuration for SAND CDBMS Operation (UNIX)
Chapter Index
Next Topic:
Linux System Configuration

 

System Configuration for SAND CDBMS Operation (UNIX)


AIX System Configuration

On AIX systems, the environment variable AIXTHREAD_SCOPE must be set to "P" (process-based contention scope) to allow applications to create threads in the system. For example, add the following command to the appropriate user profile:

export AIXTHREAD_SCOPE=P

Otherwise, errors will be returned from the SAND server indicating thread-creation issues on the system in which it is running.

Note that this is a known issue with some AIX configurations, and is not specific to SAND software.

More details about AIXTHREAD_SCOPE can be found here:

http://publib.boulder.ibm.com/tividd/td/TSMC/GC32-0793-02/en_US/HTML/ansa000043.htm


For optimum SAND CDBMS load performance, the AIX system's tcp_sendspace network parameter should be set to 655360.

To view the current settings, enter the following command:

no -a


To change the current tcp_sendspace value immediately, use the following no command:

no -o tcp_sendspace=655360


This change is temporary, lasting until the next system boot. To make the change permanent, add the following line to the /etc/rc.net file:

/usr/sbin/no -o tcp_sendspace=655360