2.1 Operand formats

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.FormatOperand category
1set pd_system_id = HiRDB-identifierSystem structure
2[set pd_name_port = HiRDB-port-number]
3set 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
  -u unit-identifier
 [-d "HiRDB-directory-name"]
 [-c host-name]
 [-p port-number]}}

Unit structure
178

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

[{{ 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
180

[pdhagroup -g HA-group-identifier -u unit-identifier[,unit-identifier]...]

HA groups
181

[pdstbegin[-k statistical-information-type[,statistical-information-type ]...]
   [-m interval]
   [{-x host-name | -u unit-identifier }]
   [{ -a | -s server-name[, server-name ]...}]]

Statistical information
182

[ pdhibegin -k statistics-type[,statistics-type ]...]

183

{{[pdcltgrp -g client-group-name
   -u guaranteed-number-of-connected-users-per-group]}}

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