5.1 Operand formats

A single server definition defines information for a single server. This section explains the formats used to specify the operands of a single server definition. Note that the numbers in the following table correspond to the numbers assigned to the operands explained in 5.2 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.
Organization of this section
(1) Processes
(2) Work tables
(3) System monitoring
(4) SQL runtime warning output facility
(5) Facility for output of extended SQL error information
(6) Lock
(7) Buffers
(8) Shared memory
(9) RPC trace information
(10) Troubleshooting information
(11) Global buffers
(12) Temporary tables
(13) Security
(14) Delayed batch creation of plug-in index
(15) Java
(16) System log files
(17) Synchronization point dump files
(18) Server status files
(19) Server status files (when an error occurs)
(20) Work table files
(21) System log file configuration
(22) Synchronization point dump file configuration
(23) Plug-ins

(1) Processes

No.Format
1[set pd_process_count = resident-processes-count[, resident-processes-count-at-server-startup]]#
2[set pd_server_cleanup_interval = interval-for-stopping-nonresident-server-processes]#
3[set pd_svr_castoff_size = maximum-memory-size-used-by-server-process]#
4[set pd_max_open_fds = maximum-number-of-files-and-pipes-accessed-by-process]
5[set pd_max_ard_process = asynchronous-READ-process-count]#
6[set pd_dfw_awt_process = number-of-parallel-writes-for-deferred-write-processing]

(2) Work tables

No.Format
7[set pd_work_buff_mode = each | pool]#
8[set pd_work_buff_size = work-table-buffer-size]#
9[set pd_work_buff_expand_limit = work-table-buffer-expansion-limit]#

(3) System monitoring

No.Format
10[set pd_watch_pc_client_time = maximum-client-request-wait-time]#
11[set pd_spd_syncpoint_skip_limit = maximum-number-of-skipped-synchronization-point-dumps]#
12[set pd_dfw_syncpoint_skip_limit = maximum-number-of-skipped-synchronization-point-dumps-resulting-from-delay-of-synchronization-point-dump-acquisition-due-to-deferred-write-processing]#

(4) SQL runtime warning output facility

No.Format
13[set pd_cwaittime_wrn_pnt = output-condition-for-SQL-runtime-warning-information (% specification) | output-condition-for-SQL-runtime-warning-information (time specification)]#

(5) Facility for output of extended SQL error information

No.Format
14[set pd_uap_exerror_log_use = AUTO | YES | NO]#

(6) Lock

No.Format
15[set pd_lck_pool_size = server-lock-pool-size]#
16[set pd_lck_pool_partition = per-server-lock-pool-partition-count]#
17[set pd_lck_until_disconnect_cnt = total-number-of-tables-and-RDAREAs-to-be-locked-per-server-UNTIL-DISCONNECT-specification]#
18[set pd_max_open_holdable_cursors = maximum-number-of-holdable-cursors-that-can-be-concurrently-open-when-LOCK-statement-with-UNTIL-DISCONNECT-specification-is-not-executed]#
19[set pd_lck_hash_entry = lock-pool-hash-entry-count]#

(7) Buffers

No.Format
20[set pd_sql_object_cache_size = SQL-object-buffer-size]#
21[set pd_table_def_cache_size = table-definition-information-buffer-size]#
22[set pd_auth_cache_size = user-privilege-information-buffer-size]#
23[set pd_view_def_cache_size = view-analysis-information-buffer-size]#
24[set pd_type_def_cache_size = user-defined-type-information-buffer-size]#
25[set pd_routine_def_cache_size = routine-definition-information-buffer-size]#
26[set pd_registry_cache_size = registry-information-buffer-size]#

(8) Shared memory

No.Format
27[set pd_sds_shmpool_size = single-server-shared-memory-size]#

(9) RPC trace information

