:meta-keywords: coradb administrator, coradb dba, coradb tools, coradb utilities, coradb services, coradb processes, coradb config, coradb troubleshoot, ddl audit
:meta-description: This manual chapter covers everything needed by database administrators how to use coradb utilities, how to monitor coradb systems, how to troubleshoot and how to fix problems.

*****************
CoraDB Management
*****************

This chapter describes how the database administrators (**DBA**) operates the CoraDB system.

*   It includes instructions on how to use the **coradb** utility, which starts and stops various processes of the CoraDB server, the broker, java stored procedure server, and manager server. See :doc:`/admin/control`.

*   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 :doc:`/admin/admin_utils`.

*   It includes instructions on the system configuration. See :doc:`/admin/config`.

*   It includes how to use SystemTap, which can monitors and traces the operating processes dynamically. See :doc:`/admin/systemtap`.
   
*   It includes instructions on troubleshooting. See :doc:`/admin/troubleshoot`.

The **coradb** utilities provide features that can be used to comprehensively manage the CoraDB service. The CoraDB utilities are divided into the service management utility, which is used to manage the CoraDB 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.

    *   :ref:`coradb service <control-coradb-services>`

*   Server utility : Operates and manages the server process.

    *   :ref:`coradb server <control-coradb-server>`

*   Broker utility : Operates and manages the broker process and application server (CAS) process.

    *   :ref:`coradb broker <broker>`

*   Manager utility : Operates and manages the manager server process.

    *   :ref:`coradb manager <coradb-manager-server>`

*   HA utility : Operates and manages the HA-related processes.

    *   :ref:`coradb heartbeat <coradb-heartbeat>`

*   Java SP Server utility : Operates and manages the process of the Java stored procedure (Java SP) server.

    *   :ref:`coradb javasp <coradb-javasp-server>`

See :ref:`control-coradb-processes` for details.

The database management utilities are as follows:

*   Creating database, adding volume, and deleting database

    *   :ref:`coradb createdb <createdb>`
    *   :ref:`coradb addvoldb <addvoldb>`
    *   :ref:`coradb deletedb <deletedb>`

*   Renaming database, altering host, copying/moving database, and registering database

    *   :ref:`coradb renamedb <renamedb>`
    *   :ref:`coradb alterdbhost <alterdbhost>`
    *   :ref:`coradb copydb <copydb>`
    *   :ref:`coradb installdb <installdb>`

*   Backing up database

    *   :ref:`coradb backupdb <backupdb>`

*   Restoring database

    *   :ref:`coradb restoredb <restoredb>`

*   Unloading and Loading database

    *   :ref:`coradb unloaddb <unloaddb>`
    *   :ref:`coradb loaddb <loaddb>`
    
*   Checking and compacting database space

    *   :ref:`coradb spacedb <spacedb>`
    *   :ref:`coradb compactdb <compactdb>`

*   Updating statistics and checking query plan

    *   :ref:`coradb plandump <plandump>`
    *   :ref:`coradb optimizedb <optimizedb>`
    *   :ref:`coradb statdump <statdump>`

*   Checking database lock, checking transaction and killing transaction

    *   :ref:`coradb lockdb <lockdb>`
    *   :ref:`coradb tranlist <tranlist>`
    *   :ref:`coradb killtran <killtran>`

*   Diagnosing database and dumping parameter

    *   :ref:`coradb checkdb <checkdb>`
    *   :ref:`coradb diagdb <diagdb>`
    *   :ref:`coradb paramdump <paramdump>`

*   Changing HA mode, replicating/applying logs 

    *   :ref:`coradb changemode <coradb-changemode>`
    *   :ref:`coradb applyinfo <coradb-applyinfo>`

*   Compiling/Outputting locale

    *   :ref:`coradb genlocale <locale-command>`
    *   :ref:`coradb dumplocale <dumplocale>`

See :ref:`coradb-utilities` for details.

.. _utility-on-windows:

.. note::

    If you want to control the service by using **coradb** utility on Windows Vista or later, it is recommended that you run the command prompt with an administrator account. If you use **coradb** 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.

.. toctree::
    :maxdepth: 3

    control.rst
    db_manage.rst
    admin_utils.rst
    config.rst
    systemtap.rst
    troubleshoot.rst
    ddl_audit.rst