Remove Database ArchiveLocation

This is a NuoDB Manager command. See NuoDB Manager.

Description

Remove an archive location from the durable domain configuration.

Syntax

remove database archiveLocation 
    dbname database_name
    host host_name 
    path path_name 

Parameters

Interactive Example

Show the current database configuration for database test:

nuodb [domain] > show database config 
Database: test 
Database: test, ACTIVE, Status=RUNNING, template [Single Host] 
Variables: {HOST=6e0fc183-988c-4a54-8309-d4ea3e5dc5d2, REGION=us-east-1} 
Options: {} 
Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
Archive Locations: 
ec2-54-165-58-157.compute-1.amazonaws.com/172.31.46.122:48004, requirements: SMs, region: us-east-1: 
archive: /var/opt/nuodb/production-archives/test 
journal-dir: /var/opt/nuodb/production-archives/test_journal 
Single Host MET

Remove the archive pathname /var/opt/nuodb/production-archives/test.

nuodb [domain] > remove database archiveLocation 
Database Name: test 
Host or AgentId: 6e0fc183-988c-4a54-8309-d4ea3e5dc5d2 
Archive Pathname: /var/opt/nuodb/production-archives/test
nuodb [domain] > show database config 
Database: test
Database: test, INACTIVE, Status=STOPPED, template [Single Host] 
Variables: {HOST=6e0fc183-988c-4a54-8309-d4ea3e5dc5d2, REGION=us-east-1} 
Options: {} 
Archive Locations: 
Single Host UNMET

Scripting Example

The same command command can be executed with --command as follows:

nuodbmgr --broker host --password password \
    --command "remove database archiveLocation  \
    dbname test host 6e0fc183-988c-4a54-8309-d4ea3e5dc5d2 \
    path /var/opt/nuodb/production-archives/test"