IBM Support

How to Restrict remote connections accessing Informix IDS

Technote (FAQ)


How to restrict remote connections to a Informix Instance but still allow the same users to access the database server locally.


Configure the Informix dbserver to use shared memory connections only. This will allow access by a local user, but that same user will not be able to access the database from another host, or client, workstation, etc using a network access.

The following example shows a sqlhosts entry for a shared memory connection

#dbservername nettype hostname servicename options
 mydbsvr     onipcshm   myhostname     mydbsvr

Document information

More support for: Informix Servers

Software version: 11.5, 11.7, 11.70, 12.1

Operating system(s): AIX, DYNIX/ptx, HP-UX, IRIX, Linux, Platform Independent, Reliant UNIX, Solaris

Reference #: 1634667

Modified date: 17 April 2013

Translate this page: