Example: Two Node Configuration
In the following diagram, the client and the Star Server are on the same node, Node A. One of the databases, DBLOC_A1, resides on Node A and the other database, DBLOC_B1, is on the remote Node B. The coordinator database resides, as always, on the same node as the Star Server:
The configuration requires Ingres Net to be installed on Node A and Node B. In addition, Ingres Star users on Node A must have access to an account on Node B and must have supplied Ingres Net with the account information using the Net utility netutil or must have entered the installation password to Node B on Node A with netutil. (For further information on netutil requirements in a distributed environment, see the System Administrator Guide.)
To invoke the Terminal Monitor on the distributed database, issue the following command at the operating system prompt:
sql distdb/star
To incorporate TABLE2 in database DBLOC_B1 into the distributed database, issue the following statement in an application or an SQL session:
register table table2 as link
with node = node_b,
database = dbloc_b1;
with node = node_b,
database = dbloc_b1;
When an Ingres Star user accesses TABLE2, Ingres Star requires a network connection to DBLOC_B1 to access TABLE2.
Last modified date: 11/09/2022