Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Changing Database Server Configuration

Editing the Configuration File

You can add/delete parameters or change parameter values by manually editing the database configuration file (cubrid.conf) in the $CUBRID/conf directory.

The following parameter syntax rules are applied when configuring parameters in the configuration file:

  • Parameter names are not case-sensitive.
  • The name and value of a parameter must be entered in the same line.
  • An equal sign (=) can be used to configure the parameter value. Spaces are allowed before and after the equal sign.
  • If the value of a parameter is a character string, enter the character string without quotes. However, use quotes if spaces are included in the character string.
Using SQL Statements
Description

You can configure a parameter value by using SQL statements in the CSQL Interpreter or CUBRID Manager's Query Editor. Note that only client parameters can be updated.

Syntax

SET SYSTEM PARAMETERS 'parameter_name=value [{; name=value}...]'

parameter_name is the name of a client parameter whose value is editable. In this syntax, value is the value of the given parameter. You can change multiple parameter values by separating them with semicolons (;).

Example

The following is an example of retrieving the result of an index scan in OID order and configuring the number of queries to be saved in the history of the CSQL Interpreter to 70.

SET SYSTEM PARAMETERS 'index_scan_in_oid_order=1; csql_history_num=70'

Using Session Commands of the CSQL Interpreter
Description

You can configure database parameter values by using session commands (;SEt) in the CSQL Interpreter. Note that only client parameters can be updated.

Example

The following is an example of configureing the block_ddl_statement parameter to 1 so that execution of DDL statements is not allowed.

csql> ;se block_ddl_statement=1

=== Set Param Input ===

block_ddl_statement=1