informixHDR基本管理..docVIP

informix HDR基本管理 分类： informix 2011-12-11 19:47 508人阅读 评论(0) 收藏 举报 1.测试下如何主服务器宕机 $ onstat -c|grep DRAUTO# DRAUTO??????????? – Controls automatic failover of primaryDRAUTO 0 -手工切换 $onmode -ky观察sercondary服务器状态onstat -IBM Informix Dynamic Server Version 11.70.UC1IE — Updates Blocked (Sec) — Up 00:20:14 — 152348 Kbytes $onstat -m IBM Informix Dynamic Server Version 11.70.UC1IE — Updates Blocked (Sec) — Up 00:21:16 — 152348 Kbytes Message Log File: /opt/IBM/informix/informix.log11:04:33? Fri Jun? 3 – loguniq 22, logpos 0×90018, timestamp: 0xd0612 Interval: 527 11:04:33? Maximum server connections 011:04:33? Checkpoint Statistics – Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 19, Llog used 0 11:05:40? Checkpoint Completed:? duration was 0 seconds.11:05:40? Fri Jun? 3 – loguniq 22, logpos 0×92018, timestamp: 0xd0618 Interval: 528 11:05:40? Maximum server connections 011:05:40? Checkpoint Statistics – Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 0 11:05:41? SMX thread is exiting because of network error code -2558211:05:41? SMX thread is exiting because of network error code -2558211:05:41? DR: Receive error11:05:41? ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr = : Network connection is broken. 11:05:41? DR_ERR set to -111:05:42? DR: Turned off on secondary server11:05:42? Updates from secondary currently not allowed11:05:42? Updates from secondary currently not allowed 开启primary服务器：$oninit$onstat -IBM Informix Dynamic Server Version 11.70.UC1IE — On-Line (Prim) — Up 00:00:41 — 144156 Kbytes 观察secondary状态：$onstat -IBM Informix Dynamic Server Version 11.70.UC1IE — Updatable (Sec) — Up 00:23:55 — 152348 Kbytes 可以看到，主服务器恢复以后仍能保持主服务器的地位 2.添加chunk或者创建dbspace HDR对中，当需要添加/删除chunks/dbspace时，需要注意的是：操作只能在主服务器进行操作可以由HDR主服务器自动同步到辅助服务器主辅服务器需要预先创建相应的文件或者link如：先在主备库均创建好chunk文件：$touch /opt/IBM/informix/dbspaces/testdbs$chmod 660 /opt/IBM/informix/dbspaces/testdbs然后回到primary服务器操作：$ onspaces -c -d testdbs -p /opt/I