This chapter describes how the database administrators (DBA) operates the CUBRID system.
- It includes instructions on how to use the cubrid utility, which starts and stops various processes of the CUBRID server, the broker and manager server. See Controlling CUBRID Processes.
- It 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. See cubrid Utilities.
- It includes instructions on the system configuration. See System Parameters.
- It includes how to use SystemTap, which can monitors and traces the operating processes dynamically. See SystemTap.
- It includes instructions on troubleshooting. See Troubleshooting.
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.
- Server utility : Operates and manages the server process.
- Broker utility : Operates and manages the broker process and application server (CAS) process.
- Manager utility : Operates and manages the manager server process.
- HA utility : Operates and manages the HA-related processes.
See Controlling CUBRID Processes for details.
The database management utilities are as follows:
- Creating database, adding volume, and deleting database
- Renaming database, altering host, copying/moving database, and registering database
- Backing up database
- Restoring database
- Unloading and Loading database
- Checking and compacting database space
- Updating statistics and checking query plan
- Checking database lock, checking transaction and killing transaction
- Diagnosing database and dumping parameter
- Changing HA mode, replicating/applying logs
- Compiling/Outputting locale
See cubrid Utilities for details.
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.
- Controlling CUBRID Processes
- CUBRID Services
- Database Server
- CUBRID Manager Server
- Database Management
- cubrid Utilities
- cubrid Utility Logging
- HA Commands
- Locale Commands
- Timezone Commands
- System Parameters
- Configuring the Database Server
- Scope of Database Server Configuration
- Changing Database Server Configuration
- cubrid.conf Configuration File and Default Parameters
- Connection-Related Parameters
- Memory-Related Parameters
- Disk-Related Parameters
- Error Message-Related Parameters
- Concurrency/Lock-Related Parameters
- Logging-Related Parameters
- Transaction Processing-Related Parameters
- Statement/Type-Related Parameters
- Thread-Related Parameters
- Timezone Parameter
- Query Plan Cache-Related Parameters
- Utility-Related Parameters
- HA-Related Parameters
- Other Parameters
- Broker Configuration
- HA Configuration
- Configuring the Database Server
- Installing SystemTap
- Related Terms
- Using SystemTap in CUBRID
- CUBRID markers
- Checking SQL Log
- Server Error Log
- Detecting the change of HA status
- Failure on HA Start