No.Format
28[set pd_rpc_trace = Y | N]#
29[set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"]#
30[set pd_rpc_trace_size = RPC-trace-collection-file-size]#

(10) Troubleshooting information

No.Format
31[set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored]#
32[set pd_module_trace_timer_level = 0 | 10 | 20]#
33[set pd_pth_trace_max = maximum-number-of-stored-communication-traces]#

(11) Global buffers

No.Format
34[set pd_max_add_dbbuff_no = maximum-global-buffers-count-for-dynamic-addition]#
35[set pd_max_add_dbbuff_shm_no = maximum-shared-memory-segments-count-for-dynamic-addition]#

(12) Temporary tables

No.Format
36[set pd_max_temporary_object_no = maximum-number-of-temporary-tables-and-temporary-table-indexes-used-at-any-one-time]#

(13) Security

No.Format
37[set pd_audit_def_buffer_size = security-audit-information-buffer-length]#

(14) Delayed batch creation of plug-in index

No.Format
38[set pd_plugin_ixmk_dir = "index-information-file-creation-directory-name" or "index-information-file-creation-HiRDB-file-system-area-name"]

(15) Java

No.Format
39[set pd_java_stdout_file = "Java-virtual-machine-standard-output-or-standard-error-output-destination-file"]#
40[set pd_java_castoff = Y | N]#

(16) System log files

No.Format
41[set pd_log_dual = Y | N]#
42[set pd_log_dual_write_method = serial | parallel]
43set pd_log_remain_space_check = warn | safe]#
44[set pd_log_auto_unload_path = "unload-log-file-output-directory"[,"unload-log-file-output-directory"]...]
45[set pd_log_auto_unload_restart = Y | N]#
46[set pd_log_singleoperation = Y | N]#
47[set pd_log_rerun_reserved_file_open = Y | N]#
48[set pd_log_rerun_swap = Y | N]#
49[set pd_log_swap_timeout = wait-time-for-completion-of-system-log-file-swapping]#
50[set pd_log_unload_check = Y | N]#
51[set pd_log_write_buff_count = log-output-buffer-sectors-count]#
52[set pd_log_auto_expand_size = extension-amount-per-system-log-file-extension-trigger[,extension-limit]]#

(17) Synchronization point dump files

No.Format
53[set pd_spd_dual = Y | N]#
54[set pd_spd_assurance_msg = Y | N]#
55[set pd_spd_assurance_count = number-of-guaranteed-valid-generations]#
56[set pd_spd_reduced_mode = reduced-mode-operation-option]#
57[set pd_spd_reserved_file_auto_open = Y | N]#
58[set pd_spd_max_data_size = synchronization-point-dump-file-buffer-size]#
59[set pd_log_sdinterval = system-log-output-volume[,interval]]#

(18) Server status files

No.Format
60set pd_sts_file_name_1 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"
[set pd_sts_file_name_2 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
[set pd_sts_file_name_3 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
[set pd_sts_file_name_4 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
[set pd_sts_file_name_5 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
[set pd_sts_file_name_6 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
[set pd_sts_file_name_7 = "logical-file-name","file-a-status-file-name","file-b-status-file-name"]
61[set pd_sts_subfile_name_1 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_2 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_3 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_4 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_5 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_6 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]
[set pd_sts_subfile_name_7 = "logical-file-name","primary-status-file-name-for-log-application-processing","secondary-status-file-name-for-log-application-processing"]

(19) Server status files (when an error occurs)

No.Format
62[set pd_sts_last_active_file = "logical-file-name"]
63[set pd_sts_last_active_side = A | B]
64[set pd_sts_last_active_subfile = "logical-file-name"]
65[set pd_sts_last_active_side_sub = A | B]

(20) Work table files

No.Format
66pdwork -v "HiRDB-file-system-area-name"[,"HiRDB-file-system-area-name"]...

(21) System log file configuration

No.Format
67{{pdlogadfg -d sys -g file-group-name [ONL]}}
68{{pdlogadpf -d sys -g file-group-name -a "system-log-file-name" [-b "system-log-file-name"]}}

(22) Synchronization point dump file configuration

No.Format
69{{pdlogadfg -d spd -g file-group-name [ONL]}}
70{{pdlogadpf -d spd -g file-group-name -a "synchronization-point-dump-file-name" [-b "synchronization-point-dump-file-name"]}}
71{{set pdlogadfg -d ssp -g file-group-name [ONL]}}
72{{set pdlogadpf -d ssp -g file-group-name -a "synchronization-point-dump-file-name-for-log-application-processing" [-b "synchronization-point-dump-file-name-for-log-application-processing"]}}

(23) Plug-ins

No.Format
73{{[pdplgprm -n plug-in-name [-s shared-memory-size]]}}

#: If this operand is omitted, the value specified in the same operand in the server common definition is used. However, for the following operands, the value specified for the same operand in the system common definition, rather than the server common definition, is used: