Previous Topic

Next Topic

Configuration Access Examples

The following examples illustrate various Ingres Star configurations and show:

In the examples that follow, the name of the distributed database is DISTDB.

Previous Topic

Next Topic

Example: Single Node Configuration

The following diagram shows the client and the complete Ingres Star configuration on one node (Node A) and in one installation. The distributed database DISTDB consists of two local databases, DBLOC_A1 and DBLOC_A2, as well as the coordinator database IIDISTDB. As shown in the following diagram, Ingres Star's access to the local databases as well as to its catalog information in the coordinator database is through a local DBMS:

Node A

To invoke the Terminal Monitor on the distributed database, issue the following command at the operating system prompt:

sql distdb/star

To incorporate TABLE1 in database DBLOC_A1 into the distributed database, issue the following statement in an application or an SQL session:

register table table1 as link
  with node = node_a,
  database = dbloc_a1;

When a Ingres Star user requests data from TABLE1, the Star Server passes the request to the local DBMS, which gets the information from DBLOC_A1.

Previous Topic

Next Topic

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;

When an Ingres Star user accesses TABLE2, Ingres Star requires a network connection to DBLOC_B1 to access TABLE2.

Previous Topic

Next Topic

Example: Three Node Configuration

The following diagram shows the client on one node, Node A, the Star Server and the coordinator database on another node, Node B, and a local database, DBLOC_C1, on a third node, Node C:

This configuration requires Net on all three nodes and either:

To invoke the Terminal Monitor on the distributed database, you must supply a node name as follows at the operating system prompt:

sql node_b::distdb/star

To incorporate TABLE3 in database DBLOC_C1 into the distributed database, issue the following statement in an application or an SQL session:

register table table3 as link
  with node = node_c,
  database = dbloc_c1;

When an Ingres Star user accesses TABLE3, Ingres Star requires a network connection to DBLOC_C1 to access TABLE3.


© 2007 Ingres Corporation. All rights reserved.