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 operands explained in 2.2 Operands whose specification values can be changed and 2.3 Operand explanations.

For users who are creating HiRDB system definitions for the first time

The first step is to determine the values to be specified for the operands shown in boldface type. In principle, HiRDB can be started once the boldface operands have been specified.

No.	Format	Operand category
1	set pd_system_id = HiRDB-identifier	System structure
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_max_users = maximum number of concurrent connections]	Maximum concurrent executions
5	[set pd_max_server_process = maximum-number-of-concurrently-activated-server-processes]
6	[set pd_max_access_tables = concurrently-accessible-base-tables-count]
7	[set pd_utl_exec_mode = 0 | 1 ]
8	[set pd_max_commit_write_reclaim_no = maximum-number-of-concurrent-executions-of-pdreclaim-commands-with-p-option-specified]
9	[set pd_mode_conf = AUTO | MANUAL1 | MANUAL2]	HiRDB startup
10	[set pd_system_complete_wait_time = pdstart-command-completion-wait-time]
11	[set pd_start_time_out = HiRDB-start-preparation-maximum-wait-time]
12	[set pd_term_watch_count = maximum-number-of-successive-abnormal- terminations]
13	[set pd_start_level = 0 | 1 ]	Reduced activation
14	[set pd_reduced_check_time = wait-time-for-reduced-activation-startup-notice]
15	[set pd_start_skip_unit = name-of-unit-not-to-be-started [,name-of-unit-not-to-be-started]...]
16	[set pd_dbsync_point = sync | commit]	HiRDB processing
17	[set pd_system_dbsync_point = sync | commit]
18	[set pd_dbsync_altwrite_skip = Y | N ]
19	[set pd_overflow_suppress = Y | N ]
20	[set pd_process_terminator = resident | fixed | nonresident]
21	[set pd_process_terminator_max = maximum-number-of-resident-post-processing-processes]
22	[set pd_space_level = 0 | 1 | 3 ]
23	[set pd_dec_sign_normalize = Y | N ]
24	[set pd_server_entry_queue = spnfifo | fifo | loop]
25	[set pd_thdlock_sleep_func = 0 | 1]
26	[set pd_thdlock_wakeup_lock = Y | N]
27	[set pd_thdlock_pipe_retry_interval = thread-lock-release-check-interval]
28	[set pd_thdlock_retry_time = thread-lock-sleep-time]
29	[set pd_thdspnlk_spn_count = thread-spin-lock-spin-count]
30	[set pd_pageaccess_mode = SNAPSHOT | NORMAL]
31	[set pd_cmdhold_precheck = Y | N]
32	[set pd_db_io_error_action = dbhold | unitdown]
33	[set pd_connect_errmsg_hide = Y | N]
34	[set pd_cancel_down_msgchange = Y | N]
35	[set pd_max_recover_process = concurrently-executable-full-recovery-processes-count]	Full recovery processing
36	[set pd_redo_allpage_put= Y | N]
37	[set pd_trn_rerun_branch_auto_decide = Y | N]	Transaction decision processing
38	[set pd_trn_send_decision_intval_sec = transmission-retry-interval-in-seconds-for-automatic-transaction-decision]
39	[set pd_trn_send_decision_interval = transmission-retry-interval-in-minutes-for-automatic-transaction-decision]
40	[set pd_trn_send_decision_retry_time = maximum-wait-time-for-transaction-auto-decision]
41	[set pd_trn_watch_time = maximum-communication-wait-time-during-transaction-synchronization-point-processing]
42	[set pd_trn_commit_optimize = ONEPHASE | NOUSE]
43	[set pd_optimize_level = SQL-optimization-option [,SQL-optimization-option]...]	SQL optimization
44	[set pd_additional_optimize_level = SQL-extension-optimizing-option [,SQL-extension-optimizing-option]...]
45	[set pd_hashjoin_hashing_mode = TYPE1 | TYPE2]
46	[set pd_hash_table_size = hash-table-size]
47	[set pd_work_table_option = work-table-processing-option]
48	[set pd_max_list_users = number-of-users-who-can-own-lists-concurrently]	Narrowed retrieval
49	[set pd_max_list_count = number-of-lists-created-per-user]
50	[set pd_list_initialize_timing = INITIAL | DEFER | STANDBY]
51	[set pd_utl_exec_time = utility-execution-monitoring-time]	System monitoring
52	[set pd_watch_time = SQL-maximum-execution-time]
53	[set pd_queue_watch_time = message-queue-monitoring-time]
54	[set pd_queue_watch_timeover_action = continue | stop]
55	[set pd_down_watch_proc = upper-limit-for-server-process-abnormal-terminations[,monitoring-interval]]
56	[set pd_host_watch_interval = host-to-host-monitoring-interval]
57	[set pd_watch_resource = MANUAL | AUTO]
58	[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]]
59	[set pd_max_access_tables_wrn_pnt = trigger-for-issuing-concurrently-accessible-base-tables-count-warning]
60	[set pd_max_rdarea_no_wrn_pnt = trigger-for-issuing-RDAREAs-count-warning]
61	[set pd_max_file_no_wrn_pnt = trigger-for-issuing-HiRDB-files-count-warning]
62	[set pdwork_wrn_pnt = trigger-for-issuing-work-table-files-warning]
63	[set pd_max_list_users_wrn_pnt = trigger-for-issuing-warning-about-number-of-users-who-have-created-lists]
64	[set pd_max_list_count_wrn_pnt = trigger-for-issuing-warning-about-number-of-lists-created-by-a-user]
65	[set pd_rdarea_list_no_wrn_pnt = trigger-for-issuing-warning-about-number-of-lists-created-at-server[,trigger-for-resetting-warning-output-status]]
66	[set pd_cwaittime_wrn_pnt = output-condition-for-SQL-runtime-warning-information (% specification) | output-condition-for-SQL-runtime-warning-information (time specification)]	SQL runtime warning output facility
67	[set pd_cwaittime_report_dir = SQL-runtime-warning-information-file-output-destination-directory]
68	[set pd_cwaittime_report_size = SQL-runtime-warning-information-file-maximum-size]
69	[set pd_uap_exerror_log_use = YES | NO]	Facility for output of extended SQL error information
70	[set pd_uap_exerror_log_dir = SQL-error-report-file-storage-directory]
71	[set pd_uap_exerror_log_size = SQL-error-report-file-maximum-size]
72	[set pd_uap_exerror_log_param_size = maximum-data-size-of-parameter-information-to-be-output-to-error-log-file-and-SQL-error-report-file]
73	[set pd_delete_reserved_word_file = SQL-reserved-word-deletion-file-name-1[,SQL-reserved-word-deletion-file-name-2]...]	SQL reserved word deletion facility
74	[set pd_lck_deadlock_info = Y | N]	Lock
75	[set pd_lck_wait_timeout = lock-release-wait-time]
76	[set pd_lck_release_detect = interval | pipe]
77	[set pd_lck_release_detect_interval = lock-release-detection-interval]
78	[set pd_nowait_scan_option = LOCK | NOLOCK]
79	[set pd_lck_queue_limit = trigger-for-issuing-warning-about-number-of-users-waiting-for-lock-release]
80	[set pd_deadlock_priority_use = Y | N]
81	[set pd_command_deadlock_priority = 32 | 64 | 96 | 120]
82	[set pd_key_resource_type = TYPE1 | TYPE2]
83	[set pd_indexlock_mode = {KEY | NONE}]
84	[set pd_sql_object_cache_size = SQL-object-buffer-size]	Buffers
85	[set pd_def_buf_control_area_assign = INITIAL | TRAN]
86	[set pd_thread_max_stack_size = maximum-stack-size-for-use-by-one-thread]
87	[set pd_shmpool_attribute = free | fixed]	Shared memory
88	[set pd_dbbuff_attribute = free | fixed]
89	[set pd_mlg_msg_log_unit = manager | local]	Message log files
90	[set pd_mlg_file_size = maximum-message-log-file-size]
91	[set pd_statistics = Y | N]	Statistical information
92	[set pd_stj_file_size = maximum-statistics-log-file-size]
93	[set pd_stj_buff_size = statistics-log-buffer-size]
94	[set pd_rpc_trace = Y | N]	RPC trace information
95	[set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"]
96	[set pd_rpc_trace_size = RPC-trace-collection-file-size]
97	[set pd_cancel_dump = put | noput]	Troubleshooting information
98	[set pd_client_waittime_over_abort = Y | N]
99	[set pd_dump_suppress_watch_time = troubleshooting-information-output-suppression-time]
100	[set pd_debug_info_netstat = Y | N]
101	[set pd_spool_cleanup_interval = troubleshooting-information-deletion-interval]
102	[set pd_spool_cleanup_interval_level = number-of-days[, deletion-type]]
103	[set pd_spool_cleanup = normal | force | no]
104	[set pd_spool_cleanup_level = number-of-days [,deletion-type]]
105	[set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored]
106	[set pd_module_trace_timer_level = module-trace-output-time-acquisition-method]
107	[set pd_max_rdarea_no = maximum-number-of-RDAREAs]	RDAREAs
108	[set pd_max_file_no = maximum-number-of-HiRDB-files-comprising-an-RDAREA]
109	[set pd_rdarea_warning_point = segment-usage-ratio-1 [,segment-usage-ratio-2 [,segment-usage-ratio-3]] ]
110	[set pd_rdarea_open_attribute_use = Y | N]
111	[set pd_rdarea_open_attribute = INITIAL | DEFER | SCHEDULE]
112	[set pd_shared_rdarea_use = Y | N]
113	[set pd_dbbuff_lru_option = SEPARATE | MIX]	Global buffers
114	[set pd_dbbuff_modify = Y | N]
115	[set pd_dbbuff_lock_release_detect = pipe | interval]
116	[set pd_dbbuff_lock_spn_count = number-of-spins-during-lock-acquisition-wait-processing]
117	[set pd_dbbuff_lock_interval = interval-during-lock-acquisition-wait-processing]
118	[set pd_dbbuff_wait_interval = global-buffer-occupation-state-check-interval]
119	[set pd_dbbuff_wait_spn_count = maximum-spin-loop-count-for-global-buffer-occupation-state-checking]
120	[set pd_dbbuff_rate_updpage = deferred-write-trigger-request-rate]
121	[set pd_assurance_table_no = minimum-guaranteed-tables-count]	Table or index reservation count
122	[set pd_assurance_index_no = minimum-guaranteed-indexes-count]
123	[set pd_constraint_name = LEADING | TRAILING]	Referential and check constraints
124	[set pd_check_pending = USE | NOUSE]
125	[set pd_large_file_use = Y | N]	HiRDB file system areas
126	[set pd_rorg_predict = Y | N]	Facility for predicting reorganization time
127	[set pd_audit = Y | N]	Security audit facility
128	[set pd_aud_file_name = HiRDB-file-system-area-name-for-audit-trail-file]
129	[set pd_aud_max_generation_size = audit-trail-file-maximum-size]
130	[set pd_aud_max_generation_num = maximum-audit-trail-file-count]
131	[set pd_aud_no_standby_file_opr = down | forcewrite]
132	[set pd_aud_async_buff_size = size-of-buffer-used-for-asynchronous-output-of-audit-trail-file]
133	[set pd_aud_async_buff_count = number-of-buffer-sectors-used-for-asynchronous-output-of-audit-trail-file]
134	[set pd_aud_async_buff_retry_intvl = retry-interval-for-allocation-of-a-buffer-to-be-used-for-asynchronous-output-of-audit-trail-file]
135	[set pd_aud_file_wrn_pnt = warning-message-output-trigger[,trigger-for-resetting-warning-message-output-status]]
136	[set pd_ha = use | nouse]	System switchover facility
137	[set pd_ha_ipaddr_inherit = Y | N]
138	[set pd_ha_switch_timeout = Y | N]
139	[set pd_ha_prc_cleanup_check = Y | N]
140	[set pd_ha_mgr_rerun = wait | notwait]
141	[set pd_ha_transaction = error | queuing]
142	[set pd_ha_trn_queuing_wait_time = transaction-queuing-wait-time]
143	[set pd_ha_trn_restart_retry_time = retry-time-upper-limit-after-transaction-start-request-errors]
144	[set pd_ha_resource_act_wait_time = maximum-wait-time-for-resource-activation]
145	[set pd_rpl_init_start = Y | N]	HiRDB Datareplicator
146	[set pd_rpl_reflect_mode = server | uap]
147	[set pd_log_rpl_no_standby_file_opr = stop | continue]
148	[set pd_jp1_use = Y | N]	Linkage to JP1
149	[set pd_jp1_event_level = 1 | 2]
150	[set pd_jp1_event_msg_out = Y | N]
151	[set pd_directory_server = sods]	Directory Server linkage facility
152	[set pd_rise_use = Y | N]	Real Time SAN Replication
153	[set pd_rise_pairvolume_combination = sync | async | hybrid | syssync]
154	[set pd_rise_disaster_mode = normal | alone]
155	[set pd_rise_fence_level = data | never]
156	[set pd_inner_replica_control = inner-replica-maximum-group-count]	Inner replica facility
157	[set pd_lv_mirror_use = Y | N]
158	[set pd_max_reflect_process_count = number-of-processes-to-be-allocated-for-reflection-processing]
159	[set pd_log_org_reflected_logpoint = keep | release]
160	[set pd_log_org_no_standby_file_opr = stop | continue]
161	[set pd_max_foreign_server = foreign-server-maximum-count]	HiRDB External Data Access facility
162	[set pd_oltp_holdcr = use | nouse]	OLTP
163	[set pd_auto_vrup = Y | N]	Version upgrade
164	[set pd_sysdef_default_option = recommendable | v6compatible | v7compatible]
165	[set pd_service_port = port-number-for-high-speed-connection-from-client]	Communication processing
166	[set pd_change_clt_ipaddr = 0 | 1 ]
167	[set pd_registered_port = "port-number-reservation-range" [,"port-number-reservation-range"]...]
168	[set pd_registered_port_check = Y | N | C | W]
169	[set pd_registered_port_level = 0 | 1]
170	[set pd_ipc_send_retrycount = process-to-process-send-retries-count]
171	[set pd_ipc_send_retrysleeptime = process-to-process-send-retry-sleep-time]
172	[set pd_ipc_send_count = server-to-server-send-retries-count]
173	[set pd_ipc_recv_count = server-to-server-receive-retries-count]
174	[set pd_ipc_conn_nblock = Y | N]
175	[set pd_ipc_conn_nblock_time = connection-establishment-monitoring-time-in-non-block-mode]
176	[set pd_ipc_conn_interval = connection-establishment-retry-interval]
177	[set pd_ipc_conn_count = connection-establishment-retry-count]
178	[set pd_ipc_inet_bufsize = send-receive-buffer-size-for-server-unit-to-unit-communication]
179	[set pd_ipc_unix_bufsize = send-receive-buffer-size-for-communication-within-server-unit]
180	[set pd_tcp_inet_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-outside-host-where-HiRDB-server-resides]
181	[set pd_tcp_unix_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-inside-host-where-HiRDB-server-resides]
182	[set pd_utl_buff_size = utility-communication-buffer-size]
183	[set pd_sql_send_buff_size = buffer-size-for-inter-server-communication-for-SQL-execution]
184	[set pd_ipc_tcp_nodelayack = Y | N]
185	[set pd_java_option = "Java-option" [,"Java-option"]... ]	Java
186	[set pd_java_routine_stack_size = stack-size-for-use-by-Java-routine]
187	[set pd_java_archive_directory = "JAR-file-storage-directory"]
188	[set pd_java_classpath = "Java-class-path"]
189	[set pd_java_runtimepath = "Java-Runtime-Environment-root-directory"]
190	[set pd_java_libpath = "Java-virtual-machine-library-directory"]
191	[set pd_java_stdout_file = "Java-virtual-machine-standard-output-and-standard-error-output-destination-file"]
192	{{ pdunit -x host-name -u unit-identifier [-d "HiRDB-directory-name"] [-c host-name] [-p port-number]}}	Unit structure
193	{{ pdstart -t server-type [-s server-name] -x host-name | -u unit-identifier [-m host-name[,host-name]... [-n host-name[,host-name]...]] [-c server-name | -g HA-group-identifier] [-k stls]}}	Server structure
194	[{{ pdbuffer -a global buffer-name {-r RDAREA-name[,RDAREA-name]... | -b RDAREA-name [,RDAREA-name]... | -o | -i authorization-identifier.index-identifier} -n buffer-sectors-count[-l buffer-size] [-m maximum-concurrently-executable-prefetches-count] [-p maximum-batch-input-pages-count] [-w updated-pages-output-rate-during-deferred-write-trigger] [-c] [-y update-buffer-sectors-count-for-deferred-write-trigger-event]}}]	Global buffers
195	[pdhagroup -g HA-group-identifier -u unit-identifier[,unit-identifier]...]	HA groups
196	[pdstbegin[-k statistical-information-type[,statistical-information-type ]...] [-m interval] [{-x host-name | -u unit-identifier }] [{ -a | -s server-name[, server-name ]...}]]	Statistical information
197	[ pdhibegin -k statistics-type[,statistics-type ]...]
198	{{[pdcltgrp -g client-group-name -u guaranteed-number-of-connected-users-per-group]}}	Client group
199	{{[pdplugin -n plug-in-name]}}	Plug-ins
200	[putenv HORCMINST RAID-Manager-instance-number]	Real Time SAN Replication
201	[putenv SHMMAX maximum-shared-memory-segment-size]	Shared memory
202	[putenv TZ time-zone]	Date and time
203	[pdmlgput -s output-selection {-c ALL | -m message-ID[,message-ID]...}]	Message output suppression facility
204	[set pd_substr_length = 3 | 4 | 5 | 6]	Character encoding