CUBRID Manager Configuration

11.1. Database Settings

Selected Target Database - Display server/client parameters information

Displays information on the parameters used in the database. You can check the items to be displayed when the cubrid paramdump utility is running in the Manager.

For more information about this utility, see "Outputting Parameters Used in Server/Client."

If you select Display server/client parameters information option, you can check all parameter values applied to the server and the client.

If you deselect the option, you can check only the parameter values applied to the server.

Selected Target Database - Query Plan Cache Information

Displays information on the query plan saved in the cache of the database server. You can check the items to be displayed when the cubrid plandump utility is running in the Manager. For more information about the utility, see "Checking the Query Plan Cache."

Since this feature can only be performed when the database server is running, the Query Plan Cache Information menu is activated only when the database server is running.

If you select the Delete query plans saved in the cache option, the collected database query plan cache information is displayed before it is initialized.

11.2. Query Editor Options

File > Preferences > Query options

Sets the basic information about the currently used CUBRID Manager. Provides the same items as the host setting.

Host > Properties > Query

In the Query dialog box, you can set the following options:

• Autocommit : You can set a default value so that autocommit is performed after a query is executed in the query edit pane. Even when Autocommit is selected, you can set/clear the function from the toolbar in the Query Editor.
• Search unit of result instances : Sets the number of result rows to be fetched at once from the database after the execution of the query. That is, if the number of search result rows is 7,000 when the value is set to 5,000, you can select whether or not to continue to fetch more search results after 5,000 rows are fetched. In addition, if you execute queries that satisfy the following conditions, ROWNUM is automatically added based on the set value to prevent using excessive server resources.
• • WHERE condition is missing.
  • GROUP BY is not used.
  • ORDER BY is not used.
  • Aggregate functions (SUM, COUNT, MIN, MAX, AVG, STDDEV and VARIANCE) are not used.  
  • Hierarchical Query is not used.
• Page unit of result instances : You can navigate in the query results pane by paging specified number of records.
• Enable query plan : You can check the query plan before and after its execution. Selecting this option may slightly affect the query execution time because plan information will be created in advance for queries to be executed.
• Get OID info : Fetches OID information during the query execution. This allows you to directly modify/delete data in the query results pane. However, “NONE” is displayed if the OID cannot be fetched as with Join queries. Selecting this option may extend the query execution time.
• Make keyword and functions lowercase : The auto-commit will show the keywords as lowercase.
• Without prompt to save on close when non-file editor is dirty : If the editor doesn't open a file, the save prompt will not pop on close whether the editor is dirty or not.
• Change font & size : You can change fonts and their sizes to be used in the Query Editor.
• Change style : Changes the show style of query editor's pane and result pane.

Database > Properties > Connection Information

• Database IP : The current database's IP address
• Broker IP : By default, the Broker address for the database connection is set to the IP address of the database server. If the Broker server is not connected, you can connect to the Broker by modifying this value. The Broker address can be modified only by the CUBRID Manager admin user. Other users can connect only through the Broker address specified by the admin user.
• Broker port : A Broker port to be used for database connection. The port is displayed by the CUBRID Manager admin user. The Broker port can be modified only by the admin user. Other users can connect only through the Broker port specified by the admin user.
• Character set : You can specify the character set for each database. It is recommended to use only one character set for a database. The default is one used in the system where the CUBRID Manager is running.

11.3. Global Settings

Help Setting

You can set whether the Help is displayed through the internal Help window or the external browser. You can also select the open mode when the Help is executed as an Eclipse plug-in.

Basic Information Setting

You can set the following through basic information setting:

• Whether the CUBRID Manager window is open in the maximum size or the previous size
• Whether to always exit without prompt when CUBRID Manager exits.
• Whether to show or not CUBRID News on startup(available when system locale is set to KR)
• Whether the information window opens with a single or double click in the navigation tree. (The default value is double click.)

JDBC Driver Setting

Multiple JDBC drivers are supported in CUBRID 2008 R2.1 or later. To access database in version earlier than 2.1, you can configure additional version of CUBRID JDBC driver. The CUBRID JDBC drivers are contained in cubridmanager/plugins. In CUBRID Manager R2.1, in general, you can access the corresponding version of database server by using CUBRID-JDBC-8.2.1.x. As multiple JDBC drivers are supported, you can use access the earlier version of database than the version of CUBRID Manager to execute queries. To do it, go to Default Configuration > JDBC Driver Configuration and configure additional JDBC driver that you will use.

However, depending on the version of the database server that is being connected to, there might be some restricted functions. For example, while the functions in the left tree structure work normally in the database of CUBRID 2008 R2.0 or higher, they do not work in earlier versions of the database. In addition, query editing or executing will work normally in the database of CUBRID 2008 R1.4 or higher, but will not work in earlier versions.

Monitoring Dashboard

You can set the color for each status of hosts, database servers, or brokers in the monitoring dashboard.

Import Options Setting

Set which strings will be regarded as NULL value during importing or updating.

Service Operation Setting

Sets database common parameters.

Server-Common/-Specific Parameter Setting

Sets the options related to the service operation. You may set automatic database startup.

HA Setting

Sets database HA parameters.

Edit Configuration File

There are four configuration file can be directly edited including cubrid.conf, cubrid_broker.conf, cm.conf and ha.conf (if this server is HA server and CUBRID version is after 2008R 4.0). For example, if you want to edit cubrid.conf directly, you need click Edit Cubrid Config, then an editor shown the cubrid.conf will be opened.

If you want import/export the content in the editor, you can move server configration files.