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 nameDefault value in 08-00 and later versionsDefault value in 07-00Default value in versions earlier than 07-00
pd_additional_optimize_level"COST_BASE_2""COST_BASE_2""NONE"
pd_assurance_index_no500
  • 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_no5001000
pd_aud_async_buff_countMAX(1, number of HiRDB servers in unit [Figure] 10)33
pd_aud_async_buff_size40140840964096
pd_bes_shmpool_sizeAutomatic computation by HiRDBAutomatic computation by HiRDB1024
pd_cancel_down_msgchangeYNN
pd_check_pending#1USE
  • 07-03 and later versions: USE
  • Versions earlier than 07-03: NOUSE (USE#1)
NOUSE (USE#1)
pd_dbbuff_attributeFreefixed (free in the 64-bit mode)fixed (free in the 64-bit mode)
pd_dbbuff_lru_optionMIXSEPARATESEPARATE
pd_dic_shmpool_sizeAutomatic computation by HiRDBAutomatic computation by HiRDB1024
pd_large_file_use
  • 08-05 and later versions: Y
  • Versions earlier than 08-05: N
NN
pd_lck_hash_entry0 (Automatic computation by HiRDB)0 (Automatic computation by HiRDB)11261
pd_lck_pool_size16000 (32000 in the 64-bit mode)16000 (32000 in the 64-bit mode)1024
pd_lck_release_detectPipeintervalinterval
pd_lck_wait_timeoutMAX(180, value of pd_watch_time)MAX(180, value of pd_watch_time)180
pd_log_max_data_size4000003200032000
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_count1033
pd_max_access_tables646416
pd_max_commit_write_reclaim_no1000
pd_max_server_processAutomatic computation by HiRDBAutomatic computation by HiRDB100
pd_optimize_levelRefer to the pd_optimize_level operand.Refer to the pd_optimize_level operand."SELECT_APSL"
pd_pageaccess_modeSNAPSHOTSNAPSHOTNORMAL
pd_process_terminatorFixedfixednonresident
pd_process_terminator_maxMax(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_sizeAutomatic computation by HiRDBAutomatic computation by HiRDB1024
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_interval1000000​1000000​4000000​ (1000000​#2)
pd_thdlock_retry_time10001000010000
pd_trn_commit_optimizeONEPHASEONEPHASENOUSE
pd_trn_send_decision_intervalValue of pd_trn_send_decision_intval_sec operand55
pd_work_buff_modePoolpooleach
pd_work_table_option110
SHMMAX200 (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