:meta-keywords: cubrid configure, cubrid conf, cubrid parameters, cubrid settings, cubrid.conf, cubrid default parameters :meta-description: How to configure CUBRID database behavior. Set system parameters for Connection, Memory, Disk, Concurrency/Lock, Logging, Transaction Processing, Query Execution, Utilities and High Availability. ***************** System Parameters ***************** This chapter provides information about configuring system parameters that can affect the system performance. System parameters determine overall performance and operation of the system. This chapter explains how to use configuration files for database server and broker as well as a description of each parameter. .. FIXME: For CUBRID Manager server configuration, see `CUBRID Manager Manual `_. This chapter covers the following topics: * Configuring the database server * Configuring the broker Configuring the Database Server =============================== .. _scope-server-conf: Scope of Database Server Configuration -------------------------------------- CUBRID consists of the database server, the broker and the CUBRID Manager. Each component has its configuration file. The system parameter configuration file for the database server is **cubrid.conf** located in the **$CUBRID/conf** directory. System parameters configured in **cubrid.conf** affect overall performance and operation of the database system. Therefore, it is very important to understand the database server configuration. The CUBRID database server has a client/server architecture. To be more specific, it is divided into a database server process linked to the server library and the broker process linked to the client library. The server process manages the database storage structure and provides concurrency and transaction functionalities. The client process prepares for query execution and manages object/schema. System parameters for the database server, which can be set in the **cubrid.conf** file, are classified into a client parameter, a server parameter and a client/server parameter according to the range to which they are applied. A client parameter is only applied to client processes such as the broker. A server parameter affects the behaviors of the server processes. A client/server parameter must be applied to both server and client. .. note:: **Location of cubrid.conf File and How It Works** The **cubrid.conf** file is located on the **$CUBRID/conf** directory. For setting by database, it divides into a section in the **cubrid.conf** file. Changing Database Server Configuration -------------------------------------- Editing the Configuration File ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ You can add/delete parameters or change parameter values by manually editing the system parameter 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 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 ^^^^^^^^^^^^^^^^^^^^ You can configure a parameter value by using SQL statements in the CSQL Interpreter or CUBRID Manager's Query Editor. Note that you cannot change every parameter. For updatable parameters, see :ref:`cubrid-conf`. :: 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 a semicolon(;). You should be careful when you change a parameter. The following example shows how to retrieve the result of an index scan in OID order and configure the number of queries to be stored in the history of the CSQL Interpreter to 70. .. code-block:: sql SET SYSTEM PARAMETERS 'index_scan_in_oid_order=1; csql_history_num=70'; **DEFAULT** for *value* will reset the parameter to its default value with an exception of **call_stack_dump_activation_list** parameter. .. code-block:: sql SET SYSTEM PARAMETERS 'lock_timeout=DEFAULT'; Using Session Commands of the CSQL Interpreter ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ You can configure system parameter values by using session commands (;SET) in the CSQL Interpreter. Note that you cannot change every parameter. For updatable parameters, see :ref:`cubrid-conf`. The following example shows how to configure 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 .. _cubrid-conf: cubrid.conf Configuration File and Default Parameters ----------------------------------------------------- CUBRID consists of the database server, the broker and the CUBRID Manager. The name of the configuration file for each component is as follows. These files are all located in the **$CUBRID/conf** directory. * Database server configuration file: **cubrid.conf** * Broker configuration file: **cubrid_broker.conf** * CUBRID Manager server configuration file: **cm.conf** **cubrid.conf** is a configuration file that sets system parameters for the CUBRID database server and determines overall performance and operation of the database system. In the **cubrid.conf** file, some important parameters needed for system installation are provided, having their default values. Database Server System Parameters ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The following are database server system parameters that can be used in the **cubrid.conf** configuration file. On the following table, "Applied" column's "client parameter" means that they are applied to CAS, CSQL, **cubrid** utilities. Its "server parameter" means that they are applied to the DB server (cub_server process). For the scope of **client** and **server parameters**, see :ref:`scope-server-conf`. You can change the parameters that are capable of changing dynamically the setting value through the **SET SYSTEM PARAMETERS** statement or a session command of the CSQL Interpreter, **;set** while running the DB. If you are a DBA, you can change parameters regardless of the applied classification. However, if you are not a DBA, you can only change "session" parameters. (on the below table, a parameter of which "session" item's value is O.) On the below table, if "Applied" is "server parameter", that parameter affects to cub_server process; If "client parameter", that parameter affects to CAS, CSQL or "cubrid" utilities which run on client/server mode (--CS-mode). "Client/server parameter" affects to all of cub_server, CAS, CSQL and "cubrid" utilities. "Dynamic Change" and "Session or not" are marked on the below table. The affected range of the parameter which "Dynamic Change" is "available" depends on "Applied" and "Session" items. * If "Dynamic Change" is "available" and "Applied" is "server parameter", that parameter's changed value is applied to DB server. Then applications use the changed value of the parameter until the DB server is restarted. * If "Dynamic Change" is "available" and "Applied" is "client parameter", this belongs to the "session" parameter and that parameter's changed value is applied only to that DB session. In other words, the changed value is only applied to the application which requested to change that value. For example, if **block_ddl_statement** parameter's value is changed into **yes**, then only the application requested to change that parameter cannot use DDL statements. * If "Dynamic Change" is "available", "Applied" is "client parameter" and; * this belongs to the "session" parameter, that parameter's changed value is applied only to that DB session. In other words, the changed value is only applied to the application requested to change that value. For example, if **add_column_update_hard_default** parameter's value is changed into **yes**, then only the application requested to change that parameter lets the newly added column with NOT NULL constraint have hard default value. * this does not belong to the "session" parameter, the values of "client" side and "server" side are changed. For example, **error_log_level** parameter is applied to each of "server" side and "client" side; if this value is changed from "ERROR" into "WARNING", this is applied only to "server" (cub_server process) and "client" (CAS or CSQL) which requested to change this value. Other "clients" keeps the value of "ERROR". .. note:: If you want to change the value of a parameter permanently, restart all of DB server and broker after changing configuration values of cubrid.conf. +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | Category | Parameter Name | Applied | Session | Type | Default Value | Dynamic Change | +===============================+=====================================+=========================+=========+==========+================================+=======================+ | :ref:`connection-parameters` | cubrid_port_id | client parameter | | int | 1,523 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | check_peer_alive | client/server parameter | O | string | both | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | db_hosts | client parameter | O | string | NULL | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_clients | server parameter | | int | 100 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | tcp_keepalive | client/server parameter | | bool | yes | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`memory-parameters` | data_buffer_size | server parameter | | byte | 32,768 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | index_scan_oid_buffer_size | server parameter | | byte | 4 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_agg_hash_size | server parameter | | byte | 2,097,152(2M) | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_hash_list_scan_size | server parameter | | byte | 4,194,304(4M) | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | sort_buffer_size | server parameter | | byte | 128 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | temp_file_memory_size_in_pages | server parameter | | int | 4 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | thread_stacksize | server parameter | | byte | 1,048,576 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`disk-parameters` | db_volume_size | server parameter | | byte | 512M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | dont_reuse_heap_file | server parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | log_volume_size | server parameter | | byte | 512M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | temp_file_max_size_in_pages | server parameter | | int | -1 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | temp_volume_path | server parameter | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | unfill_factor | server parameter | | float | 0.1 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | volume_extension_path | server parameter | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | double_write_buffer_size | server parameter | | byte | 2M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | data_file_os_advise | server parameter | | int | 0 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`error-parameters` | call_stack_dump_activation_list | client/server parameter | | string | DEFAULT | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | call_stack_dump_deactivation_list | client/server parameter | | string | NULL | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | call_stack_dump_on_error | client/server parameter | | bool | no | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | error_log | client/server parameter | | string | cub_client.err, cub_server.err | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | error_log_level | client/server parameter | | string | NOTIFICATION | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | error_log_warning | client/server parameter | | bool | no | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | error_log_size | client/server parameter | | int | 512M | DBA only | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`lock-parameters` | deadlock_detection_interval_in_secs | server parameter | | float | 1.0 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | isolation_level | client parameter | O | int | 4 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | lock_escalation | server parameter | | int | 100,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | lock_timeout | client parameter | O | msec | -1 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | rollback_on_lock_escalation | server parameter | | bool | no | DBA only | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`logging-parameters` | adaptive_flush_control | server parameter | | bool | yes | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | background_archiving | server parameter | | bool | yes | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | checkpoint_every_size | server parameter | | byte | 100,000 * | | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | checkpoint_interval | server parameter | | msec | 6min | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | checkpoint_sleep_msecs | server parameter | | msec | 1 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | force_remove_log_archives | server parameter | | bool | yes | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | log_buffer_size | server parameter | | byte | 16k * | | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | log_max_archives | server parameter | | int | INT_MAX | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | log_trace_flush_time | server parameter | | msec | 0 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_flush_size_per_second | server parameter | | byte | 10,000 * | DBA only | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | remove_log_archive_interval_in_secs | server parameter | | sec | 0 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | sync_on_flush_size | server parameter | | byte | 200 * | DBA only | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | ddl_audit_log | client parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | ddl_audit_log_size | client parameter | | byte | 10M | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`transaction-parameters` | async_commit | server parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | group_commit_interval_in_msecs | server parameter | | msec | 0 | DBA only | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`stmt-type-parameters` | add_column_update_hard_default | client/server parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | alter_table_change_type_strict | client/server parameter | O | bool | yes | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | allow_truncated_string | client/server parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | ansi_quotes | client parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | block_ddl_statement | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | block_nowhere_statement | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | compat_numeric_division_scale | client/server parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | create_table_reuseoid | client parameter | O | bool | yes | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | cte_max_recursions | client/server parameter | O | int | 2000 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | default_week_format | client/server parameter | O | int | 0 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | group_concat_max_len | server parameter | O | byte | 1,024 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | intl_check_input_string | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | intl_collation | client parameter | O | string | | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | intl_date_lang | client parameter | O | string | | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | intl_number_lang | client parameter | O | string | | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | json_max_array_idx | server parameter | O | string | 65,536 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | no_backslash_escapes | client parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | only_full_group_by | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | oracle_style_empty_string | client parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | pipes_as_concat | client parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | plus_as_concat | client parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | require_like_escape_character | client parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | return_null_on_function_errors | client/server parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | string_max_size_bytes | client/server parameter | O | byte | 1,048,576 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | unicode_input_normalization | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | unicode_output_normalization | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | update_use_attribute_references | client parameter | O | bool | no | available | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`thread-parameters` | thread_connection_pooling | server parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | thread_connection_timeout_seconds | server parameter | | int | 300 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | thread_worker_pooling | server parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | thread_worker_timeout_seconds | server parameter | | int | 300 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | loaddb_worker_count | server parameter | | int | 8 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`timezone-parameters` | server_timezone | server parameter | | string | OS timezone | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | timezone | client/server parameter | O | string | the value of server_timezone | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | tz_leap_second_support | server parameter | | bool | no | available | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`plan-cache-parameters` | max_plan_cache_entries | client/server parameter | | int | 1,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_plan_cache_clones | server parameter | | int | 1,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | xasl_cache_time_threshold_in_minutes| client/server parameter | | int | 360 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | max_filter_pred_cache_entries | client/server parameter | | int | 1,000 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`query-cache-parameters` | max_query_cache_entries | server parameter | | int | 0 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | query_cache_size_in_pages | server parameter | | int | 0 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`utility-parameters` | backup_volume_max_size_bytes | server parameter | | byte | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | communication_histogram | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | compactdb_page_reclaim_only | server parameter | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | csql_history_num | client parameter | O | int | 50 | available | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`ha-parameters` | ha_mode | server parameter | | string | off | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | :ref:`other-parameters` | access_ip_control | server parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | access_ip_control_file | server parameter | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | agg_hash_respect_order | client parameter | O | bool | yes | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | auto_restart_server | server parameter | O | bool | yes | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | enable_string_compression | client/server parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | index_scan_in_oid_order | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | index_unfill_factor | server parameter | | float | 0.05 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | java_stored_procedure | server parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | java_stored_procedure_port | server parameter | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | java_stored_procedure_jvm_options | server parameter | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | multi_range_optimization_limit | server parameter | O | int | 100 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | optimizer_enable_merge_join | client parameter | O | bool | no | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | use_stat_estimation | server parameter | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | pthread_scope_process | server parameter | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | server | server parameter | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | service | server parameter | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | session_state_timeout | server parameter | | sec | 21,600 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | sort_limit_max_count | client parameter | O | int | 1,000 | available | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | sql_trace_slow | server parameter | O | msec | -1 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | sql_trace_execution_plan | server parameter | O | bool | no | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | use_orderby_sort_limit | server parameter | O | bool | yes | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | vacuum_prefetch_log_mode | server parameter | | int | 1 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | vacuum_prefetch_log_buffer_size | server parameter | | int | 3200 * | DBA only | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | data_buffer_neighbor_flush_pages | server parameter | | int | 8 | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | data_buffer_neighbor_flush_nondirty | server parameter | | bool | no | DBA only | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | tde_keys_file_path | server parameter | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ | | tde_default_algorithm | server parameter | | string | AES | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------------+ .. _lpg: * **log_page_size**: A log volume page size specified by **--log-page-size** option when you are :ref:`creating database`. Default: 16KB. log page related parameter's value is rounded off by page unit. For example, the value of checkpoint_every_size is divided by 16KB and its decimal point is dropped, then it is multiplied by 16KB. .. _dpg: * **db_page_size**: A DB volume page size specified by **--db-page-size** option when you are :ref:`creating database`. Default: 16KB. DB page related parameter's value is rounded off by page unit. For example, the value of data_buffer_size is divided by 16KB and its decimal point is dropped, then it is multiplied by 16KB. Section by Parameter ^^^^^^^^^^^^^^^^^^^^ Parameters specified in **cubrid.conf** have the following four sections: * Used when the CUBRID service starts: [service] section * Applied commonly to all databases: [common] section * Applied individually to each database: [@<*database*>] section * Used only when the cubrid utilities are run with stand-alone mode(--SA-mode): [standalone] section Where <*database*> is the name of the database to which each parameter applies. If a parameter configured in [common] is the same as the one configured in [@<*database*>], the one configured in [@<*database*>] is applied. :: ..... [common] ..... sort_buffer_size=2M ..... [standalone] sort_buffer_size=256M ..... Configuration defined in [standalone] is used only when cubrid utilities started with "cubrid" are run with stand-alone mode. For example, on the above configuration, if DB is started with --CS-mode(default)(cubrid databases start db_name), "sort_buffer_size=2M" is applied. However, if DB is stopped and "cubrid loaddb --SA-mode" is executed, "sort_buffer_size=256M" is applied. If you run "cubrid loaddb --SA-mode", bigger size of sort buffer will be required during index creation; therefore, increasing sort buffer size will be better for the performance of "loaddb" execution. Default Parameters ^^^^^^^^^^^^^^^^^^ **cubrid.conf**, a default database configuration file created during the CUBRID installation, includes some default database server parameters that must be changed. You can change the value of a parameter that is not included as a default parameter by manually adding or editing one. The following is the content of the **cubrid.conf** file. :: # Copyright (C) 2008 Search Solution Corporation. All rights reserved by Search Solution. # # $Id$ # # cubrid.conf# # For complete information on parameters, see the CUBRID # Database Administration Guide chapter on System Parameters # Service section - a section for 'cubrid service' command [service] # The list of processes to be started automatically by 'cubrid service start' command # Any combinations are available with server, broker and manager. service=server,broker,manager # The list of database servers in all by 'cubrid service start' command. # This property is effective only when the above 'service' property contains 'server' keyword. #server=demodb,testdb # Common section - properties for all databases # This section will be applied before other database specific sections. [common] # Read the manual for detailed description of system parameters # Manual > System Configuration > Database Server Configuration > Default Parameters # Size of data buffer are using K, M, G, T unit data_buffer_size=512M # Size of log buffer are using K, M, G, T unit log_buffer_size=256M # Size of sort buffer are using K, M, G, T unit # The sort buffer should be allocated per thread. # So, the max size of the sort buffer is sort_buffer_size * max_clients. sort_buffer_size=2M # The maximum number of concurrent client connections the server will accept. # This value also means the total # of concurrent transactions. max_clients=100 # TCP port id for the CUBRID programs (used by all clients). cubrid_port_id=1523 If you want to set **data_buffer_size** as 128M and **max_clients** as 10 only on *testdb*, set as follows. :: [service] service=server,broker,manager [common] data_buffer_size=512M log_buffer_size=256M sort_buffer_size=2M max_clients=100 # TCP port id for the CUBRID programs (used by all clients). cubrid_port_id=1523 [@testdb] data_buffer_size=128M max_clients=10 .. _connection-parameters: Connection-Related Parameters ----------------------------- The following are parameters related to the database server. The type and value range for each parameter are as follows: +---------------------------------+--------+----------+----------+----------+ | Parameter Name | Type | Default | Min | Max | +=================================+========+==========+==========+==========+ | cubrid_port_id | int | 1,523 | 1 | | +---------------------------------+--------+----------+----------+----------+ | check_peer_alive | string | both | | | +---------------------------------+--------+----------+----------+----------+ | db_hosts | string | NULL | | | +---------------------------------+--------+----------+----------+----------+ | max_clients | int | 100 | 10 | 4,000 | +---------------------------------+--------+----------+----------+----------+ | tcp_keepalive | bool | yes | | | +---------------------------------+--------+----------+----------+----------+ **cubrid_port_id** **cubrid_port_id** is a parameter to configure the port to be used by the master process. The default value is **1,523**. If the port 1,523 is already being used on the server where CUBRID is installed or it is blocked by a firewall, an error message, which means the master server is not connected because the master process cannot be running properly, is displayed. If such port conflict occurs, the administrator must change the value of **cubrid_port_id** considering the server environment. .. _check_peer_alive: **check_peer_alive** **check_peer_alive** is a parameter to decide whether you execute the function checking that the client/server processes work well. The default is **both**. The client processes connecting with a server process are the broker application server(cub_cas) process, the process copying replication logs(copylogdb), the process applying replication logs. (applylogdb), CSQL interpreter(csql), etc. The server process and the client process which connected with it wait each other's response. But if one of them cannot get the data for a long time(example: exceeding 5 sec), it will check or not if the other works well based on the configuration of check_peer_alive parameter. During this processes, if it is judged that the process doesn't work properly, it disconnect forcibly. The values and the working methods are as follows. * **both**: As the server process accesses to the client process by ECHO(7) port, it checks if the client process works well. The client process also does the same thing to the server process(The default value). * **server_only**: Only the server process checks whether the client process works well. * **client_only**: Only the client process checks whether the server process works well. * **none**: None of the server and client processes check whether the other process works well. Specially, if ECHO(7) port is blocked by the firewall configuration, each process can mistake that the other process was exited. Therefore, you should avoid this problem by setting this parameter's value as none. **db_hosts** **db_hosts** is a parameter to configure a list of the database server hosts to which clients can connect, and the connection order. The server host list consists of multiple server host names, and host names are separated by spaces or colons (:). Duplicate or non-existent names are ignored. The following example shows the values of the **db_hosts** parameter. In this example, connections are attempted in the order of **host1** > **host2** > **host3**. :: db_hosts="hosts1:hosts2:hosts3" To connect to the server, the client first tries to connect to the specified server host referring to the database location file (**databases.txt**). If the connection fails, the client then tries to connect to the first one of the secondarily specified server hosts by referring to the value of the **db_hosts** parameter in the database configuration file (**cubrid.conf**). .. _max_clients: **max_clients** **max_clients** is a parameter to configure the maximum number of clients (usually broker application processes (CAS)) which allow concurrent connections to the database server. The **max_clients** parameter refers to the number of concurrent transactions per database server process. The default value is **100**. To guarantee performance while increasing the number of concurrent users in CUBRID environment, you need to make the appropriate value of the **max_clients** (**cubrid.conf**) parameter and the :ref:`MAX_NUM_APPL_SERVER ` (**cubrid_broker.conf**) parameter. That is, you are required to configure the number of concurrent connections allowed by databases with the **max_clients** parameter. You should also configure the number of concurrent connections allowed by brokers with the **MAX_NUM_APPL_SERVER** parameter. For example, in the **cubrid_broker.conf** file, two node of a broker where the **MAX_NUM_APPL_SERVER** value of [%query_editor] is 50 and the **MAX_NUM_APPL_SERVER** value of [%BROKER1] is 50 is trying to connect one database server, the concurrent connections (**max_clients** value) allowed by the database server can be configured as follows: * (the maximum number of 100 by each node of a broker) * (two node of a broker) + (10 spare for database server connections of internal CUBRID process such as database server connection of CSQL Interpreter or HA log replication process) = 210 Especially, in HA environment, the value must be greater than the sum specified in **MAX_NUM_APPL_SERVER** of every broker node which connects to the same database. Note that the memory usage is affected by the value specified in **max_clients**. That is, if the number of value is high, the memory usage will increase regardless of whether or not the clients actually access the database. .. note:: In Linux system, max_clients parameter is related to "ulimit -n" command, which specifies the maximum number of file descriptors which a process can use. File descriptor includes not only a file, but also a network socket. Therefore, the number of "ulimit -n" should be greater than the number of max_clients. **tcp_keepalive** **tcp_keepalive** is a parameter which specifies if you apply SO_KEEPALIVE option to TCP network protocol or not. The default is **yes**. If this value is **no**, DB server-side connection can be disconnected when transaction logs are not copied for a long time in the firewall environment between master and slave. .. _memory-parameters: Memory-Related Parameters ------------------------- The following are parameters related to the memory used by the database server or client. The type and value range for each parameter are as follows: +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | Parameter Name | Type | Default | Min | Max | +================================+========+===========================+===========================+===========================+ | data_buffer_size | byte | 32,768 * | 1,024 * | 2G(32bit), | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | INT_MAX * | | | | | | :ref:`db_page_size ` | | | | | | (64bit) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | index_scan_oid_buffer_size | byte | 4 * | 0.05 * | 16 * | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | :ref:`db_page_size ` | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | max_agg_hash_size | byte | 2,097,152(2M) | 32,768(32K) | 134,217,728(128MB) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | max_hash_list_scan_size | byte | 4,194,304(4M) | 0 | 128MB | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | sort_buffer_size | byte | 128 * | 1 * | 2G(32bit), | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | INT_MAX * | | | | | | :ref:`db_page_size ` | | | | | | (64bit) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | temp_file_memory_size_in_pages | int | 4 | 0 | 20 | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | thread_stacksize | byte | 1,048,576 | 65,536 | | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ **data_buffer_size** **data_buffer_size** is a parameter to configure the size of data buffer to be cached in the memory by the database server. You can set a unit as B, K, M, G or T, which stands for bytes, kilobytes(KB), megabytes(MB), gigabytes(GB) or terabytes(TB) respectively. If you omit the unit, bytes will be applied. The default value is 32,768 * :ref:`db_page_size ` (**512M** when db_page_size is 16K), and the minimum value is 1,024 * :ref:`db_page_size ` (**16M** when db_page_size is 16K). The maximum value in 64-bit CUBRID is INT_MAX * :ref:`db_page_size `. Note that the maximum value in 32-bit CUBRID is **2G**. The greater the value of the **data_buffer_size** parameter, the more data pages to be cached in the buffer, thus providing the advantage of decreased disk I/O cost. However, if this parameter is too large, the buffer pool can be swapped out by the operating system because the system memory is excessively occupied. It is recommended to configure the **data_buffer_size** parameter in a way the required memory size is less than two-thirds of the system memory size. * Required memory size = data buffer size (**data_buffer_size**) **index_scan_oid_buffer_size** **index_scan_oid_buffer_size** is a parameter to configure the size of buffer where the OID list is to be temporarily stored during the index scan. You can set unit K, which stands for KB (kilobytes). If you omit the unit, bytes will be applied. The default value is 4 * :ref:`db_page_size ` (**64K** when db_page_size is 16K), and the minimum value is 0.05 * :ref:`db_page_size ` (about **1K** when db_page_size is 16K). The size of the OID buffer tends to vary in proportion to the value of the **index_scan_oid_buffer_size** parameter and the page size set when the database was created. In addition, the bigger the size of such OID buffer, the more the index scan cost. You can set the value of the **index_scan_oid_buffer_size** by considering these factors. .. _max_agg_hash_size: **max_agg_hash_size** **max_agg_hash_size** is a parameter to configure the maximum memory per transaction allocated for hashing the tuple groups in a query containing aggregation. The default is **2,097,152**\ (2M), the minimum size is 32,768(32K), and the maximum size is 134,217,728(128MB). If :ref:`NO_HASH_AGGREGATE ` hint is specified, hash aggregate evaluation will not be used. As a reference, see :ref:`agg_hash_respect_order `. .. _max_hash_list_scan_size: **max_hash_list_scan_size** **max_hash_list_scan_size** is a parameter to configure the maximum memory per transaction allocated for building hash table in a query containing subquerys. The default is 4MB, the minimum size is 0, and the maximum size is 128MB. If this parameter is set to 0 or If :ref:`NO_HASH_LIST_SCAN ` hint is specified, hash list scan will not be used. **sort_buffer_size** **sort_buffer_size** is a parameter to configure the size of buffer to be used when a query is processing sorting. The server assigns one sort buffer for each client's sorting-request, and releases the assigned buffer memory when sorting is complete. A sorting query includes not only SELECT sorting query, but also index-creating query. You can set a unit as B, K, M, G or T, which stand for bytes, kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The default value is 128 * :ref:`db_page_size ` (**2M** when db_page_size is 16K), and the minimum value is 1 * :ref:`db_page_size ` (**16K** when db_page_size is 16K). **temp_file_memory_size_in_pages** **temp_file_memory_size_in_pages** is a parameter to configure the number of buffer pages to cache temporary result of a query. The default value is **4** and the maximum value is 20. * Required memory size = the number of temporary memory buffer pages (**temp_file_memory_size_in_pages** \* **page size**) * The number of temporary memory buffer pages = the value of the **temp_file_memory_size_in_pages** parameter * Page size = the value of the page size specified by the **-s** option of the **cubrid createdb** utility during the database creation The spaces to store the temporary result are as follows. * Cache buffer to store the temporary result (acquired by **temp_file_memory_size_in_pages** parameter) * Permanent volumes with the purpose of storing temporary data. * Temporary volumes If the previous space is exhausted, then the next space is used as the following order: Cache buffer for storing temporary result -> Permanent volumes -> Temporary volumes. **thread_stacksize** **thread_stacksize** is a parameter to configure the stack size of a thread. The default value is **1048576** bytes. The value of the **thread_stacksize** parameter must not exceed the stack size allowed by the operating system. .. _disk-parameters: Disk-Related Parameters ----------------------- The following are disk-related parameters for defining database volumes and storing files. The type and value range for each parameter are as follows: +------------------------------------------+--------+----------+----------+----------+ | Parameter Name | Type | Default | Min | Max | +==========================================+========+==========+==========+==========+ | db_volume_size | byte | 512M | 0 | 20G | +------------------------------------------+--------+----------+----------+----------+ | dont_reuse_heap_file | bool | no | | | +------------------------------------------+--------+----------+----------+----------+ | log_volume_size | byte | 512M | 20M | 4G | +------------------------------------------+--------+----------+----------+----------+ | temp_file_max_size_in_pages | int | -1 | | | +------------------------------------------+--------+----------+----------+----------+ | temp_volume_path | string | NULL | | | +------------------------------------------+--------+----------+----------+----------+ | unfill_factor | float | 0.1 | 0.0 | 0.3 | +------------------------------------------+--------+----------+----------+----------+ | volume_extension_path | string | NULL | | | +------------------------------------------+--------+----------+----------+----------+ | double_write_buffer_size | byte | 2M | 0 | 32M | +------------------------------------------+--------+----------+----------+----------+ | data_file_os_advise | int | 0 | 0 | 6 | +------------------------------------------+--------+----------+----------+----------+ **db_volume_size** **db_volume_size** is a parameter to configure the following values. You can set a unit as B, K, M, G or T, which stand for bytes, kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The default value is **512M**. * The default database volume size when **cubrid createdb** and **cubrid addvoldb** utility is used without **--db-volume-size** option. * The default size of volume that is added automatically when database is full. .. note:: The actual volume size will always be rounded up to a multiple of the size of 64 sectors. Sector size depends on page size, therefore 64 sectors size is 16M, 32M or 64M for page size 4k, 8k or 16k respectively. **dont_reuse_heap_file** **dont_reuse_heap_file** is a parameter to configure whether or not heap files, which are deleted when deleting the table (**DROP TABLE**), are to be reused when creating a new table (**CREATE TABLE**). If this parameter is set to no, the deleted heap files can be reused; if it is set to yes, the deleted heap files are not used when creating a new table. The default value is **no**. **log_volume_size** **log_volume_size** is a parameter to configure the default size of log volume file when the **cubrid createdb** utility is used without **--log-volume-size** option. You can set a unit as B, K, M, G or T, which stand for bytes, kilobytes (KB), megabytes (MB), gigabytes (GB) and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The default value is **512M**. **temp_file_max_size_in_pages** **temp_file_max_size_in_pages** is a parameter to configure the maximum number of pages to which temporary volumes can be extended. By default, this value is **-1**, which means that temporary volumes can occupy an unlimited disk space. A positive value will set a limit to these values (exceeding it may show an error and cancel some big queries). If the parameter is configured to **0**, temporary volumes are not created automatically; the administrator must create permanent volumes with the purpose of storing temporary data by using the **cubrid addvoldb** utility. For more details see :ref:`temporary-volumes` **temp_volume_path** **temp_volume_path** is a parameter to configure the directory in which to create temporary volumes used for the execution of complex queries or sorting. The default value is the volume location configured during the database creation. **unfill_factor** **unfill_factor** is a parameter to configure the rate of disk space to be allocated in a heap page for data updates. The default value is **0.1**. That is, the rate of free space is configured to 10%. In principle, data in the table is inserted in physical order. However, if the size of the data increases due to updates and there is not enough space for storage in the given page, performance may degrade because updated data must be relocated to another page. To prevent such a problem, you can configure the rate of space for a heap page by using the **unfill_factor** parameter. The allowable maximum value is 0.3 (30%). In a database where data updates rarely occur, you can configure this parameter to 0.0 so that space will not be allocated in a heap page for data updates. If the value of the **unfill_factor** parameter is negative or greater than the maximum value, the default value (**0.1**) is used. **volume_extension_path** **volume_extension_path** is a parameter to configure the directory where automatically extended volumes are to be created. The default value is the volume location configured during the database creation. **double_write_buffer_size** **double_write_buffer_size** is a parameter to configure the memory and disk size of double writer buffer. Double write buffer protection against partial I/O writes can be disabled by setting this size to zero. By default, it is enabled and its size is 2M. **data_file_os_advise** **data_file_os_advise** is a UNIX-only parameter that may be used to boost I/O performance. \ \The parameter value is converted into a *posix_fadvise()* flag \ \(for details about the flags `see here `_). +-----------------------------------+-------------------------------------------+ | Parameter Value | posix_fadvise flag | +===================================+===========================================+ | 0 | 0 | +-----------------------------------+-------------------------------------------+ | 1 | POSIX_FADV_NORMAL | +-----------------------------------+-------------------------------------------+ | 2 | POSIX_FADV_SEQUENTIAL | +-----------------------------------+-------------------------------------------+ | 3 | POSIX_FADV_RANDOM | +-----------------------------------+-------------------------------------------+ | 4 | POSIX_FADV_NOREUSE | +-----------------------------------+-------------------------------------------+ | 5 | POSIX_FADV_WILLNEED | +-----------------------------------+-------------------------------------------+ | 6 | POSIX_FADV_DONTNEED | +-----------------------------------+-------------------------------------------+ .. warning:: Make sure posix_fadvise flags and how data is accessed are perfectly understood. \ \The parameter can help improve performance but it can also degrade it if misused. \ \In most scenarios it is best to use the default value. .. _error-parameters: Error Message-Related Parameters -------------------------------- The following are parameters related to processing error messages recorded by CUBRID. The type and value range for each parameter are as follows: +-----------------------------------+----------+--------------------------------+ | Parameter Name | Type | Default | +===================================+==========+================================+ | call_stack_dump_activation_list | string | DEFAULT | +-----------------------------------+----------+--------------------------------+ | call_stack_dump_deactivation_list | string | NULL | +-----------------------------------+----------+--------------------------------+ | call_stack_dump_on_error | bool | no | +-----------------------------------+----------+--------------------------------+ | error_log | string | cub_client.err, cub_server.err | +-----------------------------------+----------+--------------------------------+ | error_log_level | string | NOTIFICATION | +-----------------------------------+----------+--------------------------------+ | error_log_warning | bool | no | +-----------------------------------+----------+--------------------------------+ | error_log_size | int | 512M | +-----------------------------------+----------+--------------------------------+ **call_stack_dump_activation_list** **call_stack_dump_activation_list** is a parameter to configure a certain error number for which a call stack is to be dumped to a server error log (located in $CUBRID/log/server directory) as an exception even when you configure that a call stack will not be dumped for any errors. Therefore, the **call_stack_dump_activation_list** parameter is effective only when **call_stack_dump_on_error=no**. If this value is not configured, the default value is "DEFAULT" keyword. This keyword includes below errors. "DEFAULT" keyword can be used together with other error numbers. +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | Error Number | Error Message | +==============+=================================================================================================================================================+ | -2 | Internal system failure: no more specific information is available. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -7 | Trying to format disk volume xxx with an incorrect value xxx for number of pages. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -13 | An I/O error occurred while reading page xxx of volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -14 | An I/O error occurred while writing page xxx of volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -17 | Internal error: fetching deallocated pageid xxx of volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -19 | Internal error: pageptr = xxx of page xxx of volume xxx is not fixed. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -21 | Internal error: unknown sector xxx of volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -22 | Internal error: unknown page xxx of volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -45 | Slot xxx on page xxx of volume xxx is allocated to an anchored record. A new record cannot be inserted here. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -46 | Internal error: slot xxx on page xxx of volume xxx is not allocated. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -48 | Accessing deleted object xxx|xxx|xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -50 | Internal error: relocation record of object xxx|xxx|xxx may be corrupted. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -51 | Internal error: object xxx|xxx|xxx may be corrupted. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -52 | Internal error: object overflow address xxx|xxx|xxx may be corrupted. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -76 | Your transaction (index xxx, xxx\@xxx|xxx) timed out waiting on xxx on page xxx|xxx. You are waiting for user(s) xxx to release the page lock. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -78 | Internal error: an I/O error occurred while reading logical log page xxx (physical page xxx) of xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -79 | Internal error: an I/O error occurred while writing logical log page xxx (physical page xxx) of xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -81 | Internal error: logical log page xxx may be corrupted. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -90 | Redo logging is always a page level logging operation. A data page pointer must be given as part of the address. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -96 | Media recovery may be needed on volume xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -97 | Internal error: unable to find log page xxx in log archives. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -313 | Object buffer underflow while reading. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -314 | Object buffer overflow while writing. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -407 | Unknown key xxx referenced in B+tree index {vfid: (xxx, xxx), rt_pgid: xxx, key_type: xxx}. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -414 | Unknown class identifier: xxx|xxx|xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -415 | Invalid class identifier: xxx|xxx|xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -416 | Unknown representation identifier: xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -417 | Invalid representation identifier: xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -583 | Trying to allocate an invalid number (xxx) of pages. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -603 | Internal Error: Sector/page table of file VFID xxx|xxx seems corrupted. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -836 | LATCH ON PAGE(xxx|xxx) TIMEDOUT | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -859 | LATCH ON PAGE(xxx|xxx) ABORTED | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -890 | Partition failed. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -891 | Appropriate partition does not exist. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -976 | Internal error: Table size overflow (allocated size: xxx, accessed size: xxx) at file table page xxx|xxx(volume xxx) | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -1040 | HA generic: xxx. | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ | -1075 | Descending index scan aborted because of lower priority on B+tree with index identifier: (vfid = (xxx, xxx), rt_pgid: xxx). | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------+ The following example shows how to make error numbers only -115 and -116, perform call-stack dump. :: call_stack_dump_on_error= no call_stack_dump_activation_list=-115,-116 The following example shows how to make error numbers -115, -116 and "DEFAULT" error numbers, perform call-stack dump. :: call_stack_dump_on_error= no call_stack_dump_activation_list=-115,-116, DEFAULT **call_stack_dump_deactivation_list** **call_stack_dump_deactivation_list** is a parameter to configure a certain error number for which a call stack is not to be dumped when you configure that a call stack will be dumped for any errors. Therefore, the **call_stack_dump_deactivation_list** parameter is effective only when **call_stack_dump_on_error** is set to **yes**. The following example shows how to configure the parameter so that call stacks will be dumped for any errors, except the ones whose numbers are -115 and -116. :: call_stack_dump_on_error= yes call_stack_dump_deactivation_list=-115,-116 **call_stack_dump_on_error** **call_stack_dump_on_error** is a parameter to configure whether or not to dump a call stack when an error occurs in the database server. If this parameter is set to **no**, a call stack for any errors is not dumped. If it is set to **yes**, a call stack for all errors is dumped. The default value is **no**. **error_log** **error_log** is a server/client parameter to configure the name of the error log file when an error occurs in the database server. The name of the error log file must be in the form of *__