You create a new database instance on a local or remote computer and create the first Database Manager operator with all authorizations for managing this database instance. The operator can carry out administrative tasks for the database instance and create further Database Manager 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.
See also:
Database Administration Tutorial, Creating and
Configuring a Database Instance
Concepts of the Database System, Creating and
Configuring a Database Instance
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)).
The X Server has
been started.
If the database software has been installed under Microsoft Windows, the
system sets the Startup Type for the X Server to Automatic, so it is automatically started by the system when
the computer is started. Under UNIX, you need to explicitly start the X Server
of the remote database computer to be able to administer a database instance
on this computer (see: Utilities documentation: Starting the
X-Server).
db_create [-a|-auto] [-g <group>] [-u] <database_name> <dbm_user>,<dbm_user_password> [<os_user>,<os_user_password>]
Options
Option |
Description |
-a | -auto |
Under Microsoft Windows the service entry Start-up-type for the database service in the Control Panel is set to automatic. Under 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 the 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 the |
<dbm_operator> |
Database Manager Operator (DBM Operator) See |
<dbm_operator_password> |
Password of the Database Manager operator. The database system automatically converts the password into upper-case letters. |
OK
In the event of errors, see Reply Format.
Call the Database
Manager CLI, create a local database instance with the name DEMODB, define the first Database Manager operator with the
name DBM and password 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
>
Call the Database
Manager CLI, create a database instance with the name DEMODB on the remote server GENUA, define the DBM operator DBM with the password DBM, log on as operating system user ANNA with the password BLACK to the remote server:
>dbmcli –n GENUA
db_create DEMODB DBM,DBM ANNA,BLACK
OK
>