Scalable Database Server, HiRDB Version 8 System Definition
The values of some system common definition operands can be changed in the unit control information definition and in the individual server definitions. These operands are indicated below. After a planned termination, forced termination, or abnormal termination of HiRDB, some HiRDB system definition operands can be modified while others cannot be modified. The operands that can be modified are indicated below.
| No. | Operand | Definition name | Modifiable after forced or abnormal termination? | Modifiable after planned termination? | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| SYS | UNT | SVR | SDS | FES | DS | BES | ||||
| 1 | pd_system_id | Y | N | N | ||||||
| 2 | pd_name_port | Y | Y | Y | ||||||
| 3 | pd_master_file_name | Y | N | N | ||||||
| 4 | pd_max_users | Y | N | Y | ||||||
| 5 | pd_max_server_process | Y | Y | Y | Y | |||||
| 6 | pd_max_access_tables | Y | Y | Y | ||||||
| 7 | pd_utl_exec_mode | Y | N | Y | ||||||
| 8 | pd_max_commit_write_reclaim_no | Y | Y | Y | ||||||
| 9 | pd_mode_conf | Y | Y | Y | ||||||
| 10 | pd_system_complete_wait_time | Y | Y | Y | ||||||
| 11 | pd_start_time_out | Y | Y | Y | ||||||
| 12 | pd_start_level | Y | Y | Y | ||||||
| 13 | pd_reduced_check_time | Y | Y | Y | ||||||
| 14 | pd_start_skip_unit | Y | Y | Y | ||||||
| 15 | pd_start_skip_unit | Y | Y | Y | ||||||
| 16 | pd_dbsync_point | Y | N | Y | ||||||
| 17 | pd_system_dbsync_point | Y | N | Y | ||||||
| 18 | pd_overflow_suppress | Y | Y | Y | ||||||
| 19 | pd_process_terminator | Y | Y | Y | ||||||
| 20 | pd_process_terminator_max | Y | Y | Y | ||||||
| 21 | pd_space_level4 | Y | Y | Y | ||||||
| 22 | pd_dec_sign_normalize | Y | N | Y | ||||||
| 23 | pd_server_entry_queue | Y | Y | Y | Y | |||||
| 24 | pd_thdlock_sleep_func | Y | Y | Y | ||||||
| 25 | pd_thdlock_wakeup_lock | Y | Y | Y | Y | |||||
| 26 | pd_thdlock_pipe_retry_interval | Y | Y | Y | Y | |||||
| 27 | pd_thdlock_retry_time | Y | Y | Y | Y | |||||
| 28 | pd_thdspnlk_spn_count | Y | Y | Y | Y | |||||
| 29 | pd_pageaccess_mode | Y | Y | Y | ||||||
| 30 | pd_cmdhold_precheck | Y | Y | Y | ||||||
| 31 | pd_db_io_error_action | Y | Y | Y | Y | |||||
| 32 | pd_connect_errmsg_hide | Y | Y | Y | ||||||
| 33 | pd_cancel_down_msgchange | Y | Y | Y | ||||||
| 34 | pd_max_recover_process | Y | Y | Y | Y | |||||
| 35 | pd_redo_allpage_put | Y | Y | Y | ||||||
| 36 | pd_trn_rerun_branch_auto_decide | Y | Y | Y | ||||||
| 37 | pd_trn_send_decision_intval_sec | Y | Y | Y | ||||||
| 38 | pd_trn_send_decision_interval | Y | Y | Y | ||||||
| 39 | pd_trn_send_decision_retry_time | Y | Y | Y | ||||||
| 40 | pd_trn_watch_time | Y | Y | Y | ||||||
| 41 | pd_trn_commit_optimize | Y | Y | Y | ||||||
| 42 | pd_optimize_level4 | Y | Y | Y | Y | |||||
| 43 | pd_additional_optimize_level4 | Y | Y | Y | Y | |||||
| 44 | pd_hashjoin_hashing_mode4 | Y | Y | Y | ||||||
| 45 | pd_hash_table_size4 | Y | N | N | ||||||
| 46 | pd_work_table_option | Y | Y | Y | ||||||
| 47 | pd_max_list_users | Y | N2 | Y | ||||||
| 48 | pd_max_list_count | Y | N | Y | ||||||
| 49 | pd_list_initialize_timing | Y | Y | Y | ||||||
| 50 | pd_utl_exec_time | Y | Y | Y | ||||||
| 51 | pd_watch_time | Y | Y | Y | Y | |||||
| 52 | pd_queue_watch_time | Y | Y | Y | ||||||
| 53 | pd_queue_watch_timeover_action | Y | Y | Y | ||||||
| 54 | pd_down_watch_proc | Y | Y | Y | Y | |||||
| 55 | pd_host_watch_interval | Y | Y | Y | ||||||
| 56 | pd_watch_resource | Y | Y | Y | ||||||
| 57 | pd_max_users_wrn_pnt | Y | Y | Y | ||||||
| 58 | pd_max_access_tables_wrn_pnt | Y | Y | Y | ||||||
| 59 | pd_max_rdarea_no_wrn_pnt | Y | Y | Y | ||||||
| 60 | pd_max_file_no_wrn_pnt | Y | Y | Y | ||||||
| 61 | pdwork_wrn_pnt | Y | Y | Y | ||||||
| 62 | pd_max_list_users_wrn_pnt | Y | Y | Y | ||||||
| 63 | pd_max_list_count_wrn_pnt | Y | Y | Y | ||||||
| 64 | pd_rdarea_list_no_wrn_pnt | Y | Y | Y | ||||||
| 65 | pd_cwaittime_wrn_pnt4 | Y | Y | Y | Y | Y | ||||
| 66 | pd_cwaittime_report_dir | Y | Y | Y | Y | |||||
| 67 | pd_cwaittime_report_size | Y | Y | Y | Y | |||||
| 68 | pd_uap_exerror_log_use4 | Y | Y | Y | ||||||
| 69 | pd_uap_exerror_log_dir | Y | Y | Y | Y | |||||
| 70 | pd_uap_exerror_log_size | Y | Y | Y | Y | |||||
| 71 | pd_uap_exerror_log_param_size4 | Y | Y | Y | Y | |||||
| 72 | pd_delete_reserved_word_file4 | Y | Y | Y | ||||||
| 73 | pd_lck_deadlock_info | Y | Y | Y | Y | |||||
| 74 | pd_lck_wait_timeout | Y | Y | Y | Y | |||||
| 75 | pd_lck_release_detect | Y | Y | Y | Y | |||||
| 76 | pd_lck_release_detect_interval | Y | Y | Y | Y | |||||
| 77 | pd_nowait_scan_option | Y | Y | Y | ||||||
| 78 | pd_lck_queue_limit | Y | Y | Y | ||||||
| 79 | pd_deadlock_priority_use | Y | Y | Y | ||||||
| 80 | pd_command_deadlock_priority | Y | Y | Y | ||||||
| 81 | pd_key_resource_type | Y | N | Y | ||||||
| 82 | pd_indexlock_mode | Y | N | Y | ||||||
| 83 | pd_sql_object_cache_size | Y | Y | Y | Y | Y | Y | N | Y | |
| 84 | pd_def_buf_control_area_assign | Y | Y | Y | ||||||
| 85 | pd_thread_max_stack_size | Y | Y | Y | ||||||
| 86 | pd_mlg_msg_log_unit | Y | N | N | ||||||
| 87 | pd_mlg_file_size | Y | Y | Y | ||||||
| 88 | pd_statistics | Y | Y | Y | ||||||
| 89 | pd_stj_file_size | Y | Y | N2 | Y | |||||
| 90 | pd_stj_buff_size | Y | Y | N2 | Y | |||||
| 91 | pd_rpc_trace | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 92 | pd_rpc_trace_name | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 93 | pd_rpc_trace_size | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 94 | pd_cancel_dump | Y | Y | Y | Y | |||||
| 95 | pd_client_waittime_over_abort | Y | Y | Y | ||||||
| 96 | pd_dump_suppress_watch_time | Y | Y | Y | Y | |||||
| 97 | pd_debug_info_netstat | Y | Y | Y | ||||||
| 98 | pd_spool_cleanup_interval | Y | Y | Y | Y | |||||
| 99 | pd_spool_cleanup_interval_level | Y | Y | Y | Y | |||||
| 100 | pd_spool_cleanup | Y | Y | Y | Y | |||||
| 101 | pd_spool_cleanup_level | Y | Y | Y | Y | |||||
| 102 | pd_module_trace_max | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 103 | pd_module_trace_timer_level | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 104 | pd_max_rdarea_no | Y | N | Y | ||||||
| 105 | pd_max_file_no | Y | Y1,2 | Y | ||||||
| 106 | pd_rdarea_warning_point | Y | Y | Y | ||||||
| 107 | pd_rdarea_open_attribute_use | Y | Y | Y | ||||||
| 108 | pd_rdarea_open_attribute | Y | Y | Y | ||||||
| 109 | pd_shared_rdarea_use | Y | N | Y | ||||||
| 110 | pd_dbbuff_lru_option | Y | Y | Y | ||||||
| 111 | pd_dbbuff_modify | Y | N | N | ||||||
| 112 | pd_dbbuff_lock_release_detect | Y | Y | Y | ||||||
| 113 | pd_dbbuff_lock_spn_count | Y | Y | Y | ||||||
| 114 | pd_dbbuff_lock_interval | Y | Y | Y | ||||||
| 115 | pd_dbbuff_wait_interval | Y | Y | Y | Y | |||||
| 116 | pd_dbbuff_wait_spn_count | Y | Y | Y | Y | |||||
| 117 | pd_dbbuff_rate_updpage | Y | Y | Y | ||||||
| 118 | pd_assurance_table_no | Y | Y3 | Y | ||||||
| 119 | pd_assurance_index_no | Y | Y3 | Y | ||||||
| 120 | pd_constraint_name | Y | Y | Y | ||||||
| 121 | pd_check_pending | Y | Y | Y | ||||||
| 122 | pd_large_file_use | Y | N | Y | ||||||
| 123 | pd_ntfs_cache_disable | Y | Y | Y | ||||||
| 124 | pd_rorg_predict | Y | Y | Y | ||||||
| 125 | pd_audit | Y | Y | N | N | |||||
| 126 | pd_aud_file_name | Y | Y | Y | Y | |||||
| 127 | pd_aud_max_generation_size | Y | Y | Y | Y | |||||
| 128 | pd_aud_max_generation_num | Y | Y | Y | Y | |||||
| 129 | pd_aud_no_standby_file_opr | Y | Y | Y | ||||||
| 130 | pd_aud_async_buff_size | Y | Y | Y | Y | |||||
| 131 | pd_aud_async_buff_count | Y | Y | Y | Y | |||||
| 132 | pd_aud_async_buff_retry_intvl | Y | Y | Y | Y | |||||
| 133 | pd_aud_file_wrn_pnt | Y | Y | Y | ||||||
| 134 | pd_ha | Y | N | N | ||||||
| 135 | pd_ha_ipaddr_inherit | Y | Y | N | N | |||||
| 136 | pd_ha_switch_timeout | Y | Y | Y | Y | |||||
| 137 | pd_ha_mgr_rerun | Y | Y | Y | ||||||
| 138 | pd_ha_transaction4 | Y | Y | Y | ||||||
| 139 | pd_ha_trn_queuing_wait_time | Y | Y | Y | ||||||
| 140 | pd_ha_trn_restart_retry_time | Y | Y | Y | ||||||
| 141 | pd_ha_resource_act_wait_time | Y | Y | Y | Y | |||||
| 142 | pd_rpl_init_start | Y | N | N | ||||||
| 143 | pd_rpl_reflect_mode | Y | N | Y | ||||||
| 144 | pd_log_rpl_no_standby_file_opr | Y | Y | Y | ||||||
| 145 | pd_jp1_use | Y | N | N | ||||||
| 146 | pd_jp1_event_level | Y | Y | Y | ||||||
| 147 | pd_jp1_event_msg_out | Y | Y | Y | ||||||
| 148 | pd_directory_server | Y | Y | Y | ||||||
| 149 | pd_max_foreign_server | Y | N | Y | ||||||
| 150 | pd_oltp_holdcr | Y | Y | Y | ||||||
| 151 | pd_auto_vrup | Y | N | N | ||||||
| 152 | pd_sysdef_default_option | Y | N | Y | ||||||
| 153 | pd_service_port | Y | Y | Y | Y | |||||
| 154 | pd_change_clt_ipaddr | Y | Y | Y | Y | |||||
| 155 | pd_registered_port | Y | Y | N | Y | |||||
| 156 | pd_registered_port_check | Y | Y | N | Y | |||||
| 157 | pd_registered_port_level | Y | Y | N | Y | |||||
| 158 | pd_ipc_send_retrycount | Y | Y | Y | Y | |||||
| 159 | pd_ipc_send_retrysleeptime | Y | Y | Y | Y | |||||
| 160 | pd_ipc_send_count | Y | Y | Y | Y | |||||
| 161 | pd_ipc_recv_count | Y | Y | Y | Y | |||||
| 162 | pd_ipc_conn_nblock | Y | Y | Y | ||||||
| 163 | pd_ipc_conn_nblock_time | Y | Y | Y | ||||||
| 164 | pd_ipc_conn_interval | Y | Y | Y | ||||||
| 165 | pd_ipc_conn_count | Y | Y | Y | ||||||
| 166 | pd_ipc_inet_bufsize | Y | Y | Y | Y | |||||
| 167 | pd_tcp_inet_bufsize | Y | Y | Y | Y | |||||
| 168 | pd_utl_buff_size | Y | Y1 | Y1 | ||||||
| 169 | pd_sql_send_buff_size | Y | Y | Y | ||||||
| 170 | pd_java_option | Y | Y | Y | ||||||
| 171 | pd_java_routine_stack_size | Y | Y | Y | ||||||
| 172 | pd_java_archive_directory | Y | Y | Y | Y | |||||
| 173 | pd_java_classpath | Y | Y | Y | Y | |||||
| 174 | pd_java_runtimepath | Y | Y | Y | Y | |||||
| 175 | pd_java_libpath | Y | Y | Y | Y | |||||
| 176 | pd_java_stdout_file | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 177 | pdunit | Y | N | N | ||||||
| 178 | pdstart | Y | N | N | ||||||
| 179 | pdbuffer | Y | N | Y | ||||||
| 180 | pdhagroup | Y | N | N | ||||||
| 181 | pdstbegin | Y | Y | Y | ||||||
| 182 | pdhibegin | Y | Y | Y | ||||||
| 183 | pdcltgrp | Y | Y | Y | ||||||
| 184 | pdplugin | Y | N | N | ||||||
| 185 | SHMMAX | Y | Y | Y | Y | |||||
| 186 | TZ | Y | Y | Y | ||||||
| 187 | pdmlgput | Y | Y | Y | ||||||
| 188 | pd_substr_length | Y | Y | Y | ||||||
Y: Yes, specification value can be modified.
N: No, specification valued cannot be modified.
: Specification value cannot be modified because the operand is not applicable.
SYS: System common definition
UNT: Unit control information definition
SVR: Server common definition
SDS: Single server definition
FES: Front-end server definition
DS: Dictionary server definition
BES: Back-end server definition
1 If the specified value is too small, it may not be possible to restart HiRDB. When this is the case, restore the value to what it was before the change and then restart HiRDB.
2 If the specified value is too large, it may not be possible to restart HiRDB. When this is the case, restore the value to what it was before the change and then restart HiRDB.
3 If v6compatible or v7compatible is specified in the pd_sysdef_default_option operand, the value before the change is used to start HiRDB even if the definition is changed during the HiRDB restart.
4 The values of the following HiRDB system definition operands can be changed for each client in its client environment definition. To change values for a client, you must specify the applicable operands in its client environment definition. For details about the client environment definition, see the HiRDB Version 8 UAP Development Guide.
| HiRDB system definition operand | Client environment definition operand |
|---|---|
| pd_additional_optimize_level | PDADDITIONALOPTLVL |
| pd_cwaittime_wrn_pnt | PDCWAITTIMEWRNPNT |
| pd_delete_reserved_word_file | PDDELRSVWDFILE |
| pd_hash_table_size | PDHASHTBLSIZE |
| pd_hashjoin_hashing_mode | PDHJHASHINGMODE |
| pd_optimize_level | PDSQLOPTLVL |
| pd_space_level | PDSPACELVL |
| pd_ha_transaction | PDHATRNQUEUING |
| pd_uap_exerror_log_use | PDUAPEXERLOGUSE |
| pd_uap_exerror_log_param_size | PDUAPEXERLOGPRMSZ |
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.