Nonstop Database, HiRDB Version 9 System Definition

[Contents][Index][Back][Next]

1.5.2 Changes in HiRDB system definitions in versions earlier than 09-50

Organization of this subsection
(1) Operands whose default value depends on the version
(2) Operands that are no longer needed

(1) Operands whose default value depends on the version

The following table lists and describes the operands whose default value depends on the version (when the version is earlier than 09-50).

Table 1-11 Operands whose default value depends on the version

Operand name Default value in 08-00 and later versions Default value in 07-00 Default value in versions earlier than 07-00
pd_additional_optimize_level "COST_BASE_2" "COST_BASE_2" "NONE"
pd_assurance_index_no 500
  • For a HiRDB single server configuration:
    Number of indexes for data dictionary table (240) + 50
  • For a HiRDB parallel server configuration:
    50

  • For a HiRDB single server configuration:
    Number of indexes for data dictionary table (240) + 50
  • For a HiRDB parallel server configuration:
    50
pd_assurance_table_no 500 100 0
pd_aud_async_buff_count MAX(1, number of HiRDB servers in unit [Figure] 10) 3 3
pd_aud_async_buff_size 401408 4096 4096
pd_bes_shmpool_size Automatic computation by HiRDB Automatic computation by HiRDB 1024
pd_cancel_down_msgchange Y N N
pd_check_pending#1 USE
  • 07-03 and later versions: USE
  • Versions earlier than 07-03: NOUSE (USE#1)
NOUSE (USE#1)
pd_dbbuff_attribute Free fixed (free in the 64-bit mode) fixed (free in the 64-bit mode)
pd_dbbuff_lru_option MIX SEPARATE SEPARATE
pd_dic_shmpool_size Automatic computation by HiRDB Automatic computation by HiRDB 1024
pd_large_file_use
  • 08-05 and later versions: Y
  • Versions earlier than 08-05: N
N N
pd_lck_hash_entry 0 (Automatic computation by HiRDB) 0 (Automatic computation by HiRDB) 11261
pd_lck_pool_size 16000 (32000 in the 64-bit mode) 16000 (32000 in the 64-bit mode) 1024
pd_lck_release_detect Pipe interval interval
pd_lck_wait_timeout MAX(180, value of pd_watch_time) MAX(180, value of pd_watch_time) 180
pd_log_max_data_size 400000 32000 32000
pd_log_sdinterval
  • system-log-output-volume: 5000
  • Interval: 60

  • system-log-output-volume: 1000
  • Interval: 60

  • system-log-output-volume: 1000
  • Interval: 60
pd_log_write_buff_count 10 3 3
pd_max_access_tables 64 64 16
pd_max_commit_write_reclaim_no 10 0 0
pd_max_server_process Automatic computation by HiRDB Automatic computation by HiRDB 100
pd_optimize_level Refer to the pd_optimize_level operand. Refer to the pd_optimize_level operand. "SELECT_APSL"
pd_pageaccess_mode SNAPSHOT SNAPSHOT NORMAL
pd_process_terminator Fixed fixed nonresident
pd_process_terminator_max Max(3, [Figure](value of pd_max_users operand + value of pd_max_reflect_process_count operand) [Figure] 100[Figure]) [Figure](value of pd_max_users operand + value of pd_max_reflect_process_count operand) [Figure] 100[Figure] [Figure](value of pd_max_users operand + value of pd_max_reflect_process_count operand) [Figure] 100[Figure]
pd_sds_shmpool_size Automatic computation by HiRDB Automatic computation by HiRDB 1024
pd_spool_cleanup_interval_level
  • number-of-days: 7
  • deletion-type: all

  • number-of-days: 7
  • deletion-type: dump

  • number-of-days: 7
  • deletion-type: dump
pd_spool_cleanup_level
  • number-of-days: 7
  • deletion-type: all

  • number-of-days: 7
  • deletion-type: dump

  • number-of-days: 7
  • deletion-type: dump
pd_thdlock_pipe_retry_interval 1000000 1000000 4000000 (1000000#2)
pd_thdlock_retry_time 1000 10000 10000
pd_trn_commit_optimize ONEPHASE ONEPHASE NOUSE
pd_trn_send_decision_interval Value of pd_trn_send_decision_intval_sec operand 5 5
pd_work_buff_mode Pool pool each
pd_work_table_option 1 1 0
SHMMAX 200 (only in the 32-bit mode) 200 (only in the 32-bit mode) 6

#1
The default for the pd_check_pending operand was changed in version 07-03 from NOUSE to USE.

#2
The default for the pd_thdlock_pipe_retry_interval operand was changed in version 07-00 from 4000000 to 1000000.

(2) Operands that are no longer needed

Upgrading eliminates the need to specify the operands listed below. If you have upgraded your system and have left these operands in place, no error occurs.

Operand that is no longer needed starting in version 08-00
  • pd_dynamic_sql_object_cache

Operands that are no longer needed starting in version 07-00
  • pd_multi_fes
  • pd_redo_skip_inf