A back-end server definition defines information for a back-end server. This section explains the formats used to specify the operands of a back-end server definition. Note that the numbers in the following table correspond to the numbers assigned to the explanations of the individual operands in 8.2 Operand explanations.
No. | Format |
---|---|
1 | [set pd_max_bes_process = maximum-number-of-activated-processes-per-back-end-server]# |
2 | [set pd_process_count = resident-processes-count[,resident-processes-count-at-server-startup]]# |
3 | [set pd_server_cleanup_interval = interval-for-stopping-nonresident-server-processes]# |
4 | [set pd_svr_castoff_size = maximum-memory-size-used-by-server-process]# |
5 | [set pd_max_open_fds = maximum-number-of-files-and-pipes-accessed-by-process] |
6 | [set pd_max_ard_process = asynchronous-READ-process-count]# |
7 | [set pd_dfw_awt_process = number-of-parallel-write-processes-for-deferred-write-processing] |
No. | Format |
---|---|
8 | [set pd_work_buff_mode = each | pool]# |
9 | [set pd_work_buff_size = work-table-buffer-size]# |
10 | [set pd_work_buff_expand_limit = work-table-buffer-expansion-limit]# |
No. | Format |
---|---|
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]# |
No. | Format |
---|---|
13 | [set pd_lck_pool_size = server-lock-pool-size]# |
14 | [set pd_lck_pool_partition = per-server-lock-pool-partition-count]# |
15 | [set pd_lck_until_disconnect_cnt = total-number-of-tables-and-RDAREAs-to-be-locked-per-server-UNTIL-DISCONNECT-specification]# |
16 | [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]# |
17 | [set pd_lck_hash_entry = lock-pool-hash-entry-count]# |
No. | Format |
---|---|
18 | [set pd_sql_object_cache_size = SQL-object-buffer-size]# |
No. | Format |
---|---|
19 | [set pd_bes_shmpool_size = back-end-server-shared-memory-size]# |
No. | Format |
---|---|
20 | [set pd_rpc_trace = Y | N]# |
21 | [set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"]# |
22 | [set pd_rpc_trace_size = RPC-trace-collection-file-size]# |
No. | Format |
---|---|
23 | [set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored]# |
24 | [set pd_module_trace_timer_level = 0 | 10 | 20]# |
25 | [set pd_pth_trace_max = maximum-number-of-stored-communication-traces]# |
No. | Format |
---|---|
26 | [set pd_max_add_dbbuff_no = maximum-global-buffers-count-for-dynamic-addition]# |
27 | [set pd_max_add_dbbuff_shm_no = maximum-shared-memory-segments-count-for-dynamic-addition]# |
No. | Format |
---|---|
28 | [set pd_max_temporary_object_no = maximum-number-of-temporary-tables-and-temporary-table-indexes-used-at-any-one-time]# |
No. | Format |
---|---|
29 | [set pd_plugin_ixmk_dir = "index-information-file-creation-directory-name" or "index-information-file-creation-HiRDB-file-system-area-name"] |
No. | Format |
---|---|
30 | [set pd_java_stdout_file = "Java-virtual-machine-standard-output-or-standard-error-output-destination-file"]# |
31 | [set pd_java_castoff = Y | N]# |
No. | Format |
---|---|
32 | [set pd_log_dual = Y | N]# |
33 | [set pd_log_dual_write_method = serial | parallel] |
34 | [set pd_log_remain_space_check = warn | safe]# |
35 | [set pd_log_auto_unload_path = "unload-log-file-output-directory"[,"unload-log-file-output-directory"]...] |
36 | [set pd_log_auto_unload_restart = Y | N]# |
37 | [set pd_log_singleoperation = Y | N]# |
38 | [set pd_log_rerun_reserved_file_open = Y | N]# |
39 | [set pd_log_rerun_swap = Y | N]# |
40 | [set pd_log_swap_timeout = wait-time-for-completion-of-system-log-file-swapping]# |
41 | [set pd_log_unload_check = Y | N]# |
42 | [set pd_log_write_buff_count = log-output-buffer-sectors-count]# |
43 | [set pd_log_auto_expand_size = extension-amount-per-system-log-file-extension-trigger[,extension-limit]]# |
No. | Format |
---|---|
44 | [set pd_spd_dual = Y | N]# |
45 | [set pd_spd_assurance_msg = Y | N]# |
46 | [set pd_spd_assurance_count = number-of-guaranteed-valid-generations]# |
47 | [set pd_spd_reduced_mode = reduced-mode-operation-option]# |
48 | [set pd_spd_reserved_file_auto_open = Y | N]# |
49 | [set pd_spd_max_data_size = synchronization-point-dump-file-buffer-size]# |
50 | [set pd_log_sdinterval = system-log-output-volume[,interval]]# |
No. | Format |
---|---|
51 | set 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"] | |
52 | [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"] |
No. | Format |
---|---|
53 | [set pd_sts_last_active_file = "logical-file-name"] |
54 | [set pd_sts_last_active_side = A | B] |
55 | [set pd_sts_last_active_subfile = "logical-file-name"] |
56 | [set pd_sts_last_active_side_sub = A | B] |
No. | Format |
---|---|
57 | [set pd_bes_connection_hold = Y | N]# |
58 | [set pd_bes_conn_hold_trn_interval = back-end-server-connection-hold-time]# |
No. | Format |
---|---|
59 | pdwork -v "HiRDB-file-system-area-name"[,"HiRDB-file-system-area-name"]... |
No. | Format |
---|---|
60 | {{pdlogadfg -d sys -g file-group-name [ONL]}} |
61 | {{pdlogadpf -d sys -g file-group-name -a "system-log-file-name" [-b "system-log-file-name"]}} |
No. | Format |
---|---|
62 | {{pdlogadfg -d spd -g file-group-name [ONL]}} |
63 | {{pdlogadpf -d spd -g file-group-name -a "synchronization-point-dump-file-name" [-b "synchronization-point-dump-file-name"]}} |
64 | {{{set pdlogadfg -d ssp -g file-group-name[ONL]}} |
65 | {{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"]}} |
No. | Format |
---|---|
66 | {{[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.