db_create

With this command you can create a new database on a local or remote computer, and create the first DBM operator with all permissions for managing this database. This DBM operator can carry out administrative tasks for the database and create further DBM operators and database users.

At the same time you define the database system administrator.

You can enter options to define, which of the database software versions available on the database computer should be used to create this database, and to determine further properties of this database.

After the new database has been created, the first DBM operator and the database system administrator are initially the only users who can access the database.

You need to complete further steps before you can start working with the newly created database.

Prerequisites

You are logged on as the operating system user to the computer, on which the database is being created (see: user_system).
To create a database on Unix/Linux, you need to be logged on as the operating system user root, or as a member of the sdba operating system user group (see: Special Operating System Users and User Groups (Unix/Linux)).
To create a database on a remote computer on Microsoft Windows, you need to have additional administration rights for the database computer as well as the log on as batch job right.
For information about administering operating system users, see your operating system documentation.
The X Server program has been started.
On Microsoft Windows, the system sets the startup type for X Server to Automatic so that the system starts it automatically when the computer is started.

For Unix systems, start X Server of the remote database computer explicitly to be able to manage a database on this computer (see: Utilities: Starting the Global Listener and/or Installation-Specific X Servers).

Structure

db_create [-a|-auto] [-g <group>] [-u] <database_name> <dbm_user>,<dbm_user_password> [<os_user>,<os_user_password>]

Options
Option	Description
`-a \| -auto`	In Microsoft Windows, the service entry `Start-up-type` for the database service in the control panel is set to `automatic`. In the Unix operating system this parameter is ignored.
`-g <group>`	For Unix only: You assign your database files to an operating system user group other than the standard group and can thus protect the files from unauthorized access.
`-u`	For Microsoft Windows only: Operating system user specification with option `-u` The service for starting the database kernel should run under the operating system user specified at the end of the DBM command.
`<os_user>`	Name of the operating system user for the remote computer To create a database on a remote computer, also specify the operating system user for this computer. If the logon to the operating system fails, the database cannot be installed.
`<os_user_password>`	Password of the operating system user
`<database_name>`	Name of the database Note The database system automatically converts the database name into upper-case letters. See also: Conventions for User Names and Passwords. End of the note.
`<dbm_operator>`	Database Manager operator (DBM operator) Note Pay attention to the conventions for user names and passwords. The database system automatically converts the user name into upper-case letters. End of the note.
`<dbm_operator_password>`	Password of the DBM operator The database system automatically converts the password into upper-case letters.

Result

OK

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, create the local database DEMODB and define the first DBM operator with the user name DBM and the password DBM.

>dbmcli db_create DEMODB DBM,DBM

OK

Call Database Manager CLI, create a local database with the name MAXDB using the software stored under C:\Program Files\SDB\7600, define the DBM operator DBM with the password DBM:

>dbmcli -R "C:\Program Files\SDB\7600" db_create MAXDB DBM,DBM

OK

Log on to Database Manager CLI, create a database with the name TESTDB on the remote copmuter GENUA, define the DBM operator DBM with the password DBM, log on as the operating system user ANNA with the password BLACK to the remote computer: >dbmcli –n GENUA db_create TESTDB DBM,DBM ANNA,BLACK

OK

More Information

Database Administration, Creating Databases