The system common definition defines the structure of the overall HiRDB system, as well as information that is common to all HiRDB system units. This section explains the formats used to specify the operands of a system common definition. Note that the numbers in the following table correspond to the numbers assigned to the explanations of the individual operands in 2.2 Operand explanations.
No. | Format |
---|---|
1 | set pd_system_id = HiRDB-identifier |
2 | [set pd_name_port = HiRDB-port-number] |
3 | set pd_master_file_name = "HiRDB-file-name-at-beginning-of-master-directory-RDAREA" |
4 | [set pd_system_expand_unit = unit-identifier[,unit-identifier]...] |
No. | Format |
---|---|
5 | [set pd_max_users = maximum-number-of-concurrent-connections] |
6 | [set pd_max_server_process = maximum-number-of-concurrently-activated-server-processes] |
7 | [set pd_max_access_tables = concurrently-accessible-base-tables-count] |
No. | Format |
---|---|
8 | [set pd_mode_conf = AUTO | MANUAL1 | MANUAL2] |
9 | [set pd_system_complete_wait_time = pdstart-command-completion-wait-time] |
10 | [set pd_start_time_out = HiRDB-start-preparation-maximum-wait-time] |
11 | [set pd_term_watch_count = maximum-number-of-successive-abnormal- terminations] |
No. | Format |
---|---|
12 | [set pd_start_level = 0 | 1] |
13 | [set pd_reduced_check_time = wait-time-for-reduced-activation-startup-notice] |
14 | [set pd_start_skip_unit = name-of-unit-not-to-be-started[,name-of-unit-not-to-be-started]...] |
No. | Format |
---|---|
15 | [set pd_dbsync_point = sync | commit] |
16 | [set pd_system_dbsync_point = sync | commit] |
17 | [set pd_process_terminator = resident | fixed | nonresident] |
18 | [set pd_process_terminator_max = maximum-number-of-resident-post-processing-processes] |
19 | [set pd_thdlock_wakeup_lock = Y | N] |
20 | [set pd_pageaccess_mode = SNAPSHOT | NORMAL] |
21 | [set pd_cmdhold_precheck = Y | N] |
22 | [set pd_db_io_error_action = dbhold | unitdown] |
23 | [set pd_connect_errmsg_hide = Y | N] |
24 | [set pd_cancel_down_msgchange = Y | N] |
No. | Format |
---|---|
25 | [set pd_max_recover_process = concurrently-executable-full-recovery-processes-count] |
26 | [set pd_redo_allpage_put = Y | N] |
No. | Format |
---|---|
27 | [set pd_trn_rerun_branch_auto_decide = Y | N] |
28 | [set pd_trn_send_decision_intval_sec = transmission-retry-interval-in-seconds-for-automatic-transaction-decision] |
29 | [set pd_trn_send_decision_interval = transmission-retry-interval-in-minutes-for-automatic-transaction-decision] |
30 | [set pd_trn_send_decision_retry_time = maximum-wait-time-for-transaction-auto-decision] |
31 | [set pd_trn_watch_time = maximum-communication-wait-time-during-transaction-synchronization-point-processing] |
32 | [set pd_trn_rcvmsg_store_buflen = transaction-recovery-message-queue-size] |
33 | [set pd_trn_commit_optimize = ONEPHASE | NOUSE] |
34 | [set pd_trn_rollback_watch_time = maximum-wait-time-for-rollback-completion-response[,rollback-instruction-resending-limit-time]] |
No. | Format |
---|---|
35 | [set pd_overflow_suppress = Y | N ] |
36 | [set pd_space_level = 0 | 1 | 3 ] |
37 | [set pd_dec_sign_normalize = Y | N ] |
38 | [set pd_sql_dec_op_maxprec = maximum-precision-for-a-DECIMAL-type-operation-result-not-exceeding-29-digits] |
39 | [set pd_sql_mode = 0 | 1] |
No. | Format |
---|---|
40 | [set pd_optimize_level = SQL-optimization-option[,SQL-optimization-option]...] |
41 | [set pd_additional_optimize_level = SQL-extension-optimizing-option[,SQL-extension-optimizing-option]...] |
42 | [set pd_hash_table_size = hash-table-size] |
43 | [set pd_work_table_option = work-table-processing-option] |
No. | Format |
---|---|
44 | [set pd_max_list_users = number-of-users-who-can-own-lists-concurrently] |
45 | [set pd_max_list_count = number-of-lists-created-per-user] |
46 | [set pd_list_initialize_timing = INITIAL | DEFER | STANDBY] |
No. | Format |
---|---|
47 | [set pd_utl_exec_time = utility-execution-monitoring-time] |
48 | [set pd_cmd_exec_time = period-for-monitoring-the-execution-time-of-operation-commands-and-utilities] |
49 | [set pd_queue_watch_time = message-queue-monitoring-time] |
50 | [set pd_queue_watch_timeover_action = continue | stop] |
51 | [set pd_cmd_process_conwaittime = period-for-monitoring-process-allocation-at-execution-of-an-operation-command-or-utility] |
52 | [set pd_down_watch_proc = upper-limit-for-server-process-abnormal-terminations[,monitoring-interval]] |
53 | [set pd_host_watch_interval = host-to-host-monitoring-interval] |
54 | [set pd_watch_resource = MANUAL | AUTO | DEFAULT] |
55 | [set pd_max_users_wrn_pnt = trigger-for-outputting-warning-message-related-to-number-of-connections-to-HiRDB-server[,trigger-for-resetting-warning-message-output-status]] |
56 | [set pd_max_access_tables_wrn_pnt = trigger-for-issuing-concurrently-accessible-base-tables-count-warning] |
57 | [set pd_max_rdarea_no_wrn_pnt = trigger-for-issuing-RDAREAs-count-warning] |
58 | [set pd_max_file_no_wrn_pnt = trigger-for-issuing-HiRDB-files-count-warning] |
59 | [set pdwork_wrn_pnt = trigger-for-issuing-work-table-files-warning] |
60 | [set pd_max_list_users_wrn_pnt = trigger-for-issuing-warning-about-number-of-users-who-have-created-lists] |
61 | [set pd_max_list_count_wrn_pnt = trigger-for-issuing-warning-about-number-of-lists-created-by-a-user] |
62 | [set pd_rdarea_list_no_wrn_pnt = trigger-for-issuing-warning-about-number-of-lists-created-at-server[,trigger-for-resetting-warning-output-status]] |
No. | Format |
---|---|
63 | [set pd_cwaittime_wrn_pnt = output-condition-for-SQL-runtime-warning-information (% specification) | output-condition-for-SQL-runtime-warning-information (time specification)] |
64 | [set pd_cwaittime_report_dir = SQL-runtime-warning-information-file-output-destination-directory] |
65 | [set pd_cwaittime_report_size = SQL-runtime-warning-information-file-maximum-size] |
No. | Format |
---|---|
66 | [set pd_uap_exerror_log_use = AUTO | YES | NO] |
67 | [set pd_uap_exerror_log_dir = SQL-error-report-file-storage-directory] |
68 | [set pd_uap_exerror_log_size = SQL-error-report-file-maximum-size] |
69 | [set pd_uap_exerror_log_param_size = maximum-data-size-of-parameter-information-to-be-output-to-client-error-log-file-and-SQL-error-report-file] |
No. | Format |
---|---|
70 | [set pd_delete_reserved_word_file = SQL-reserved-word-deletion-file-name-1[,SQL-reserved-word-deletion-file-name-2]...] |
No. | Format |
---|---|
71 | [set pd_sql_command_exec_users = authorization-identifier[,authorization-identifier]...] |
No. | Format |
---|---|
72 | [set pd_standard_sqlstate = Y | N] |
No. | Format |
---|---|
73 | [set pd_lck_deadlock_info = Y | N] |
74 | [set pd_lck_wait_timeout = lock-release-wait-time] |
75 | [set pd_nowait_scan_option = LOCK | NOLOCK] |
76 | [set pd_lck_queue_limit = trigger-for-issuing-warning-about-number-of-users-waiting-for-lock-release] |
77 | [set pd_deadlock_priority_use = Y | N] |
78 | [set pd_command_deadlock_priority = 32 | 64 | 96 | 120] |
79 | [set pd_key_resource_type = TYPE1 | TYPE2] |
80 | [set pd_indexlock_mode = {KEY | NONE}] |
81 | [set pd_lock_uncommited_delete_data = WAIT | NOWAIT] |
82 | [set pd_dbreuse_remaining_entries = ALL | NONE] |
83 | [set pd_lck_deadlock_check = Y | N] |
84 | [set pd_lck_deadlock_check_interval = deadlock-check-interval] |
No. | Format |
---|---|
85 | [set pd_sql_object_cache_size = SQL-object-buffer-size] |
86 | [set pd_def_buf_control_area_assign = INITIAL | TRAN] |
87 | [set pd_thread_max_stack_size = maximum-stack-size-for-use-by-one-thread] |
88 | [set pd_thread_stack_expand_size = stack-extension-size-per-thread] |
No. | Format |
---|---|
89 | [set pd_shmpool_attribute = free | fixed] |
90 | [set pd_shmpool_control = unit | server] |
91 | [set pd_dbbuff_attribute = free | fixed] |
No. | Format |
---|---|
92 | [set pd_mlg_msg_log_unit = manager | local] |
93 | [set pd_mlg_file_size = maximum-message-log-file-size] |
No. | Format |
---|---|
94 | [set pd_statistics = A | Y | N] |
95 | [set pd_stj_file_size = maximum-statistics-log-file-size] |
96 | [set pd_stj_buff_size = statistics-log-buffer-size] |
97 | [set pd_sqlobject_stat_timing = deallocate | tran] |
No. | Format |
---|---|
98 | [set pd_rpc_trace = Y | N] |
99 | [set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"] |
100 | [set pd_rpc_trace_size = RPC-trace-collection-file-size] |
No. | Format |
---|---|
101 | [set pd_prf_trace = Y | N] |
102 | [set pd_prf_level = 00000007 | 0000001f | 0000007f | 000001ff | 00000000] |
103 | [set pd_prf_file_count = number-of-performance-trace-information-file-generations] |
104 | [set pd_prf_file_size = size-of-each-performance-trace-information-file] |
No. | Format |
---|---|
105 | [set pd_cancel_dump = put | noput] |
106 | [set pd_client_waittime_over_abort = Y | N] |
107 | [set pd_clt_waittime_over_dump_level = all | shm_fesonly] |
108 | [set pd_dump_suppress_watch_time = troubleshooting-information-output-suppression-time] |
109 | [set pd_debug_info_netstat = Y | N] |
110 | [set pd_spool_cleanup_interval = troubleshooting-information-deletion-interval] |
111 | [set pd_spool_cleanup_interval_level = number-of-days[,deletion-type]] |
112 | [set pd_spool_cleanup = normal | force | no] |
113 | [set pd_spool_cleanup_level = number-of-days[,deletion-type]] |
114 | [set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored] |
115 | [set pd_module_trace_timer_level = 0 | 10 | 20] |
116 | [set pd_pth_trace_max = maximum-number-of-stored-communication-traces] |
No. | Format |
---|---|
117 | [set pd_max_rdarea_no = maximum-number-of-RDAREAs] |
118 | [set pd_max_file_no = maximum-number-of-HiRDB-files-comprising-an-RDAREA] |
119 | [set pd_rdarea_warning_point = segment-usage-ratio-1[,segment-usage-ratio-2[,segment-usage-ratio-3]]] |
120 | [set pd_rdarea_warning_point_msgout = Y | N] |
121 | [set pd_rdarea_extension_timing = use | nouse] |
122 | [set pd_rdarea_expand_format = Y | N] |
123 | [set pd_rdarea_open_attribute_use = Y | N] |
124 | [set pd_rdarea_open_attribute = INITIAL | DEFER | SCHEDULE] |
125 | [set pd_shared_rdarea_use = Y | N] |
126 | [set pd_db_access_error_action = dbhold | unitdown] |
127 | [set pd_db_hold_action = dbhold | unitdown] |
No. | Format |
---|---|
128 | [set pd_dbbuff_lru_option = SEPARATE | MIX] |
129 | [set pd_dbbuff_binary_data_lru = Y | N] |
130 | [set pd_dbbuff_modify = Y | N] |
131 | [set pd_dbbuff_rate_updpage = deferred-write-trigger-request-rate] |
132 | [set pd_dbbuff_trace_level = global-buffer-control-information-trace-acquisition-level] |
No. | Format |
---|---|
133 | [set pd_max_resident_rdarea_no = maximum-number-of-in-memory-RDAREAs] |
134 | [set pd_max_resident_rdarea_shm_no = maximum-number-of-shared-memory-segments-used-by-in-memory-data-buffer] |
No. | Format |
---|---|
135 | [set pd_assurance_table_no = table-reservation-count] |
136 | [set pd_assurance_index_no = index-reservation-count] |
No. | Format |
---|---|
139 | [set pd_max_temporary_object_no = maximum-number-of-temporary-tables-and-temporary-table-indexes-used-at-any-one-time] |
140 | [set pd_tmp_table_initialize_timing = STARTING | ACCESS] |
No. | Format |
---|---|
141 | [set pd_rorg_predict = Y | N] |
No. | Format |
---|---|
142 | [set pd_audit = Y | N] |
143 | [set pd_aud_file_name = HiRDB-file-system-area-name-for-audit-trail-file] |
144 | [set pd_aud_max_generation_size = audit-trail-file-maximum-size] |
145 | [set pd_aud_max_generation_num = maximum-audit-trail-file-count] |
146 | [set pd_aud_no_standby_file_opr = down | forcewrite] |
147 | [set pd_aud_async_buff_size = size-of-buffer-used-for-asynchronous-output-of-audit-trail-file] |
148 | [set pd_aud_async_buff_count = number-of-buffer-sectors-used-for-asynchronous-output-of-audit-trail-file] |
149 | [set pd_aud_async_buff_retry_intvl = retry-interval-for-allocation-of-a-buffer-to-be-used-for-asynchronous-output-of-audit-trail-file] |
150 | [set pd_aud_sql_source_size = size-of-SQL-statement-output-to-audit-trail] |
151 | [set pd_aud_sql_data_size = size-of-SQL-data-output-to-audit-trail] |
152 | [set pd_aud_file_wrn_pnt = warning-message-output-trigger[,trigger-for-resetting-warning-message-output-status]] |
153 | [set pd_aud_auto_loading = Y | N] |
154 | [pdaudload[-i index-creation-method] [-l log-acquisition-mode] [-n [batch-output-local-buffer-sector-count],, [random-access-local-buffer-sector-count]] [-y] [-X response-monitoring-time-for-server-to-server-communication]] |
155 | [set pd_security_host_group = host-name[,host-name]...] |
No. | Format |
---|---|
156 | [set pd_ha = use | nouse] |
157 | [set pd_ha_ipaddr_inherit = Y | N] |
158 | [set pd_ha_switch_timeout = Y | N] |
159 | [set pd_ha_prc_cleanup_check = Y | N] |
160 | [set pd_ha_mgr_rerun = wait | notwait] |
161 | [set pd_ha_transaction = error | queuing] |
162 | [set pd_ha_trn_queuing_wait_time = transaction-queuing-wait-time] |
163 | [set pd_ha_trn_restart_retry_time = retry-time-upper-limit-after-transaction-start-request-errors] |
164 | [set pd_ha_resource_act_wait_time = maximum-wait-time-for-resource-activation] |
No. | Format |
---|---|
165 | [set pd_rpl_init_start = Y | N] |
166 | [set pd_rpl_reflect_mode = server | uap] |
167 | [set pd_log_rpl_no_standby_file_opr = stop | continue] |
168 | [set pd_rpl_func_control = BACKWARD_CUTOFF_UPDATE | NONE] |
No. | Format |
---|---|
169 | [set pd_jp1_use = Y | N] |
170 | [set pd_jp1_event_level = 1 | 2] |
171 | [set pd_jp1_event_msg_out = Y | N] |
No. | Format |
---|---|
172 | [set pd_rise_use = Y | N] |
173 | [set pd_rise_pairvolume_combination = sync | async | hybrid | syssync] |
174 | [set pd_rise_disaster_mode = normal | alone] |
175 | [set pd_rise_fence_level = data | never] |
No. | Format |
---|---|
176 | [set pd_inner_replica_control = inner-replica-maximum-group-count] |
177 | [set pd_inner_replica_lock_shift = Y | N] |
178 | [set pd_lv_mirror_use = Y | N] |
179 | [set pd_inner_replica_hold_status = NORMAL | HOLD] |
180 | [set pd_max_reflect_process_count = number-of-processes-to-be-allocated-for-reflection-processing] |
181 | [set pd_log_org_reflected_logpoint = keep | release] |
182 | [set pd_log_org_no_standby_file_opr = stop | continue] |
No. | Format |
---|---|
183 | [set pd_oltp_holdcr = use | nouse] |
No. | Format |
---|---|
184 | [set pd_auto_vrup = Y | N] |
No. | Format |
---|---|
185 | [set pd_service_port = scheduler-process-port-number] |
186 | [set pd_name_fixed_port_lookup = Y | N] |
187 | [set pd_scd_port = scheduler-process-port-number] |
188 | [set pd_trn_port = transaction-server-process-port-number] |
189 | [set pd_mlg_port = message-log-server-process-port-number] |
190 | [set pd_alv_port =unit-monitoring-process-port-number] |
191 | [set pd_change_clt_ipaddr = 0 | 1 ] |
192 | [set pd_registered_port = "port-number-reservation-range"[,"port-number-reservation-range"]...] |
193 | [set pd_registered_port_check = Y | N | C | W] |
194 | [set pd_ipc_send_retrycount = process-to-process-send-retries-count] |
195 | [set pd_ipc_send_retrysleeptime = process-to-process-send-retry-sleep-time] |
196 | [set pd_ipc_send_count = server-to-server-send-retries-count] |
197 | [set pd_ipc_recv_count = server-to-server-receive-retries-count] |
198 | [set pd_ipc_conn_nblock = Y | N] |
199 | [set pd_ipc_conn_nblock_time = connection-establishment-monitoring-time-in-non-block-mode] |
200 | [set pd_ipc_clt_conn_nblock = Y | N] |
201 | [set pd_ipc_clt_conn_nblock_time = connection-establishment-monitoring-interval-in-non-block-mode-(communication-with-HiRDB-clients)] |
202 | [set pd_ipc_conn_interval = connection-establishment-retry-interval] |
203 | [set pd_ipc_conn_count = connection-establishment-retry-count] |
No. | Format |
---|---|
204 | [set pd_java_option = "Java-option"[,"Java-option"]...] |
205 | [set pd_java_routine_stack_size = stack-size-for-use-by-external-Java-routine] |
206 | [set pd_java_archive_directory = "JAR-file-storage-directory"] |
207 | [set pd_java_classpath = "Java-class-path"] |
208 | [set pd_java_runtimepath = "Java-Runtime-Environment-root-directory"] |
209 | [set pd_java_libpath = "Java-virtual-machine-library-directory"] |
210 | [set pd_java_stdout_file = "Java-virtual-machine-standard-output-and-standard-error-output-destination-file"] |
No. | Format |
---|---|
211 | [set pd_c_library_directory = "C-library-file-storage-directory"] |
No. | Format |
---|---|
212 | [set pd_substr_length = 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10] |
No. | Format |
---|---|
213 | [set pd_os_authenticate = Y | N] |
No. | Format |
---|---|
214 | {{pdunit -x host-name |
No. | Format |
---|---|
215 | {{pdstart -t server-type |
No. | Format |
---|---|
216 | [{{pdbuffer -a global-buffer-name |
No. | Format |
---|---|
217 | [pdhagroup -g HA-group-identifier -u unit-identifier[,unit-identifier]...] |
No. | Format |
---|---|
218 | [pdstbegin[-k statistical-information-type[,statistical-information-type]...] |
219 | [pdhibegin -k statistics-type[,statistics-type ]...] |
No. | Format |
---|---|
220 | {{[pdcltgrp -g client-group-name |
No. | Format |
---|---|
221 | {{[pdplugin -n plug-in-name]}} |
No. | Format |
---|---|
222 | [putenv HORCMINST RAID-Manager-instance-number] |
No. | Format |
---|---|
223 | [putenv SHMMAX maximum-shared-memory-segment-size] |
No. | Format |
---|---|
224 | [putenv TZ time-zone] |
No. | Format |
---|---|
225 | [pdmlgput -s output-selection |