====== SQLHOSTS ====== ===== Shared Memory Connections ===== The service name for shm connections is often labelled dummy, this is fine if you are on single instance. But if you are running multiple instances then the name must be unique across all instances. Symptons onstat is 100% dbaccess says the instance is not running onparams runs against the last engine started onspaces runs against a random engine Put it into shared memory servicename in /etc/services anyway, it cannot hurt, and will remind you not to use the same name twice Author: [[useful:whoswho#june hunt|June Hunt]] Non-unique servicenames or servernames. DSA creates files in /INFORMIXTMP for your shmem and tcp connections (I don't know about others), which are named by servicename (for tcp) and servername (for shmem). If these are not unique on the machine, one will overwrite the other. ===== TCP Connections ===== You **must not** use the same service name for the shared memory entry in sqlhosts as you do for **any** other entry for the **same** server. If you do the server will begin polling that service which will spin the CPUs and generate thousands of unneeded system calls per second. You are correct that the service name used for shared memory connections does not need to be in ///etc/services// it is a dummy and can be anything, but must not be the same as that used by another protocol on the same service.