To support both local and remote access to the database server, the ccmsrv create command creates the following two database server entries in the $CCM_HOME/informix/etc/sqlhosts file:
dbservername nettype hostname dbservername
dbservername_net nettype hostname servicename
The first type of entry is for a local connection (for example, a local connection for an engine and a database server in the same machine). The second type of entry is for a remote (_net) connection through sockets using TCP/IP (for example, for a network connection to an engine on a remote machine).
For example, marathon is connected as marathon using a shared memory protocol (onipcshm), and as marathon_net using a Solaris TCP protocol (ontlitcp):
marathon onipcshm marathon marathon
marathon_net ontlitcp marathon marathon_marathon
The fourth column contains the database server name for local connections, and the service name (as defined in the services file) for network connections.
The following table shows the protocols (nettypes) for the supported Rational® Synergy platforms.
Platform | Local | Remote (Sockets) |
---|---|---|
Solaris | onipcshm | ontlitcp |
AIX® | onipcshm | onsoctcp |
Linux | onipcshm | onsoctcp |
To add machines and protocols to the sqlhosts files for UNIX: