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.
The following command creates a distributed database named corporateddb:
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