付録G リードレプリカ機能適用時の参照DBの定義変更可否
リードレプリカ機能を適用している場合の,参照DBでのHiRDB定義変更可否を次の表に示します。
|
オペランド名 |
参照DBでのHiRDB定義変更可否 |
|---|---|
|
HORCMINST |
○ |
|
pd_additional_optimize_level |
○ |
|
pd_alv_port |
− |
|
pd_apply_search_ats_num |
× |
|
pd_assurance_index_no |
○ |
|
pd_assurance_table_no |
○ |
|
pd_audit |
○ |
|
pd_aud_async_buff_count |
○ |
|
pd_aud_async_buff_retry_intvl |
○ |
|
pd_aud_async_buff_size |
○ |
|
pd_aud_auto_loading |
○ |
|
pd_aud_file_name |
○ |
|
pd_aud_file_wrn_pnt |
○ |
|
pd_aud_max_generation_num |
○ |
|
pd_aud_max_generation_size |
○ |
|
pd_aud_no_standby_file_opr |
○ |
|
pd_aud_sql_data_size |
○ |
|
pd_aud_sql_source_size |
○ |
|
pd_audit_def_buffer_size |
○ |
|
pd_auth_cache_size |
○ |
|
pd_auto_vrup |
× |
|
pd_bes_connection_hold |
− |
|
pd_bes_conn_hold_trn_interval |
− |
|
pd_bes_shmpool_size |
− |
|
pd_c_library_directory |
× |
|
pd_cancel_down_msgchange |
× |
|
pd_cancel_dump |
○ |
|
pd_change_clt_ipaddr |
× |
|
pd_check_pending |
× |
|
pd_client_waittime_over_abort |
○ |
|
pd_clt_waittime_over_dump_level |
○ |
|
pd_cmd_exec_time |
○ |
|
pd_cmd_process_conwaittime |
○ |
|
pd_cmd_rconfig |
× |
|
pd_cmd_rlog |
× |
|
pd_cmd_rmode |
× |
|
pd_cmdhold_precheck |
× |
|
pd_command_deadlock_priority |
× |
|
pd_connect_auth_type |
× |
|
pd_connect_errmsg_hide |
× |
|
pd_constraint_name |
× |
|
pd_crypto_certificate_file |
× |
|
pd_crypto_private_key |
× |
|
pd_crypto_service_port |
○ |
|
pd_cwaittime_report_dir |
× |
|
pd_cwaittime_report_size |
× |
|
pd_cwaittime_wrn_pnt |
○ |
|
pd_dbbuff_attribute |
× |
|
pd_dbbuff_binary_data_lru |
× |
|
pd_dbbuff_dev_sector_size |
× |
|
pd_dbbuff_lru_option |
× |
|
pd_dbbuff_modify |
× |
|
pd_dbbuff_rate_updpage |
× |
|
pd_dbbuff_read_retry_count |
× |
|
pd_dbbuff_read_retry_intvl |
× |
|
pd_dbbuff_trace_level |
× |
|
pd_dbreuse_remaining_entries |
× |
|
pd_dbsync_altwrite_skip |
× |
|
pd_dbsync_point |
× |
|
pd_db_access_error_action |
× |
|
pd_db_hold_action |
× |
|
pd_db_io_error_action |
× |
|
pd_db_timestamp_invalid_action |
× |
|
pd_ddl_idx_pctfree |
× |
|
pd_ddl_tbl_fix_pctfree |
× |
|
pd_ddl_tbl_pctfree |
× |
|
pd_ddl_tbl_recovery |
× |
|
pd_deadlock_priority_use |
× |
|
pd_debug_info_netstat |
× |
|
pd_dec_sign_normalize |
× |
|
pd_def_buf_control_area_assign |
× |
|
pd_delete_reserved_word_file |
○ |
|
pd_dfw_awt_process |
× |
|
pd_dfw_syncpoint_skip_limit |
× |
|
pd_dic_shmpool_size |
− |
|
pd_down_watch_proc |
× |
|
pd_dump_suppress_watch_time |
○ |
|
pd_duplicated_fs_suffix |
○ |
|
pd_ekey |
× |
|
pd_fes_lck_pool_partition |
− |
|
pd_fes_lck_pool_size |
− |
|
pd_floatable_bes |
− |
|
pd_ha |
○ |
|
pd_ha_acttype |
○ |
|
pd_ha_agent |
○ |
|
pd_ha_ipaddr_inherit |
○ |
|
pd_ha_max_act_guest_servers |
− |
|
pd_ha_max_server_process |
− |
|
pd_ha_mgr_rerun |
− |
|
pd_ha_observe_timeout |
○ |
|
pd_ha_prc_cleanup_check |
○ |
|
pd_ha_process_count |
− |
|
pd_ha_resource_act_wait_time |
− |
|
pd_ha_restart_failure |
○ |
|
pd_ha_server_process_standby |
○ |
|
pd_ha_switch_error |
○ |
|
pd_ha_switch_timeout |
○ |
|
pd_ha_transaction |
○ |
|
pd_ha_trn_queuing_initial |
− |
|
pd_ha_trn_queuing_wait_time |
○ |
|
pd_ha_trn_restart_retry_time |
○ |
|
pd_ha_unit |
○ |
|
pd_hash_table_size |
○ |
|
pd_hashjoin_hashing_mode |
× |
|
pd_hostname |
○ |
|
pd_host_watch_interval |
− |
|
pd_idx_without_rollback |
× |
|
pd_indexlock_mode |
× |
|
pd_inet_unix_bufmode |
× |
|
pd_inet_unix_utl_bufmode |
× |
|
pd_inner_replica_control |
○ |
|
pd_inner_replica_hold_status |
○ |
|
pd_inner_replica_lock_shift |
○ |
|
pd_ipc_clt_conn_nblock |
× |
|
pd_ipc_clt_conn_nblock_time |
× |
|
pd_ipc_conn_count |
× |
|
pd_ipc_conn_interval |
× |
|
pd_ipc_conn_nblock |
× |
|
pd_ipc_conn_nblock_time |
× |
|
pd_ipc_file_dir |
× |
|
pd_ipc_inet_bufsize |
× |
|
pd_ipc_recv_count |
× |
|
pd_ipc_send_count |
× |
|
pd_ipc_send_retrycount |
× |
|
pd_ipc_send_retrysleeptime |
× |
|
pd_ipc_unix_bufsize |
× |
|
pd_isolation_level |
○ |
|
pd_java_archive_directory |
× |
|
pd_java_castoff |
× |
|
pd_java_classpath |
× |
|
pd_java_libpath |
× |
|
pd_java_option |
× |
|
pd_java_routine_stack_size |
× |
|
pd_java_runtimepath |
× |
|
pd_java_stdout_file |
× |
|
pd_key_resource_type |
× |
|
pd_lck_deadlock_check |
× |
|
pd_lck_deadlock_check_interval |
× |
|
pd_lck_deadlock_check_timeout |
× |
|
pd_lck_deadlock_check_pause |
× |
|
pd_lck_deadlock_info |
× |
|
pd_lck_deadlock_sql_info |
× |
|
pd_lck_hash_entry |
× |
|
pd_lck_pool_partition |
○ |
|
pd_lck_pool_size |
○ |
|
pd_lck_queue_limit |
× |
|
pd_lck_until_disconnect_cnt |
○ |
|
pd_lck_wait_timeout |
○ |
|
pd_leap_second |
× |
|
pd_list_initialize_timing |
× |
|
pd_list_rowcount_in_rename |
× |
|
pd_listen_socket_bufset |
× |
|
pd_lock_uncommited_delete_data |
× |
|
pd_log_auto_expand_size |
× |
|
pd_log_auto_unload_path |
× |
|
pd_log_auto_unload_restart |
× |
|
pd_log_dual |
× |
|
pd_log_dual_write_method |
× |
|
pd_log_fg_warning_point |
○ |
|
pd_log_full_write_async |
× |
|
pd_log_max_data_size |
× |
|
pd_log_org_no_standby_file_opr |
○ |
|
pd_log_org_reflected_logpoint |
○ |
|
pd_log_rec_leng |
× |
|
pd_log_remain_space_check |
× |
|
pd_log_rerun_reserved_file_open |
× |
|
pd_log_rerun_swap |
× |
|
pd_log_rollback_buff_count |
× |
|
pd_log_rpl_no_standby_file_opr |
○ |
|
pd_log_sdinterval |
○ |
|
pd_log_singleoperation |
× |
|
pd_log_swap_timeout |
× |
|
pd_log_unload_check |
× |
|
pd_log_write_buff_count |
○ |
|
pd_lv_mirror_use |
○ |
|
pd_master_file_name |
× |
|
pd_max_access_tables |
○ |
|
pd_max_access_tables_wrn_pnt |
○ |
|
pd_max_add_dbbuff_no |
× |
|
pd_max_add_dbbuff_shm_no |
× |
|
pd_max_ard_process |
× |
|
pd_max_bes_process |
− |
|
pd_max_dic_process |
− |
|
pd_max_file_no |
○※1 |
|
pd_max_file_no_wrn_pnt |
○ |
|
pd_max_list_users |
○ |
|
pd_max_list_count |
○ |
|
pd_max_list_users_wrn_pnt |
○ |
|
pd_max_list_count_wrn_pnt |
○ |
|
pd_max_open_fds |
× |
|
pd_max_open_holdable_cursors |
○ |
|
pd_max_rdarea_no |
○※1 |
|
pd_max_rdarea_no_wrn_pnt |
○ |
|
pd_max_recover_process |
× |
|
pd_max_reflect_process_count |
○ |
|
pd_max_resident_rdarea_no |
○ |
|
pd_max_resident_rdarea_shm_no |
○ |
|
pd_max_server_process |
○ |
|
pd_max_temporary_object_no |
○ |
|
pd_max_tmp_table_rdarea_no |
○ |
|
pd_max_users |
○ |
|
pd_max_users_wrn_pnt |
○ |
|
pd_max_utl_ios_file_no |
○ |
|
pd_mlg_file_size |
× |
|
pd_mlg_msg_log_unit |
− |
|
pd_mlg_port |
− |
|
pd_mode_conf |
× |
|
pd_module_trace_max |
× |
|
pd_module_trace_timer_level |
× |
|
pd_name_fixed_port_lookup |
− |
|
pd_name_port |
○ |
|
pd_non_floatable_bes |
− |
|
pd_nowait_scan_option |
× |
|
pd_oltp_holdcr |
× |
|
pd_optimize_level |
○ |
|
pd_os_authenticate |
× |
|
pd_overflow_suppress |
× |
|
pd_pageaccess_mode |
× |
|
pd_plugin_ixmk_dir |
× |
|
pd_prf_file_count |
○ |
|
pd_prf_file_size |
○ |
|
pd_prf_level |
○ |
|
pd_prf_output_directory |
× |
|
pd_prf_trace |
× |
|
pd_process_count |
○ |
|
pd_process_terminator |
× |
|
pd_process_terminator_max |
× |
|
pd_pth_trace_max |
× |
|
pd_queue_watch_time |
× |
|
pd_queue_watch_timeover_action |
× |
|
pd_rdarea_expand_format |
× |
|
pd_rdarea_extension_file |
× |
|
pd_rdarea_extension_timing |
× |
|
pd_rdarea_list_no_wrn_pnt |
○ |
|
pd_rdarea_open_attribute |
× |
|
pd_rdarea_open_attribute_use |
× |
|
pd_rdarea_warning_point |
× |
|
pd_rdarea_warning_point_msgout |
× |
|
pd_read_replica_use |
○ |
|
pd_read_replica_workdir |
○ |
|
pd_redo_allpage_put |
× |
|
pd_reduced_check_time |
− |
|
pd_registered_port |
○ |
|
pd_registered_port_check |
× |
|
pd_registered_port_level |
× |
|
pd_registry_cache_size |
○ |
|
pd_rise_disaster_mode |
○ |
|
pd_rise_fence_level |
○ |
|
pd_rise_pairvolume_combination |
○ |
|
pd_rise_use |
○ |
|
pd_rorg_predict |
× |
|
pd_routine_def_cache_size |
○ |
|
pd_rpc_trace |
× |
|
pd_rpc_trace_name |
× |
|
pd_rpc_trace_size |
× |
|
pd_rpl_func_control |
○ |
|
pd_rpl_hdepath |
○ |
|
pd_rpl_init_start |
○ |
|
pd_rpl_reflect_mode |
○ |
|
pd_scd_port |
− |
|
pd_sds_shmpool_size |
○ |
|
pd_security_host_group |
○ |
|
pd_security_local_constraint |
× |
|
pd_server_cleanup_interval |
× |
|
pd_server_process_adjust_intvl |
× |
|
pd_server_process_adjust_limit |
× |
|
pd_service_port |
○ |
|
pd_shared_rdarea_use |
− |
|
pd_shmpool_attribute |
× |
|
pd_shmpool_control |
− |
|
pd_space_level |
○ |
|
pd_spd_assurance_count |
× |
|
pd_spd_assurance_msg |
× |
|
pd_spd_dual |
× |
|
pd_spd_max_data_size |
× |
|
pd_spd_reduced_mode |
× |
|
pd_spd_reserved_file_auto_open |
× |
|
pd_spd_syncpoint_skip_limit |
× |
|
pd_spool_cleanup |
× |
|
pd_spool_cleanup_interval |
× |
|
pd_spool_cleanup_interval_level |
× |
|
pd_spool_cleanup_level |
× |
|
pd_sql_command_exec_users |
× |
|
pd_sql_dec_op_maxprec |
× |
|
pd_sql_mode |
× |
|
pd_sql_object_cache_size |
○ |
|
pd_sql_simple_comment_use |
× |
|
pd_sqlobject_stat_timing |
× |
|
pd_standard_sqlstate |
× |
|
pd_start_level |
− |
|
pd_start_skip_unit |
− |
|
pd_start_time_out |
× |
|
pd_statistics |
× |
|
pd_stj_file_size |
○ |
|
pd_stj_buff_size |
○ |
|
pd_stored_lob_data_wrn_pnt |
× |
|
pd_sts_file_name_1〜7 |
○※2 |
|
pd_sts_initial_error |
× |
|
pd_sts_last_active_file |
○ |
|
pd_sts_last_active_side |
○ |
|
pd_sts_last_active_side_sub |
○ |
|
pd_sts_last_active_subfile |
○ |
|
pd_sts_singleoperation |
× |
|
pd_sts_subfile_name_1〜7 |
○ |
|
pd_substr_length |
× |
|
pd_svr_castoff_size |
○ |
|
pd_syssts_file_name_1〜7 |
○※2 |
|
pd_syssts_initial_error |
× |
|
pd_syssts_last_active_file |
○ |
|
pd_syssts_last_active_side |
○ |
|
pd_syssts_last_active_side_sub |
○ |
|
pd_syssts_last_active_subfile |
○ |
|
pd_syssts_singleoperation |
× |
|
pd_syssts_subfile_name_1〜7 |
○ |
|
pd_system_complete_wait_time |
× |
|
pd_system_dbsync_point |
× |
|
pd_system_expand_unit |
− |
|
pd_system_id |
× |
|
pd_table_def_cache_size |
○ |
|
pd_tcp_inet_bufsize |
× |
|
pd_tcp_unix_bufsize |
× |
|
pd_term_watch_count |
× |
|
pd_thdlock_wakeup_lock |
× |
|
pd_thread_max_stack_size |
× |
|
pd_thread_stack_expand_size |
× |
|
pd_tmp_directory |
× |
|
pd_tmp_table_initialize_timing |
○ |
|
pd_tpyrced_key |
× |
|
pd_trn_commit_optimize |
− |
|
pd_trn_port |
− |
|
pd_trn_rcvmsg_store_buflen |
× |
|
pd_trn_rerun_branch_auto_decide |
− |
|
pd_trn_rollback_msg_interval |
× |
|
pd_trn_rollback_watch_time |
− |
|
pd_trn_send_decision_interval |
− |
|
pd_trn_send_decision_intval_sec |
− |
|
pd_trn_send_decision_retry_time |
− |
|
pd_trn_watch_time |
− |
|
pd_type_def_cache_size |
○ |
|
pd_uap_exerror_log_dir |
× |
|
pd_uap_exerror_log_param_size |
○ |
|
pd_uap_exerror_log_size |
× |
|
pd_uap_exerror_log_use |
○ |
|
pd_unique_check_mode |
× |
|
pd_unique_indexlock_info |
× |
|
pd_unit_id |
○ |
|
pd_utl_buff_size |
× |
|
pd_utl_exec_mode |
× |
|
pd_utl_exec_time |
× |
|
pd_view_def_cache_size |
○ |
|
pd_watch_pc_client_time |
○ |
|
pd_watch_resource |
○ |
|
pd_work_buff_expand_limit |
○ |
|
pd_work_buff_mode |
× |
|
pd_work_buff_size |
○ |
|
pd_work_table_option |
× |
|
pdaudload |
○ |
|
pdbuffer |
○ |
|
pdcltgrp |
× |
|
PDCONFPATH |
× |
|
pdhagroup |
− |
|
pdhibegin |
× |
|
pdlogadfg -d spd |
○ |
|
pdlogadfg -d ssp |
○ |
|
pdlogadfg -d sys |
○ |
|
pdlogadpf -d spd |
○※2 |
|
pdlogadpf -d ssp |
○ |
|
pdlogadpf -d sys |
○※2 |
|
pdmlgput |
× |
|
pdplgprm |
× |
|
pdplugin |
× |
|
pdstart |
○ |
|
pdstbegin |
○ |
|
pdunit |
○ |
|
pdwork |
× |
|
pdwork_wrn_pnt |
○ |
|
SHMMAX |
○ |
|
TZ |
× |
- (凡例)
-
○:変更可能なオペランドです。
×:変更できないオペランドです。
−:未サポートオペランドのため,指定できないオペランドです。
- 注※1
-
オペランドの指定値を小さくすると,HiRDBを開始できない場合があります。
- 注※2
-
オペランドの追加,削除ができます。オペランドの変更はできません。