The "Administrator's Guide" provides the database administrators (DBA) with details on how to operate the CUBRID system. The guide includes instructions on the following: database management tasks (creating and deleting databases, adding volume, etc.), migration tasks (moving database to a different location or making changes so that it fits the system's version), and making back-ups and rollbacks of the database in case of failures.
It also includes instructions on how to use the cubrid utility, which starts and stops various processes of the CUBRID server, the broker and manager server.
This chapter contains the following:
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:
See Controlling CUBRID Processes for details.
The database management utilities are as follows:
See cubrid Management Utilities for details.
The following result is displayed if cubrid is entered in a prompt.
% cubrid cubrid utility, version 9.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 tranlist killtran loaddb lockdb optimizedb plandump renamedb restoredb spacedb unloaddb paramdump statdump changemode copylogdb applylogdb applyinfo genlocale dumplocale synccolldb cubrid is a tool for DBMS.
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], and then the command prompt is run as an administrator account.