DBSERVERALIASES Configuration Parameter

The DBSERVERALIASES parameter lets you assign additional dbservernames to the same database server. Figure 14 shows entries in an ONCONFIG configuration file that assign three dbservernames to the same database server instance.

DBSERVERNAME          sockets_srvr
DBSERVERALIASES       ipx_srvr,shm_srvr

The sqlhosts entries associated with the dbservernames from Figure 14 could include those shown in Figure 15. Because each dbservername has a corresponding entry in the sqlhosts file, you can associate multiple connection types with one database server.

shm_srvr         onipcshm     my_host            my_shm
sockets_srvr     onsoctcp     my_host            port1
ipx_srvr         ontlispx     nw_file_server     ipx_srvr

Using the sqlhosts file shown in Figure 15, a client application uses the following statement to connect to the database server using shared-memory communication:

CONNECT TO '@shm_srvr'

A client application can initiate a TCP/IP sockets connection to the same database server using the following statement:

CONNECT TO '@sockets_srvr'