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.

参与11

3同行回答

tongshuaitongshuai数据库工程师北京新数科技有限公司
你先connect to DB_NAME,连接到数据库,再改参数试试,我试过改其它可联机生效参数也是提示需要重启数据库,然后先连库再改就OK了。显示全部

你先connect to DB_NAME,连接到数据库,再改参数试试,我试过改其它可联机生效参数也是提示需要重启数据库,然后先连库再改就OK了。

收起
互联网服务 · 2019-02-15
long8501long8501数据库管理员瀚高软件
发现的重启hadr才可以显示全部

发现的重启hadr才可以

收起
金融其它 · 2019-02-15
浏览2208
张佳雨张佳雨销售代表华夏智诚
[此回答已删除]
浏览1975

提问者

long8501
数据库管理员瀚高软件

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2019-02-14
  • 关注会员:3 人
  • 问题浏览:2974
  • 最近回答:2019-02-15
  • X社区推广