Previous Topic

Next Topic

Node Status and Local Database Types Frame

Choosing the Go operation from the StarView main frame displays the Node Status and Local Database (LDB) Types frame.

The Node Status frame also displays first if you specify the name of a distributed database as a parameter when you type starview at the operating system command line.

To connect to another distributed database, you must choose End to call up the main StarView frame and Select another distributed database.

The following figure shows the Node Status and Local Database Types frame:

The Node Status and Local Database Types frame includes the following operations. Note that both SQL and Tables selections connect to the selected distributed database:

Previous Topic

Next Topic

ListObj Operation

The ListObj operation displays the Distributed Database Contents frame, which lists the component objects of the distributed database and the system catalogs:

You can display all or any combination of these objects by altering the default settings.

To learn how to restrict the display of this frame to, for example, tables only, see Distributed Database Contents Frame.

Previous Topic

Next Topic

LDBAttr Operation

The LDBAttr (local database attributes) operation displays the following frame showing the attributes of your selected local database:

The attributes shown include name, date, checkpoints and journaling.

The Accessibility Status field displays one of the following messages:

The Database Service Available field displays either Local Database or Coordinator Database.

Previous Topic

Next Topic

SQL Operation

By choosing the SQL operation, you can use Interactive SQL (ISQL) to query your distributed databases. The following screen is displayed:

For a full explanation of ISQL, see Forms-based Application Development Tools User Guide.

Previous Topic

Next Topic

Tables Operation

By choosing the Tables operation, you can use the forms-based Tables utility to query tables in your distributed databases.

The following screen is displayed:

If you create any tables using the Tables utility, the underlying local tables are created in the Coordinator database.

For a full explanation of the Tables utility, see Forms-based Application Development Tools User Guide.

Previous Topic

Next Topic

TestNode Operation

By choosing the TestNode operation, you can test the node connections within your distributed database. When you test a node, the Status field on the frame changes from a question mark (?) to either up (accessible) or down (not accessible).

You can test the connections to a single node or to all nodes. The following list of options is displayed:

Previous Topic

Next Topic

TestLDB Operation

By choosing the TestLDB operation, you can test the availability of the local databases in your distributed database. When you test a database, the Status field changes from a question mark (?) to either up (accessible) or down (not accessible).

You can test the connections to a single database or to all databases. After testing one database, you can then test another database by choosing NewLDB.

When you choose AllLDBs, StarView goes through each local database and changes the display of the status to either up or down.

The following list of options is displayed:

Previous Topic

Next Topic

TestNode versus TestLDB

TestNode allows you to test whether you can connect to a node. TestLDB allows you to test whether you can connect to a local database.

If you have many local databases and only a few nodes, it is faster to test connections against the nodes rather than test every local database on the node.


© 2007 Ingres Corporation. All rights reserved.