6.1 Operand formats

A front-end server definition defines information for a front-end server. This section explains the formats used to specify the operands of a front-end server definition. Note that the numbers in the following table correspond to the numbers assigned to the operands explained in 6.2 Operands whose specification values can be changed and 6.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
1[set pd_process_count = resident-processes-count[,resident-processes-count-at-server-startup ]]*Processes
2[set pd_server_cleanup_interval = interval-for-stopping-nonresident-server-processes]*
3[set pd_optimize_level = SQL-optimization-option [,SQL-optimization-option]...]*SQL optimization
4[set pd_additional_optimize_level = SQL-extension-optimizing-option [,SQL-extension-optimizing-option]...]*
5[set pd_floatable_bes = "back-end-server-name"[,"back-end-server-name"]...]
6[set pd_non_floatable_bes = "back-end-server-name"[,"back-end-server-name"]...]
7[set pd_watch_pc_client_time = maximum-client-request-wait-time]*System monitoring
8[set pd_spd_syncpoint_skip_limit = maximum-number-of-skipped-synchronization-point-dumps]*
9[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
10[set pd_uap_exerror_log_use = YES | NO]Facility for output of extended SQL error information
11[set pd_fes_lck_pool_size = front-end-server-lock-pool-size]*Lock
12[set pd_lck_hash_entry = lock-pool-hash-entry-count]*
13[set pd_sql_object_cache_size = SQL-object-buffer-size]*Buffers
14[set pd_table_def_cache_size = table-definition-information-buffer-size]*
15[set pd_auth_cache_size = user-privilege-information-buffer-size]*
16[set pd_view_def_cache_size = view-analysis-information-buffer-size]*
17[set pd_type_def_cache_size = user-defined-type-information-buffer-size]*
18[set pd_routine_def_cache_size = routine-definition-information-buffer-size]*
19[set pd_registry_cache_size = registry-information-buffer-size]*
20[set pd_rpc_trace = Y | N]*RPC trace information
21[set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"]*
22[set pd_rpc_trace_size = RPC-trace-collection-file-size]*
23[set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored]*Troubleshooting information
24[set pd_module_trace_timer_level = module-trace-output-time-acquisition-method]
25[set pd_audit_def_buffer_size = security-audit-information-buffer-length]Security audit facility
26[set pd_java_stdout_file = "Java-virtual-machine-standard-output-and-standard-error-output-destination-file"]*Java
27[set pd_log_dual = Y | N]*System log files
28[set pd_log_remain_space_check = warn | safe]*
29[set pd_log_auto_unload_path = "unload-log-file-output-directory" [,"unload-log-file-output-directory"]...]
30[set pd_log_singleoperation = Y | N]*
31[set pd_log_rerun_reserved_file_open = Y | N]*
32[set pd_log_rerun_swap = Y | N]*
33[set pd_log_swap_timeout = wait-time-for-completion-of-system-log-file-swapping]*
34[set pd_log_unload_check = Y | N]*
35[set pd_log_max_data_size = log-input/output-buffer-size]*
36[set pd_log_write_buff_count = log-output-buffer-sectors-count]*
37[set pd_log_rec_leng = system-log-file-record-length]*
38[set pd_spd_dual = Y | N]*Synchronization point dump files
39[set pd_spd_assurance_msg = Y | N]*
40[set pd_spd_assurance_count = number-of-guaranteed-valid-generations]*
41[set pd_spd_reduced_mode = reduced-mode-operation-option]*
42[set pd_spd_reserved_file_auto_open = Y | N]*
43[set pd_spd_max_data_size = synchronization-point-dump-file-buffer-size]*
44[set pd_log_sdinterval = system-log-output-volume[,interval]]*
45set pd_sts_file_name_1 = "logical-file-name"
,"file-a-status-file-name","file-b-status-file-name"
Server status files
[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"]
46[set pd_sts_initial_error = stop | continue | excontinue]*Server status files (when an error occurs)
47[set pd_sts_singleoperation = stop | continue]*
48[set pd_sts_last_active_file = "logical-file-name"]
49[set pd_sts_last_active_side = A | B]
50{{pdlogadfg -d sys -g file-group-name [ONL]}}System log file configuration
51{{pdlogadpf -d sys -g file-group-name
-a "system-log-file-name" [-b "system-log-file-name"]}}
52{{pdlogadfg -d spd -g file-group-name [ONL]}}Synchronization point dump file configuration
53{{pdlogadpf -d spd -g file-group-name
-a "synchronization-point-dump-file-name"
[-b "synchronization-point-dump-file-name"]}}
54{{[pdplgprm -n plug-in-name [-s shared-memory-size]]}}Plug-ins
55{
[pdhubopt -s foreign-server-name -f Hub-optimization-information-definition-file-name]
|
[pdhubopt -d foreign-server-type [-v foreign -server-version] -f Hub-optimization-information-definition-file-name]
}
HiRDB External Data Access facility

* 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: