11.1. Database Settings
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.
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
Sets the basic information about the currently used CUBRID Manager. Provides the same items as the host setting.
In the Query dialog box, you can set the following options:
11.3. Global Settings
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:
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.
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.
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.