Scalable Database Server, HiRDB Version 8 System Definition

[Contents][Index][Back][Next]

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. 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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
2 pd_name_port Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
3 pd_master_file_name Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
4 pd_max_users Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
5 pd_max_server_process Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
6 pd_max_access_tables Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
7 pd_utl_exec_mode Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
8 pd_max_commit_write_reclaim_no Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
9 pd_mode_conf Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
10 pd_system_complete_wait_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
11 pd_start_time_out Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
12 pd_start_level Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
13 pd_reduced_check_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
14 pd_start_skip_unit Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
15 pd_start_skip_unit Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
16 pd_dbsync_point Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
17 pd_system_dbsync_point Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
18 pd_overflow_suppress Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
19 pd_process_terminator Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
20 pd_process_terminator_max Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
21 pd_space_level4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
22 pd_dec_sign_normalize Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
23 pd_server_entry_queue Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
24 pd_thdlock_sleep_func Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
25 pd_thdlock_wakeup_lock Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
26 pd_thdlock_pipe_retry_interval Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
27 pd_thdlock_retry_time Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
28 pd_thdspnlk_spn_count Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
29 pd_pageaccess_mode Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
30 pd_cmdhold_precheck Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
31 pd_db_io_error_action Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
32 pd_connect_errmsg_hide Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
33 pd_cancel_down_msgchange Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
34 pd_max_recover_process Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
35 pd_redo_allpage_put Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
36 pd_trn_rerun_branch_auto_decide Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
37 pd_trn_send_decision_intval_sec Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
38 pd_trn_send_decision_interval Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
39 pd_trn_send_decision_retry_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
40 pd_trn_watch_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
41 pd_trn_commit_optimize Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
42 pd_optimize_level4 Y [Figure] [Figure] [Figure] Y [Figure] [Figure] Y Y
43 pd_additional_optimize_level4 Y [Figure] [Figure] [Figure] Y [Figure] [Figure] Y Y
44 pd_hashjoin_hashing_mode4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
45 pd_hash_table_size4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
46 pd_work_table_option Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
47 pd_max_list_users Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N2 Y
48 pd_max_list_count Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
49 pd_list_initialize_timing Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
50 pd_utl_exec_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
51 pd_watch_time Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
52 pd_queue_watch_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
53 pd_queue_watch_timeover_action Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
54 pd_down_watch_proc Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
55 pd_host_watch_interval Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
56 pd_watch_resource Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
57 pd_max_users_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
58 pd_max_access_tables_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
59 pd_max_rdarea_no_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
60 pd_max_file_no_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
61 pdwork_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
62 pd_max_list_users_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
63 pd_max_list_count_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
64 pd_rdarea_list_no_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
65 pd_cwaittime_wrn_pnt4 Y [Figure] [Figure] Y Y [Figure] [Figure] Y Y
66 pd_cwaittime_report_dir Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
67 pd_cwaittime_report_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
68 pd_uap_exerror_log_use4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
69 pd_uap_exerror_log_dir Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
70 pd_uap_exerror_log_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
71 pd_uap_exerror_log_param_size4 Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
72 pd_delete_reserved_word_file4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
73 pd_lck_deadlock_info Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
74 pd_lck_wait_timeout Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
75 pd_lck_release_detect Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
76 pd_lck_release_detect_interval Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
77 pd_nowait_scan_option Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
78 pd_lck_queue_limit Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
79 pd_deadlock_priority_use Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
80 pd_command_deadlock_priority Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
81 pd_key_resource_type Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
82 pd_indexlock_mode Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
83 pd_sql_object_cache_size Y [Figure] Y Y Y Y Y N Y
84 pd_def_buf_control_area_assign Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
85 pd_thread_max_stack_size Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
86 pd_mlg_msg_log_unit Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
87 pd_mlg_file_size Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
88 pd_statistics Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
89 pd_stj_file_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N2 Y
90 pd_stj_buff_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] 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 [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
95 pd_client_waittime_over_abort Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
96 pd_dump_suppress_watch_time Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
97 pd_debug_info_netstat Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
98 pd_spool_cleanup_interval Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
99 pd_spool_cleanup_interval_level Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
100 pd_spool_cleanup Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
101 pd_spool_cleanup_level Y Y [Figure] [Figure] [Figure] [Figure] [Figure] 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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
105 pd_max_file_no Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y1,2 Y
106 pd_rdarea_warning_point Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
107 pd_rdarea_open_attribute_use Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
108 pd_rdarea_open_attribute Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
109 pd_shared_rdarea_use Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
110 pd_dbbuff_lru_option Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
111 pd_dbbuff_modify Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
112 pd_dbbuff_lock_release_detect Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
113 pd_dbbuff_lock_spn_count Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
114 pd_dbbuff_lock_interval Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
115 pd_dbbuff_wait_interval Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
116 pd_dbbuff_wait_spn_count Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
117 pd_dbbuff_rate_updpage Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
118 pd_assurance_table_no Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y3 Y
119 pd_assurance_index_no Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y3 Y
120 pd_constraint_name Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
121 pd_check_pending Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
122 pd_large_file_use Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
123 pd_ntfs_cache_disable Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
124 pd_rorg_predict Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
125 pd_audit Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N N
126 pd_aud_file_name Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
127 pd_aud_max_generation_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
128 pd_aud_max_generation_num Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
129 pd_aud_no_standby_file_opr Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
130 pd_aud_async_buff_size Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
131 pd_aud_async_buff_count Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
132 pd_aud_async_buff_retry_intvl Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
133 pd_aud_file_wrn_pnt Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
134 pd_ha Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
135 pd_ha_ipaddr_inherit Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N N
136 pd_ha_switch_timeout Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
137 pd_ha_mgr_rerun Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
138 pd_ha_transaction4 Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
139 pd_ha_trn_queuing_wait_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
140 pd_ha_trn_restart_retry_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
141 pd_ha_resource_act_wait_time Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
142 pd_rpl_init_start Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
143 pd_rpl_reflect_mode Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
144 pd_log_rpl_no_standby_file_opr Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
145 pd_jp1_use Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
146 pd_jp1_event_level Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
147 pd_jp1_event_msg_out Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
148 pd_directory_server Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
149 pd_max_foreign_server Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
150 pd_oltp_holdcr Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
151 pd_auto_vrup Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
152 pd_sysdef_default_option Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
153 pd_service_port Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
154 pd_change_clt_ipaddr Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
155 pd_registered_port Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N Y
156 pd_registered_port_check Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N Y
157 pd_registered_port_level Y Y [Figure] [Figure] [Figure] [Figure] [Figure] N Y
158 pd_ipc_send_retrycount Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
159 pd_ipc_send_retrysleeptime Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
160 pd_ipc_send_count Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
161 pd_ipc_recv_count Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
162 pd_ipc_conn_nblock Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
163 pd_ipc_conn_nblock_time Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
164 pd_ipc_conn_interval Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
165 pd_ipc_conn_count Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
166 pd_ipc_inet_bufsize Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
167 pd_tcp_inet_bufsize Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
168 pd_utl_buff_size Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y1 Y1
169 pd_sql_send_buff_size Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
170 pd_java_option Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
171 pd_java_routine_stack_size Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
172 pd_java_archive_directory Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
173 pd_java_classpath Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
174 pd_java_runtimepath Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
175 pd_java_libpath Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
176 pd_java_stdout_file Y Y Y Y Y Y Y Y Y
177 pdunit Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
178 pdstart Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
179 pdbuffer Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N Y
180 pdhagroup Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
181 pdstbegin Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
182 pdhibegin Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
183 pdcltgrp Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
184 pdplugin Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] N N
185 SHMMAX Y Y [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
186 TZ Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
187 pdmlgput Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y
188 pd_substr_length Y [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] Y Y

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 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