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:

• ListObj

  Lists the objects in the selected distributed database.

• LDBAttr

  Lists the attributes of the selected local database.

• TestNode

  Tests whether you can connect to a node. You can test the accessibility status of a single node or all nodes.

• TestLDB

  Tests whether you can connect to a local database. You can test connections to a single database or all databases in the distributed database.

• SQL

  Accesses Interactive SQL (ISQL). You can enter and execute SQL statements at the interactive Terminal Monitor.

• Tables

  Accesses the Tables utility. You can access, create, destroy, and query all the tables in the distributed database using the forms-based Tables utility.

• Top, Bottom, Find, Help, End

  Standard menu operations.

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.

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:

• Database is marked operational
• Database is being destroyed
• Database is being created

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

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.

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.

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:

• SingleNode

  Test a single node

• AllNodes

  Test all the nodes in the distributed database

• Help and End

  Standard menu operations

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:

• SingleLDB

  Test a single local database

• AllLDBs

  Test all the local databases in the distributed database

• NewLDB

  Test a new local database

• Help and End

  Standard menu operations

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.