Nonstop Database, HiRDB Version 9 System Definition

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

1.5 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

The table below 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-8 Operands whose default value depends on the version

Operand name Default value in 08-00 and later versions (recommendable#1) Default value in 07-00
(v7compatible#2)
Default value in versions earlier than 07-00 (v6compatible#3)
pd_additional_optimize_level "COST_BASE_2" "COST_BASE_2" "NONE"
pd_assurance_index_no 500
  • For HiRDB/Single Server:
    Number of indexes for data dictionary table (240) + 50
  • For HiRDB/Parallel Server:
    50

  • For HiRDB/Single Server:
    Number of indexes for data dictionary table (240) + 50
  • For HiRDB/Parallel Server:
    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#4 USE
  • 07-03 and later versions: USE
  • Versions earlier than 07-03: NOUSE (USE#5)
NOUSE (USE#5)
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_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_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]value of pd_max_users operand [Figure] 100[Figure]) [Figure]value of pd_max_users operand[Figure] 100[Figure] [Figure]value 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_pipe_retry_interval 1000000 1000000 4000000 (1000000#6)
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
These are the default values when recommendable is specified in the pd_sysdef_default_option operand or when the pd_sysdef_default_option operand has been omitted.

#2
These are the default values used when v7compatible is specified in the pd_sysdef_default_option operand.

#3
These are the default values used when v6compatible is specified in the pd_sysdef_default_option operand.

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

#5
The pd_check_pending operand is not affected when the default value is modified with the pd_sysdef_default_option operand. For this reason, the default for pd_check_pending is USE even when v6compatible or v7compatible is specified in the pd_sysdef_default_option operand.
If compatibility with versions earlier than 07-03 must be maintained, specify NOUSE in pd_check_pending.

#6
The pd_thdlock_pipe_retry_interval operand is not affected when the default value is modified with the pd_sysdef_default_option operand. For this reason, the default for pd_thdlock_pipe_retry_interval is 1000000 even when v6compatible is specified in the pd_sysdef_default_option operand.
If compatibility with versions earlier than 07-00 must be maintained, specify 4000000 in pd_thdlock_pipe_retry_interval.

(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