This chapter explains various aspects of maintaining a distributed database. It describes the statements and commands for creating, naming, and populating your distributed database.
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:
Note: You are not limited in the number of databases that you can create. You can create as many databases as your operating system allows.
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:
Note: To create a database, you need the createdb privilege. This subject privilege is granted by default to the system administrator, who in turn can grant it to other users, such as database administrators, who need to create databases. For more information on subject privileges, see the Database Administrator Guide.
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.
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.