cm_manual_professional

CUBRID Manager :: For Power Users

12. For Power Users

12.1. Host Group Management

Host groups can make hosts display clearly when where are lots of hosts needed to manage.
 

Hide or Show Groups

Users can choose hide or show the host group by menu as follows:

• Item menu : show host only and hide the group nodes.
• Group menu : show the group nodes.

Open Groups Settings Dialog

Use Group Settings… above to open the group management dialog as follows:

Buttons TopUPDownBottom are responsible to adjust the display order of group.

And buttons Add… Edit… will open a new dialog to add or edit a group.

Add, Edit Group Nodes of Hosts

Button Add will open a new group dialog to let users input the new group's name and children hosts.

Left area of the dialog is a list of current hosts which is not in current group and right area is a list of current group’s children hosts.

Button > will move the selected in the left to right and >> will move all of the left to right;

Button < will move the selected in right to left and << will all of the right to left.

Delete Group

Select a group to be deleted and push the button Delete.

Note: the Default Group can not be deleted and edited, it store the hosts which is not in other groups.

Drag Group

Users can drag several host nodes to another group node or change the display order of host nodes of current group node.

Users can also change the display order of host nodes when group nodes are hidden.

12.2. Configuring Background Operations in Multiple-Host Environment

If you manage databases in several hosts by using Add Host, databases can be configured for background operations. For example, if you want to execute a query to a database in host B while doing backup for a database in host A, the database backup operation, which generally takes a long time, can be configured to be executed as a background operation. The database operations that can be run in the background are as follows:

• Database related : Create Database, Unload/Load Database, Backup/Restore Database, Rename Database, Copy Database, Optimize Database, Compact Database, Check Database
• Table related : Import/Export, Delete All Records, Update data by changing constraints from NULL to NOT NULL
• Volume : Add Volume

12.3. OID Navigator

It is used to search data by OIDs.

You can run the OID Navigator by right-clicking a database or inside the Result pane of the Query editor and then selecting OID Navigator. Note that this function is activated only while the database server is running; this is deactivated while the server is not running.