Previous Topic

Next Topic

Createdb Command

You can use the createdb command to create a distributed database as you would a local database, except that you must add /star to the distributed database name.

The createdb command does the following:

For flags and full syntax details of the createdb command, see the Command Reference Guide.

Previous Topic

Next Topic

Examples: Createdb

The following command creates a distributed database named corporateddb:

createdb corporateddb/star

Because a coordinator database name was not specified, the coordinator database name defaults to iicorporateddb. When createdb finishes, there will be a single new database (the coordinator database iicorporateddb) in the Ingres data location. There will be entries in the iidbdb for the distributed database and the coordinator database.

Note: There will not be a physical database for the distributed database, but there will be iidbdb catalog entries associating the coordinator database with the distributed database.

The following command creates a distributed database named corporateddb with a coordinator database named corporate that overrides the automatically generated coordinator database named iicorporateddb:

createdb corporateddb/star corporate

The following command creates a distributed database named corporateddb with a coordinator database named corporate. It assigns the default data location to corp_loc and installs the Ingres/Vision client catalogs so that users can access Vision on the corporateddb distributed database.

createdb -dcorp_loc corporateddb/star corporate -f vision


© 2007 Ingres Corporation. All rights reserved.