informix hdr基本管理

《informix hdr基本管理》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、informixHDR基本管理分类：informix2011-12-1119:47508人阅读评论(0)收藏举报1.测试下如何主服务器宕机$onstat-c

2、grepDRAUTO#DRAUTO           –ControlsautomaticfailoverofprimaryDRAUTO0-手工切换$onmode-ky观察sercondary服务器状态onstat-IBMInformixDynamicServerVersion11.70.UC1IE—UpdatesBlocked(Sec)—Up00:20:14—15234

3、8Kbytes$onstat-mIBMInformixDynamicServerVersion11.70.UC1IE—UpdatesBlocked(Sec)—Up00:21:16—152348KbytesMessageLogFile:/opt/IBM/informix/informix.log11:04:33 FriJun 3–loguniq22,logpos0×90018,timestamp:0xd0612Interval:52711:04:33 Maximumserverconnections011:04:33 Checkp

4、ointStatistics–Avg.TxnBlockTime0.000,#Txnsblocked0,Plogused19,Llogused011:05:40 CheckpointCompleted: durationwas0seconds.11:05:40 FriJun 3–loguniq22,logpos0×92018,timestamp:0xd0618Interval:52811:05:40 Maximumserverconnections011:05:40 CheckpointStatistics–Avg.TxnBloc

5、kTime0.000,#Txnsblocked0,Plogused2,Llogused011:05:41 SMXthreadisexitingbecauseofnetworkerrorcode-2558211:05:41 SMXthreadisexitingbecauseofnetworkerrorcode-2558211:05:41 DR:Receiveerror11:05:41 ASFEcho-ThreadServer:asfcode=-25582:oserr=0:errstr=:Networkconnectionisbro

6、ken.11:05:41 DR_ERRsetto-111:05:42 DR:Turnedoffonsecondaryserver11:05:42 Updatesfromsecondarycurrentlynotallowed11:05:42 Updatesfromsecondarycurrentlynotallowed开启primary服务器：$oninit$onstat-IBMInformixDynamicServerVersion11.70.UC1IE—On-Line(Prim)—Up00:00:41—144156Kbyte

7、s观察secondary状态：$onstat-IBMInformixDynamicServerVersion11.70.UC1IE—Updatable(Sec)—Up00:23:55—152348Kbytes可以看到，主服务器恢复以后仍能保持主服务器的地位2.添加chunk或者创建dbspaceHDR对中，当需要添加/删除chunks/dbspace时，需要注意的是：操作只能在主服务器进行操作可以由HDR主服务器自动同步到辅助服务器主辅服务器需要预先创建相应的文件或者link如：先在主备库均创建好chunk文件：$touch/o

8、pt/IBM/informix/dbspaces/testdbs$chmod660/opt/IBM/informix/dbspaces/testdbs然后回到primary服务器操作：$onspaces-c-dtestdbs-p/opt/IBM/informix/dbspaces/testdbs-o0-s1000Verifyingphysicaldiskspace,pleasewait…Spacesuccessfullyadded.**WARNING** Alevel0archiveofRootDBSpacewillneedto

9、bedone.这样就创建成功。3.手工切换主备刚才我们看到DRAUTO设置为0，所以采用手工切换方式，如何手工切换呢？也就是主机切换为备机，备机切换成主机。关闭原来primary服务器上：$onmode-ky切换secondary服务器角色：$onmode-ds