Start Process

This is a NuoDB Manager command. See NuoDB Manager.

Description

Start a Transaction Engine (TE), Storage Manager (SM) or a Snapshot Storage Manager (SSM).

When using the Start Process command in creating a new database, remember to use the "initialize true" argument as shown in the Syntax.

Preview: Snapshot Storage Manager is a preview feature.

NuoDB encourages you to use preview features in your development projects. The use of preview features in production is not supported.

When starting an SM or an SSM, you must specify an archive directory. The default behavior is that the archive directory is not initialized (initialize is set to false). For example, you can specify the archive directory that is the result of a nuodbmgr restore database command.

Use single quotation marks (') to specify multiple arguments on the command line with the options parameter. Use --command syntax to execute more than one start process te command in one operation. Separate commands with a semi-colon. See Database Options.

Note: An agent does not start a process before the agent has completed a full cycle of the engine-reconnect time period (which is 10 seconds). If a process is started before this period expires, and there are local database processes on the agent, the following error is thrown:

Failed to start process: ProcessBarrier[DSMResync] on [All] not ready error is generated.

Syntax

start process sm 
    host host_name[:port] 
    database database_name
    archive archive_dir
    [ initialize { true | false } ] 
    [ options option_list ]
   
start process ssm 
    host host_name[:port] 
    database database_name
    archive archive_dir
    [ snapshotArchive snapshot_dir ]
    [ initialize { true | false } ]
    [ options option_list ]
 
start process te 
    host host_name[:port] 
    database database_name 
    [ options option_list]

Parameters

Interactive Example

When you create a database, remember to first start the SM and then the TE.

Scripting Example

The same start process commands can be executed with --command as follows:

nuodbmgr --broker host --password password \
    --command "start process sm \
    database test \
    host localhost \
    archive /tmp/nuodb1 \
    initialize true"nuodbmgr --broker host --password password \
    --command "start process te \
    database test \
    host localhost \
    options '--dba-user dba --dba-password goalie'"

The next example, database test was shutdown and it has a user called dba and the password for that user is 'password' these commands will start the SM without initialize the archives and will change the user's password to 'newpassword'

nuodbmgr --broker host --password password \
    --command "start process sm \
     database test host localhost \
     archive '/var/opt/nuodb/production-archives/test' \
     initialize false"nuodbmgr --broker host --password password \
    --command "start process te \
    database test \ 
    host localhost \ 
    options '--dba-user dba --dba-password newpassword'"