Maintaining a Distributed Database

This chapter explains various aspects of maintaining a distributed database. It describes the statements and commands for creating, naming, and populating your distributed database.

Previous Topic

Next Topic

Distributed Database Maintenance Tasks

A distributed database can be made up of tables, views, procedures, and indexes in local Ingres databases, remote Ingres databases, and non-Ingres databases accessible through Enterprise Access products.

Database maintenance tasks include:

Previous Topic

Next Topic

VDBA and Distributed Database Maintenance

You can use Visual DBA to maintain a distributed database. Use the Databases branch in the Database Object Manager window.

The following topics in the VDBA online help contain procedures to maintain distributed databases:

Previous Topic

Next Topic

Commands for Performing Distributed Database Maintenance

Distributed databases can also be created and destroyed by the createdb and destroydb commands, which are executed at the operating system level. For more information, see Createdb Command and Destroydb Command.

Previous Topic

Next Topic

Statements for Performing Distributed Database Maintenance

Some tasks can be accomplished using statements, which can be issued from an interactive session with SQL or ISQL, or from an application.

These statements are as follows:

By default, the data definition language (DDL) statements create, drop, register, and remove are all committed immediately, independently of the user's transaction. To learn how to turn off concurrency, see DDL Concurrency Mode.


© 2007 Ingres Corporation. All rights reserved.