Nonstop Database, HiRDB Version 9 System Definition
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
4.1 Operand formats
(1) Processes
| No. |
Format |
| 1 |
[set pd_max_bes_process = maximum-number-of-activated-processes-per-back-end-server] |
| 2 |
[set pd_max_dic_process = maximum-number-of-activated-processes-per-dictionary-server] |
| 3 |
[set pd_process_count = resident-processes-count[,resident-processes-count-at-server-startup]] |
| 4 |
[set pd_server_cleanup_interval = interval-for-stopping-nonresident-server-processes] |
| 5 |
[set pd_svr_castoff_size = maximum-memory-size-used-by-server-process] |
| 6 |
[set pd_max_ard_process = asynchronous-READ-process-count] |
| 7 |
[set pd_dfw_awt_process = number-of-parallel-writes-for-deferred-write-processing] |
(2) Work tables
| 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] |
(3) System monitoring
| No. |
Format |
| 11 |
[set pd_watch_pc_client_time = maximum-client-request-wait-time] |
| 12 |
[set pd_spd_syncpoint_skip_limit = maximum-number-of-skipped-synchronization-point-dumps] |
| 13 |
[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 |
| 14 |
[set pd_lck_pool_size = server-lock-pool-size] |
| 15 |
[set pd_fes_lck_pool_size = front-end-server-lock-pool-size] |
| 16 |
[set pd_lck_pool_partition = per-server-lock-pool-partition-count] |
| 17 |
[set pd_fes_lck_pool_partition = front-end-server-lock-pool-partition-count] |
| 18 |
[set pd_lck_until_disconnect_cnt = total-number-of-tables-and-RDAREAs-to-be-locked-per-server-UNTIL-DISCONNECT-specification] |
| 19 |
[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] |
| 20 |
[set pd_lck_hash_entry = lock-pool-hash-entry-count] |
(5) Buffers
| No. |
Format |
| 21 |
[set pd_sql_object_cache_size = SQL-object-buffer-size]# |
| 22 |
[set pd_table_def_cache_size = table-definition-information-buffer-size] |
| 23 |
[set pd_auth_cache_size = user-privilege-information-buffer-size] |
| 24 |
[set pd_view_def_cache_size = view-analysis-information-buffer-size] |
| 25 |
[set pd_type_def_cache_size = user-defined-type-information-buffer-size] |
| 26 |
[set pd_routine_def_cache_size = routine-definition-information-buffer-size] |
| 27 |
[set pd_registry_cache_size = registry-information-buffer-size] |
(6) Shared memory
| No. |
Format |
| 28 |
[set pd_sds_shmpool_size = single-server-shared-memory-size] |
| 29 |
[set pd_dic_shmpool_size = dictionary-server-shared-memory-size] |
| 30 |
[set pd_bes_shmpool_size = back-end-server-shared-memory-size] |
(7) RPC trace information
| No. |
Format |
| 31 |
[set pd_rpc_trace = Y | N]# |
| 32 |
[set pd_rpc_trace_name = "name-for-RPC-trace-collection-files"]# |
| 33 |
[set pd_rpc_trace_size = RPC-trace-collection-file-size]# |
(8) Troubleshooting information
| No. |
Format |
| 34 |
[set pd_module_trace_max = maximum-number-of-module-traces-that-can-be-stored]# |
| 35 |
[set pd_module_trace_timer_level = 0 | 10 | 20]# |
| 36 |
[set pd_pth_trace_max = maximum-number-of-stored-communication-traces]# |
(9) Global buffers
| No. |
Format |
| 37 |
[set pd_max_add_dbbuff_no = maximum-global-buffers-count-for-dynamic-addition] |
| 38 |
[set pd_max_add_dbbuff_shm_no = maximum-shared-memory-segments-count-for-dynamic-addition] |
(10) Temporary tables
| No. |
Format |
| 39 |
[set pd_max_temporary_object_no = maximum-number-of-temporary-tables-and-temporary-table-indexes-used-at-any-one-time]# |
(11) Security
| No. |
Format |
| 40 |
[set pd_audit_def_buffer_size = security-audit-information-buffer-length] |
| No. |
Format |
| 41 |
[set pd_java_stdout_file = "Java-virtual-machine-standard-output-and-standard-error-output-destination-file"]# |
| 42 |
[set pd_java_castoff = Y | N] |
(13) System log files
| No. |
Format |
| 43 |
[set pd_log_dual = Y | N] |
| 44 |
[set pd_log_dual_write_method = serial | parallel] |
| 45 |
[set pd_log_remain_space_check = warn | safe] |
| 46 |
[set pd_log_auto_unload_restart = Y | N] |
| 47 |
[set pd_log_singleoperation = Y | N] |
| 48 |
[set pd_log_rerun_reserved_file_open = Y | N] |
| 49 |
[set pd_log_rerun_swap = Y | N] |
| 50 |
[set pd_log_swap_timeout = wait-time-for-completion-of-system-log-file-swapping] |
| 51 |
[set pd_log_unload_check = Y | N] |
| 52 |
[set pd_log_write_buff_count = log-output-buffer-sectors-count] |
| 53 |
[set pd_log_auto_expand_size = extension-amount-per-system-log-file-extension-trigger[,extension-limit]] |
(14) Synchronization point dump files
| No. |
Format |
| 54 |
[set pd_spd_dual = Y | N] |
| 55 |
[set pd_spd_assurance_msg = Y | N] |
| 56 |
[set pd_spd_assurance_count = number-of-guaranteed-valid-generations] |
| 57 |
[set pd_spd_reduced_mode = reduced-mode-operation-option] |
| 58 |
[set pd_spd_reserved_file_auto_open = Y | N] |
| 59 |
[set pd_spd_max_data_size = synchronization-point-dump-file-buffer-size] |
| 60 |
[set pd_log_sdinterval = system-log-output-volume[,interval]] |
(15) BES connection holding facility
| No. |
Format |
| 61 |
[set pd_bes_connection_hold = Y | N] |
| 62 |
[set pd_bes_conn_hold_trn_interval = back-end-server-connection-hold-time] |
#: If this operand is omitted, the value specified in the same operand in the system common definition or unit control information definition is used.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.