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