Previous Topic

Next Topic

Distributed Database Contents Frame

To see all the objects in your distributed database, choose the ListObj operation from the Node Status and Local Database Types frame. The Distributed Database Contents frame is displayed:

All the tables, views and indexes in your distributed database are listed by name, owner and type of object.

Registered indexes will have a name determined by Ingres Star at registration time of the form:

ddx_nnnn_nnnn

For example:

Object Name

Object Owner

Object Type

ddx_1323_1324

$ingres

Index

Note: Ingres Star does not retain any index names created when the index was created in the local database.

You can restrict the objects displayed in this frame by choosing the Criteria menu item. The criteria that control the Distributed Database Contents frame are described below:

When you choose the ListObj operation the first time, the following default criteria for the display of the objects in the distributed database are set:

Field

Default

Show Views

y

Show Tables

y

Show System Catalogs

n

By changing these values, you can restrict or extend the display of the objects in your distributed database. For example, by setting Show Tables to n, no tables are displayed.

To change the defaults, you must select the Criteria operation. A pop-up window is displayed on the DDB Contents frame within which you can amend the criteria fields. For details, see The Criteria Operation.

Previous Topic

Next Topic

DDB Contents Frame Operations

The Distributed Database Contents frame includes the following operations:


© 2007 Ingres Corporation. All rights reserved.