2.2 Operands whose specification values can be changed

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.OperandDefinition nameModifiable after forced or abnormal termination?Modifiable after planned termination?
SYSUNTSVRSDSFESDSBES
1pd_system_idY[Figure][Figure][Figure][Figure][Figure][Figure]NN
2pd_name_portY[Figure][Figure][Figure][Figure][Figure][Figure]YY
3pd_master_file_nameY[Figure][Figure][Figure][Figure][Figure][Figure]NN
4pd_max_usersY[Figure][Figure][Figure][Figure][Figure][Figure]NY
5pd_max_server_processYY[Figure][Figure][Figure][Figure][Figure]YY
6pd_max_access_tablesY[Figure][Figure][Figure][Figure][Figure][Figure]YY
7pd_utl_exec_modeY[Figure][Figure][Figure][Figure][Figure][Figure]NY
8pd_max_commit_write_reclaim_noY[Figure][Figure][Figure][Figure][Figure][Figure]YY
9pd_mode_confY[Figure][Figure][Figure][Figure][Figure][Figure]YY
10pd_system_complete_wait_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
11pd_start_time_outY[Figure][Figure][Figure][Figure][Figure][Figure]YY
12pd_start_levelY[Figure][Figure][Figure][Figure][Figure][Figure]YY
13pd_reduced_check_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
14pd_start_skip_unitY[Figure][Figure][Figure][Figure][Figure][Figure]YY
15pd_start_skip_unitY[Figure][Figure][Figure][Figure][Figure][Figure]YY
16pd_dbsync_pointY[Figure][Figure][Figure][Figure][Figure][Figure]NY
17pd_system_dbsync_pointY[Figure][Figure][Figure][Figure][Figure][Figure]NY
18pd_overflow_suppressY[Figure][Figure][Figure][Figure][Figure][Figure]YY
19pd_process_terminatorY[Figure][Figure][Figure][Figure][Figure][Figure]YY
20pd_process_terminator_maxY[Figure][Figure][Figure][Figure][Figure][Figure]YY
21pd_space_level4Y[Figure][Figure][Figure][Figure][Figure][Figure]YY
22pd_dec_sign_normalizeY[Figure][Figure][Figure][Figure][Figure][Figure]NY
23pd_server_entry_queueYY[Figure][Figure][Figure][Figure][Figure]YY
24pd_thdlock_sleep_funcY[Figure][Figure][Figure][Figure][Figure][Figure]YY
25pd_thdlock_wakeup_lockYY[Figure][Figure][Figure][Figure][Figure]YY
26pd_thdlock_pipe_retry_intervalYY[Figure][Figure][Figure][Figure][Figure]YY
27pd_thdlock_retry_timeYY[Figure][Figure][Figure][Figure][Figure]YY
28pd_thdspnlk_spn_countYY[Figure][Figure][Figure][Figure][Figure]YY
29pd_pageaccess_modeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
30pd_cmdhold_precheckY[Figure][Figure][Figure][Figure][Figure][Figure]YY
31pd_db_io_error_actionYY[Figure][Figure][Figure][Figure][Figure]YY
32pd_connect_errmsg_hideY[Figure][Figure][Figure][Figure][Figure][Figure]YY
33pd_cancel_down_msgchangeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
34pd_max_recover_processYY[Figure][Figure][Figure][Figure][Figure]YY
35pd_redo_allpage_putY[Figure][Figure][Figure][Figure][Figure][Figure]YY
36pd_trn_rerun_branch_auto_decideY[Figure][Figure][Figure][Figure][Figure][Figure]YY
37pd_trn_send_decision_intval_secY[Figure][Figure][Figure][Figure][Figure][Figure]YY
38pd_trn_send_decision_intervalY[Figure][Figure][Figure][Figure][Figure][Figure]YY
39pd_trn_send_decision_retry_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
40pd_trn_watch_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
41pd_trn_commit_optimizeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
42pd_optimize_level4Y[Figure][Figure][Figure]Y[Figure][Figure]YY
43pd_additional_optimize_level4Y[Figure][Figure][Figure]Y[Figure][Figure]YY
44pd_hashjoin_hashing_mode4Y[Figure][Figure][Figure][Figure][Figure][Figure]YY
45pd_hash_table_size4Y[Figure][Figure][Figure][Figure][Figure][Figure]NN
46pd_work_table_optionY[Figure][Figure][Figure][Figure][Figure][Figure]YY
47pd_max_list_usersY[Figure][Figure][Figure][Figure][Figure][Figure]N2Y
48pd_max_list_countY[Figure][Figure][Figure][Figure][Figure][Figure]NY
49pd_list_initialize_timingY[Figure][Figure][Figure][Figure][Figure][Figure]YY
50pd_utl_exec_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
51pd_watch_timeYY[Figure][Figure][Figure][Figure][Figure]YY
52pd_queue_watch_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
53pd_queue_watch_timeover_actionY[Figure][Figure][Figure][Figure][Figure][Figure]YY
54pd_down_watch_procYY[Figure][Figure][Figure][Figure][Figure]YY
55pd_host_watch_intervalY[Figure][Figure][Figure][Figure][Figure][Figure]YY
56pd_watch_resourceY[Figure][Figure][Figure][Figure][Figure][Figure]YY
57pd_max_users_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
58pd_max_access_tables_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
59pd_max_rdarea_no_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
60pd_max_file_no_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
61pdwork_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
62pd_max_list_users_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
63pd_max_list_count_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
64pd_rdarea_list_no_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
65pd_cwaittime_wrn_pnt4Y[Figure][Figure]YY[Figure][Figure]YY
66pd_cwaittime_report_dirYY[Figure][Figure][Figure][Figure][Figure]YY
67pd_cwaittime_report_sizeYY[Figure][Figure][Figure][Figure][Figure]YY
68pd_uap_exerror_log_use4Y[Figure][Figure][Figure][Figure][Figure][Figure]YY
69pd_uap_exerror_log_dirYY[Figure][Figure][Figure][Figure][Figure]YY
70pd_uap_exerror_log_sizeYY[Figure][Figure][Figure][Figure][Figure]YY
71pd_uap_exerror_log_param_size4YY[Figure][Figure][Figure][Figure][Figure]YY
72pd_delete_reserved_word_file4Y[Figure][Figure][Figure][Figure][Figure][Figure]YY
73pd_lck_deadlock_infoYY[Figure][Figure][Figure][Figure][Figure]YY
74pd_lck_wait_timeoutYY[Figure][Figure][Figure][Figure][Figure]YY
75pd_lck_release_detectYY[Figure][Figure][Figure][Figure][Figure]YY
76pd_lck_release_detect_intervalYY[Figure][Figure][Figure][Figure][Figure]YY
77pd_nowait_scan_optionY[Figure][Figure][Figure][Figure][Figure][Figure]YY
78pd_lck_queue_limitY[Figure][Figure][Figure][Figure][Figure][Figure]YY
79pd_deadlock_priority_useY[Figure][Figure][Figure][Figure][Figure][Figure]YY
80pd_command_deadlock_priorityY[Figure][Figure][Figure][Figure][Figure][Figure]YY
81pd_key_resource_typeY[Figure][Figure][Figure][Figure][Figure][Figure]NY
82pd_indexlock_modeY[Figure][Figure][Figure][Figure][Figure][Figure]NY
83pd_sql_object_cache_sizeY[Figure]YYYYYNY
84pd_def_buf_control_area_assignY[Figure][Figure][Figure][Figure][Figure][Figure]YY
85pd_thread_max_stack_sizeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
86pd_mlg_msg_log_unitY[Figure][Figure][Figure][Figure][Figure][Figure]NN
87pd_mlg_file_sizeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
88pd_statisticsY[Figure][Figure][Figure][Figure][Figure][Figure]YY
89pd_stj_file_sizeYY[Figure][Figure][Figure][Figure][Figure]N2Y
90pd_stj_buff_sizeYY[Figure][Figure][Figure][Figure][Figure]N2Y
91pd_rpc_traceYYYYYYYYY
92pd_rpc_trace_nameYYYYYYYYY
93pd_rpc_trace_sizeYYYYYYYYY
94pd_cancel_dumpYY[Figure][Figure][Figure][Figure][Figure]YY
95pd_client_waittime_over_abortY[Figure][Figure][Figure][Figure][Figure][Figure]YY
96pd_dump_suppress_watch_timeYY[Figure][Figure][Figure][Figure][Figure]YY
97pd_debug_info_netstatY[Figure][Figure][Figure][Figure][Figure][Figure]YY
98pd_spool_cleanup_intervalYY[Figure][Figure][Figure][Figure][Figure]YY
99pd_spool_cleanup_interval_levelYY[Figure][Figure][Figure][Figure][Figure]YY
100pd_spool_cleanupYY[Figure][Figure][Figure][Figure][Figure]YY
101pd_spool_cleanup_levelYY[Figure][Figure][Figure][Figure][Figure]YY
102pd_module_trace_maxYYYYYYYYY
103pd_module_trace_timer_levelYYYYYYYYY
104pd_max_rdarea_noY[Figure][Figure][Figure][Figure][Figure][Figure]NY
105pd_max_file_noY[Figure][Figure][Figure][Figure][Figure][Figure]Y1,2Y
106pd_rdarea_warning_pointY[Figure][Figure][Figure][Figure][Figure][Figure]YY
107pd_rdarea_open_attribute_useY[Figure][Figure][Figure][Figure][Figure][Figure]YY
108pd_rdarea_open_attributeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
109pd_shared_rdarea_useY[Figure][Figure][Figure][Figure][Figure][Figure]NY
110pd_dbbuff_lru_optionY[Figure][Figure][Figure][Figure][Figure][Figure]YY
111pd_dbbuff_modifyY[Figure][Figure][Figure][Figure][Figure][Figure]NN
112pd_dbbuff_lock_release_detectY[Figure][Figure][Figure][Figure][Figure][Figure]YY
113pd_dbbuff_lock_spn_countY[Figure][Figure][Figure][Figure][Figure][Figure]YY
114pd_dbbuff_lock_intervalY[Figure][Figure][Figure][Figure][Figure][Figure]YY
115pd_dbbuff_wait_intervalYY[Figure][Figure][Figure][Figure][Figure]YY
116pd_dbbuff_wait_spn_countYY[Figure][Figure][Figure][Figure][Figure]YY
117pd_dbbuff_rate_updpageY[Figure][Figure][Figure][Figure][Figure][Figure]YY
118pd_assurance_table_noY[Figure][Figure][Figure][Figure][Figure][Figure]Y3Y
119pd_assurance_index_noY[Figure][Figure][Figure][Figure][Figure][Figure]Y3Y
120pd_constraint_nameY[Figure][Figure][Figure][Figure][Figure][Figure]YY
121pd_check_pendingY[Figure][Figure][Figure][Figure][Figure][Figure]YY
122pd_large_file_useY[Figure][Figure][Figure][Figure][Figure][Figure]NY
123pd_ntfs_cache_disableY[Figure][Figure][Figure][Figure][Figure][Figure]YY
124pd_rorg_predictY[Figure][Figure][Figure][Figure][Figure][Figure]YY
125pd_auditYY[Figure][Figure][Figure][Figure][Figure]NN
126pd_aud_file_nameYY[Figure][Figure][Figure][Figure][Figure]YY
127pd_aud_max_generation_sizeYY[Figure][Figure][Figure][Figure][Figure]YY
128pd_aud_max_generation_numYY[Figure][Figure][Figure][Figure][Figure]YY
129pd_aud_no_standby_file_oprY[Figure][Figure][Figure][Figure][Figure][Figure]YY
130pd_aud_async_buff_sizeYY[Figure][Figure][Figure][Figure][Figure]YY
131pd_aud_async_buff_countYY[Figure][Figure][Figure][Figure][Figure]YY
132pd_aud_async_buff_retry_intvlYY[Figure][Figure][Figure][Figure][Figure]YY
133pd_aud_file_wrn_pntY[Figure][Figure][Figure][Figure][Figure][Figure]YY
134pd_haY[Figure][Figure][Figure][Figure][Figure][Figure]NN
135pd_ha_ipaddr_inheritYY[Figure][Figure][Figure][Figure][Figure]NN
136pd_ha_switch_timeoutYY[Figure][Figure][Figure][Figure][Figure]YY
137pd_ha_mgr_rerunY[Figure][Figure][Figure][Figure][Figure][Figure]YY
138pd_ha_transaction4Y[Figure][Figure][Figure][Figure][Figure][Figure]YY
139pd_ha_trn_queuing_wait_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
140pd_ha_trn_restart_retry_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
141pd_ha_resource_act_wait_timeYY[Figure][Figure][Figure][Figure][Figure]YY
142pd_rpl_init_startY[Figure][Figure][Figure][Figure][Figure][Figure]NN
143pd_rpl_reflect_modeY[Figure][Figure][Figure][Figure][Figure][Figure]NY
144pd_log_rpl_no_standby_file_oprY[Figure][Figure][Figure][Figure][Figure][Figure]YY
145pd_jp1_useY[Figure][Figure][Figure][Figure][Figure][Figure]NN
146pd_jp1_event_levelY[Figure][Figure][Figure][Figure][Figure][Figure]YY
147pd_jp1_event_msg_outY[Figure][Figure][Figure][Figure][Figure][Figure]YY
148pd_directory_serverY[Figure][Figure][Figure][Figure][Figure][Figure]YY
149pd_max_foreign_serverY[Figure][Figure][Figure][Figure][Figure][Figure]NY
150pd_oltp_holdcrY[Figure][Figure][Figure][Figure][Figure][Figure]YY
151pd_auto_vrupY[Figure][Figure][Figure][Figure][Figure][Figure]NN
152pd_sysdef_default_optionY[Figure][Figure][Figure][Figure][Figure][Figure]NY
153pd_service_portYY[Figure][Figure][Figure][Figure][Figure]YY
154pd_change_clt_ipaddrYY[Figure][Figure][Figure][Figure][Figure]YY
155pd_registered_portYY[Figure][Figure][Figure][Figure][Figure]NY
156pd_registered_port_checkYY[Figure][Figure][Figure][Figure][Figure]NY
157pd_registered_port_levelYY[Figure][Figure][Figure][Figure][Figure]NY
158pd_ipc_send_retrycountYY[Figure][Figure][Figure][Figure][Figure]YY
159pd_ipc_send_retrysleeptimeYY[Figure][Figure][Figure][Figure][Figure]YY
160pd_ipc_send_countYY[Figure][Figure][Figure][Figure][Figure]YY
161pd_ipc_recv_countYY[Figure][Figure][Figure][Figure][Figure]YY
162pd_ipc_conn_nblockY[Figure][Figure][Figure][Figure][Figure][Figure]YY
163pd_ipc_conn_nblock_timeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
164pd_ipc_conn_intervalY[Figure][Figure][Figure][Figure][Figure][Figure]YY
165pd_ipc_conn_countY[Figure][Figure][Figure][Figure][Figure][Figure]YY
166pd_ipc_inet_bufsizeYY[Figure][Figure][Figure][Figure][Figure]YY
167pd_tcp_inet_bufsizeYY[Figure][Figure][Figure][Figure][Figure]YY
168pd_utl_buff_sizeY[Figure][Figure][Figure][Figure][Figure][Figure]Y1Y1
169pd_sql_send_buff_sizeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
170pd_java_optionY[Figure][Figure][Figure][Figure][Figure][Figure]YY
171pd_java_routine_stack_sizeY[Figure][Figure][Figure][Figure][Figure][Figure]YY
172pd_java_archive_directoryYY[Figure][Figure][Figure][Figure][Figure]YY
173pd_java_classpathYY[Figure][Figure][Figure][Figure][Figure]YY
174pd_java_runtimepathYY[Figure][Figure][Figure][Figure][Figure]YY
175pd_java_libpathYY[Figure][Figure][Figure][Figure][Figure]YY
176pd_java_stdout_fileYYYYYYYYY
177pdunitY[Figure][Figure][Figure][Figure][Figure][Figure]NN
178pdstartY[Figure][Figure][Figure][Figure][Figure][Figure]NN
179pdbufferY[Figure][Figure][Figure][Figure][Figure][Figure]NY
180pdhagroupY[Figure][Figure][Figure][Figure][Figure][Figure]NN
181pdstbeginY[Figure][Figure][Figure][Figure][Figure][Figure]YY
182pdhibeginY[Figure][Figure][Figure][Figure][Figure][Figure]YY
183pdcltgrpY[Figure][Figure][Figure][Figure][Figure][Figure]YY
184pdpluginY[Figure][Figure][Figure][Figure][Figure][Figure]NN
185SHMMAXYY[Figure][Figure][Figure][Figure][Figure]YY
186TZY[Figure][Figure][Figure][Figure][Figure][Figure]YY
187pdmlgputY[Figure][Figure][Figure][Figure][Figure][Figure]YY
188pd_substr_lengthY[Figure][Figure][Figure][Figure][Figure][Figure]YY

Y: Yes, specification value can be modified.

N: No, specification valued cannot be modified.

[Figure]: 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 operandClient environment definition operand
pd_additional_optimize_levelPDADDITIONALOPTLVL
pd_cwaittime_wrn_pntPDCWAITTIMEWRNPNT
pd_delete_reserved_word_filePDDELRSVWDFILE
pd_hash_table_sizePDHASHTBLSIZE
pd_hashjoin_hashing_modePDHJHASHINGMODE
pd_optimize_levelPDSQLOPTLVL
pd_space_levelPDSPACELVL
pd_ha_transactionPDHATRNQUEUING
pd_uap_exerror_log_usePDUAPEXERLOGUSE
pd_uap_exerror_log_param_sizePDUAPEXERLOGPRMSZ