4. Maintaining a Distributed Database : Createdb Command : Examples: Createdb
 
Share this page                  
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