Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

CUBRID Utilities

The CUBRID utilities provide features that can be used to comprehensively manage the CUBRID service. 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 utility is 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 an;d manages the HA related process.
    • cubrid_heartbeat

See Registering Services for details.

The database management utility is as follows:

  • Database create/add volume/delete utility
    • cubrid createdb
    • cubrid addvoldb
    • cubrid deletedb
  • Database rename/alter host/copy/install utility
    • cubrid renamedb
    • cubrid alterdbhost
    • cubrid copydb
    • cubrid installdb
  • Database space check/space compaction utility
    • cubrid spacedb
    • cubrid compactdb
  • Database query plan check/optimization utility
    • cubrid plandump
    • cubrid optimizedb
    • cubrid statdump
  • Database lock check/transaction kill/consistency check utility
    • cubrid lockdb
    • cubrid killtran
    • cubrid checkdb
  • Database diagnostics utility
    • cubrid diagdb
    • cubrid paramdump
  • Database loading Utilities
    • cubrid loaddb
    • cubrid unloaddb
  • Database backup/restore utility
    • 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 information will be displayed upon entering cubrid in the prompt.

% cubrid

 

cubrid utility, version R4.0

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.com

Remark

If you want to control the service using Cubrid utilities in Windows Vista and the later versions of Windows, you are recommended to open the command prompt window as an administrator.

If you do not use the command prompt window as an administrator to use Cubrid utilities, you can execute it through UAC (User Account Control) dialog, but cannot check the result message.

To open the command prompt window in Windows Vista and the later versions of Windows as an administrator, right-click [Start] > [All Programs] > [Accessories] > [Command Prompt] to select [Run as Administrator]. When the dialog box to check the elevation of rights pops up, click [Yes] to open the Command Prompt as an administrator.