createdb Command--Create a Database

The createdb command creates a new database. The user who creates a database becomes the DBA for that database.

By default, all users have access to a database although access to tables in the database must be explicitly granted. To create a private database, use the -p flag.

By default createdb creates a Unicode-enabled database with Normalization Form C, with VECTORWISE storage structure.

Before you can specify file locations in the createdb command, the directories must exist. If not specified, a default location, created during installation, is assumed.

Note: If createdb fails for any reason, destroy the partially created database using the destroydb command.

createdb dbname [-dlocationname] [-clocationname]
[-jlocationname] [-blocationname] [-wlocationname]
[-i] [-n][-p] [-S] [-uusername] [-Ppassword]
[-rlocationname]

Specifies the name of the database to be created. The name must be unique and begin with an alphabetic character. The name can have a maximum of 24 alphanumeric characters (the underscore is also allowed).

Specifies the location of the database files. The default is the location to which II_DATABASE points.

Specifies the location of the checkpoint files. The default is the location to which II_CHECKPOINT points.

Specifies the location of the journal files. The default is the location to which II_JOURNAL points.

Specifies the location of the dump files. The default is the location to which II_DUMP points.

Specifies the location of the work files. The default is the location to which II_WORK points.

Note: Createdb uses the –i flag by default. You do not have to specify it unless you want to specify a collation name.

Creates a Unicode-enabled database using Normalization Form C (NFC). This enables storing and manipulating Unicode data by defining columns as Unicode data types (that is, nchar, nvarchar, and long nvarchar). The database uses NFC for normalization of Unicode strings for processing and storage. NFC results from the canonical decomposition of a Unicode string, followed by the replacement of all decomposed sequences by primary composites, where possible.

Creates a Unicode-enabled database using Normalization Form D (NFD). This enables storing and manipulating Unicode data by defining columns as Unicode data types (that is, nchar, nvarchar, and long nvarchar). The database uses NFD for normalization of Unicode strings for processing and storage. NFD results from the canonical decomposition of a Unicode string.

Creates a private database. Only the DBA and names specified on the accessdb command have access to the database.

Creates an iidbdb. You must be a privileged user to use this flag.

Specifies the effective user for the session, as described in Standard Flags and Parameters.

Specifies the user password for the database.

Specifies the new location of the read-only database; typically this will be the drive where the read-only database is located.