DB2在开启HADR后切换主备，后在原备库测试insert

DB2 HADR 主备切换实战

最新推荐文章于 2025-05-27 23:00:00 发布

原创

最新推荐文章于 2025-05-27 23:00:00 发布 · 715 阅读

9 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

查询主备状态：

db2pd -d testdb -hadr

查看目前hadr正常启动状态

备库执行sql报错：

db2 "insert into tab1 values (1)"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1773N The statement or command failed because it requires functionality
that is not supported on a read-enabled HADR standby database. Reason code =
"5".
原因是备库存在写保护

切换主备在原备库做插入数据操作

db2 takeover ha