Creating a Database

To create a database, first create at least one archive for the database. For more information, see Creating an Archive.

The nuocmd create database command is used to create a database in the durable domain.

For example:

nuocmd create database --db-name test \
   --dba-user dba --dba-password goalie \
   --te-server-ids nuoadmin1 --default-options ping-timeout 60 mem 3g

STARTING: StartProcessRequest(archive_id=0, db_name=test, engine_type=SM, labels={}, options={}, server_id=nuoadmin1)
STARTING: StartProcessRequest(db_name=test, engine_type=TE, labels={}, options={}, server_id=nuoadmin1)

A database with the specified name, test, is created. A TE is started on the server with the specified server ID, nuoadmin1. An SM is started on the existing archive.

The nuocmd create database command implicitly starts an SM on each archive object in the domain state. To prevent this use, --capture-file startplan.json.

Verifying the Created Database

Use nuocmd show domain to confirm that the database is running and that the SM and TE processes have started.

nuocmd show domain

server version: 8.0-4-ed35fd6c37, server license: Enterprise
server time: 2026-06-25T15:51:26.497, client token: fcd24513be16a8aa79c960b0dc00ed74e90045aa
Servers:
  [nuoadmin1] nuoadmin1:48005 [last_ack = 0.43] ACTIVE (LEADER, Leader=nuoadmin1, log=0/16/16) Connected *
Databases:
  test [state = RUNNING]
    [SM] nuoadmin1:48007 [start_id = 0] [server_id = nuoadmin1] [pid = 175] [node_id = 0] [last_ack =  3.13] MONITORED:RUNNING
    [TE] nuoadmin1:48006 [start_id = 1] [server_id = nuoadmin1] [pid = 179] [node_id = 1] [last_ack =  1.80] MONITORED:RUNNING