db_create

You create a new database instance on a local or remote computer and create the first DBM operator with all authorizations for managing this database instance. The operator can carry out administrative tasks for the database instance 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 versions of database software available on the database computer should be used to create this database instance, and to determine further properties of this database instance.

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

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

Prerequisites

You are logged on as the operating system user to the computer on which the database instance is being created (see: user_system).
To create a database instance on Unix/Linux, you must be logged on as 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 instance 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 administrating operating system users, see your operating system documentation.
The X Server has been started. If the database software has been installed on Microsoft Windows, the system sets the startup type for the X Server to Automatic so that the system starts it automatically when the computer is started. For Unix systems, you have to start the X Server of the remote database computer explicitly to be able to manage a database instance on this computer (see: DocumentationUtilities: Starting the X Server).

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 is set to `automatic` in the `Control-Panel`. 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`	Operating system user specification with option `-u` (only for Microsoft Windows): 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 If you want to create a database instance on a remote server, you must also specify the operating system user for this server. If the logon to the operating system fails, the database instance cannot be installed.
`<os_user_password>`	Password of the operating system user
`<database_name>`	Name of the database instance Note See Conventions for User Names and Passwords. The database system automatically converts the database name into upper-case letters. 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 Database Manager operator The database system automatically converts the password into upper-case letters.

Result

OK

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI, create the new database instance DEMODB and define the first DBM operator with user name DBM

>dbmcli db_create DEMODB DBM,DBM

OK

Call the Database Manager CLI, create a local database instance with the name DEMODB 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 DEMODB DBM,DBM

OK

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

OK

More Information

Database Administration, Creating and Configuring a Database Instance

Database Administration, Creating Databases