Scalable Database Server, HiRDB Version 8 System Definition

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

1.4 Operands whose default value depends on the version and operands that are no longer needed

Organization of this section
(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

Table 1-7 lists and describes the operands whose default value depends on the version.

If you do not want to change operand default values during upgrading, specify v6compatible or v7compatible in the pd_sysdef_default_option operand.

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

Operand name Recommendable
(default value in 08-00 and newer versions)
v7compatible
(default value in 07-00)
v6compatible
(default value in versions older than 07-00)
pd_additional_optimize_level "COST_BASE_2" "COST_BASE_2" "NONE"
pd_assurance_index_no 500 (automatic addition is not made during normal startup of HiRDB)
  • For HiRDB/Single Server:
    Number of indexes for data dictionary table (124) + 50 (added automatically during normal startup of HiRDB)
  • For HiRDB/Parallel Server:
    50 (added automatically during normal startup of HiRDB)

  • For HiRDB/Single Server:
    Number of indexes for data dictionary table (124) + 50 (added automatically during normal startup of HiRDB)
  • For HiRDB/Parallel Server:
    50 (added automatically during normal startup of HiRDB)
pd_assurance_table_no 500 (automatic addition is not made during normal startup of HiRDB) 100 (automatic addition is made during normal startup of HiRDB) 0 (automatic addition is not made during normal startup of HiRDB)
pd_aud_async_buff_count MAX(1, number of HiRDB servers in unit x 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_change_clt_ipaddr 1 0 0
pd_dbbuff_lru_option MIX SEPARATE SEPARATE
pd_dic_shmpool_size Automatic computation by HiRDB Automatic computation by HiRDB 1024
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_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_ntfs_cache_disable Y N N
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]Values of pd_max_users operand[Figure] 100[Figure]) [Figure]Values of pd_max_users operand[Figure] 100[Figure] [Figure]Values of pd_max_users 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_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

(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