db2 10.1 hadr 动态添加辅助备机,参数无法动态生效?
数据库版本:db2 10.1
操作系统版本:SUSE Linux Enterprise Server 11 SP4 (x86_64)
背景:目前是主备模式,采用NEARSYNC模式,现在想动态添加一个辅助备机
发现在主库添加动态参数HADR_TARGET_LIST 时被要求重启,据官方说明是不用重启的,求各位大佬解惑
主库 HADR配置:
HADR database role = PRIMARY
HADR local host name (HADR_LOCAL_HOST) = 172.19.63.121
HADR local service name (HADR_LOCAL_SVC) = 55003
HADR remote host name (HADR_REMOTE_HOST) = 172.19.63.120
HADR remote service name (HADR_REMOTE_SVC) = 55002
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 30
HADR target list (HADR_TARGET_LIST) =
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = 0
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 120
备库HADR配置:
HADR database role = STANDBY
HADR local host name (HADR_LOCAL_HOST) = 172.19.63.120
HADR local service name (HADR_LOCAL_SVC) = 55002
HADR remote host name (HADR_REMOTE_HOST) = 172.19.63.121
HADR remote service name (HADR_REMOTE_SVC) = 55003
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 30
HADR target list (HADR_TARGET_LIST) =
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = 0
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 120
添加时:
db2inst1@xm_cunguan_db_01:~> db2 "update db cfg for lanmao using HADR_TARGET_LIST 172.19.63.120:55002|172.19.63.122:55004"
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
收起