Accessing multiple database servers

When more than one database server is active on a single computer, it is known as multiple residency.

The following figure shows a configuration with two database servers on host river.
Figure 1. Multiple database servers on UNIX
In this figure, a client application and the river_shm database server communicate with each other through shared memory. The same client application and a database server named river_soc are connected through a TCP/IP programming interface. The following text contains more information.

For the configuration in previous example, you must prepare an onconfig file for database server A and another one for database server B. The sqlhosts file includes the connectivity information for both database servers.

The onconfig file for database server A includes the following line:
DBSERVERNAME            riverA_shm
The onconfig file for database server B includes the following line:
DBSERVERNAME riverB_soc

Copyright© 2019 HCL Technologies Limited