Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.3 |  CUBRID 9.0.0 | 

CUBRID Utilities

The CUBRID utilities provide features that can be used to comprehensively manage the CUBRID service. The CUBRID utilities are divided into the service management utility, which is used to manage the CUBRID service process, and the database management utility, which is used to manage the database.

The service management utilities are as follows:

  • Service utility : Operates and manages the master process.
    • cubrid service
  • Server utility : Operates and manages the server process.
    • cubrid server
  • Broker utility : Operates and manages the broker process and application server (CAS) process.
    • cubrid broker
  • Manager utility : Operates and manages the manager server process.
    • cubrid manager
  • HA utility : Operates and manages the HA-related processes.
    • cubrid heartbeat

See Registering Services for details.

The database management utilities are as follows:

  • Creating database, adding volume, and deleting datbase
    • cubrid createdb
    • cubrid addvoldb
    • cubrid deletedb
  • Renaming database, altering host, copying database, and installing database
    • cubrid renamedb
    • cubrid alterdbhost
    • cubrid copydb
    • cubrid installdb
  • Checking and compacting database space
    • cubrid spacedb
    • cubrid compactdb
  • Checking query plan and optimizing database
    • cubrid plandump
    • cubrid optimizedb
    • cubrid statdump
  • Checking database lock, killing transaction, and checking consistency
    • cubrid lockdb
    • cubrid killtran
    • cubrid checkdb
  • Diagnosing database and dumping parameter
    • cubrid diagdb
    • cubrid paramdump
  • Loading and unloading database
    • cubrid loaddb
    • cubrid unloaddb
  • Backing up and restoring database
    • cubrid backupdb
    • cubrid restoredb
  • HA utilities
    • cubrid changemode
    • cubrid copylogdb
    • cubrid applylogdb
    • cubrid applyinfo

See How to Use the CUBRID Management Utilities (Syntax) for details.

The following result is displayed if cubrid is entered in a prompt.

% cubrid

 

cubrid utility, version 2008 R4.1

usage: cubrid <utility-name> [args]

Type 'cubrid <utility-name>' for help on a specific utility.

 

Available service's utilities:

    service

    server

    broker

    manager

    heartbeat

 

Available administrator's utilities:

    addvoldb

    alterdbhost

    backupdb

    checkdb

    compactdb

    copydb

    createdb

    deletedb

    diagdb

    installdb

    killtran

    loaddb

    lockdb

    optimizedb

    plandump

    renamedb

    restoredb

    spacedb

    unloaddb

    paramdump

    statdump

    changemode

    copylogdb

    applylogdb

    applyinfo

 

cubrid is a tool for DBMS.

For additional information, see http://www.cubrid.org

Remark

If you want to control the service by using cubrid utility on Windows Vista or later, it is recommended that you run the command prompt with an administrator account.

If you use cubrid utility without an administrator account, the result message is not displayed even though you can run it through the User Account Control (UAC) dialog.

To run the command prompt on Windows Vista or later with an administrator account, right-click [Start] > [All Programs] > [Accessories] > [Command Prompt] and select [Run as Administrator]. In the dialog verifying authorization, click [Yes]; then the command prompt runs with an administrator account.