使用WebSphere中间件构建数据库环境

> db2 takeover hadr on db sample 

DB20000I The TAKEOVER HADR ON DATABASE command completed successfully. 

WebSphere Application Server SystemOut.log 

[11/1/06 17:15:39:298 CST] 00000039 ServletWrappe E SRVE0068E: Uncaught exception 
thrown in one of the service methods of the servlet: /dbview.jsp. Exceptionthrown : 
javax.servlet.ServletException: A connection failed but has been re-established. The 
hostname or IP address is "svtlewis.rchland.ibm.com" and the service name 
or port number is 60000 . Special registers may or may not be re-attempted (Reason 
code = 1 DB2ConnectionCorrelator: G9056D89.O37F.061101231714 

> db2 get snapshot for database on sample | grep State 

State = Remote catchup pending 

> db2 takeover hadr on db Sample by force 

DB20000I The TAKEOVER HADR ON DATABASE command completed successfully. 

> db2 get snapshot for database on sample | grep Role 

Role = Primary 

> db2 get snapshot for database on sample | grep State 

State = Disconnected 

[10/27/06 0:26:27:796 CDT] 0000002b WebApp E [Servlet Error]-[/dbview.j 
sp]: com.ibm.websphere.ce.cm.StaleConnectionException: A connection failed but has been 
re-established. The hostname or IP address is "svtlewis.rchland.ibm.com" and 
the service name or port number is 60000. Special registers may or may not be re-attempted 
(Reason code = 1 DB2ConnectionCorrelator: G9056D89.A7AD.061027052803...) 

2006-11-01-17.06.15.113214-360 I383930C400 LEVEL: Warning 
PID : 4021 TID : 4160127008 PROC : db2agent (SAMPLE) 0 
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE 
APPHDL : 0-8 APPID: *LOCAL.db2inst1.061101230614 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:211 
52 
MESSAGE : Info: HADR Startup has completed. 

2006-11-01-17.06.15.669454-360 E384331C363 LEVEL: Event 
PID : 4032 TID : 4160127008 PROC : db2hadrs (SAMPLE) 0 
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10 
000 
CHANGE : HADR state set to S-RemoteCatchup (was S-RemoteCatchupPending) 

2006-11-01-17.06.16.145289-360 E385032C353 LEVEL: Event 
PID : 4032 TID : 4160127008 PROC : db2hadrs (SAMPLE) 0 
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10 
000 
CHANGE : HADR state set to S-NearlyPeer (was S-RemoteCatchup) 

2006-11-01-17.06.16.240636-360 E385386C344 LEVEL: Event 
PID : 4032 TID : 4160127008 PROC : db2hadrs (SAMPLE) 0 
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10 
000 
CHANGE : HADR state set to S-Peer (was S-NearlyPeer) 

./wsadmin.sh 
set ds [$AdminControl queryNames type=DataSource, name=<ds_name>] 
$AdminControl invoke $ds purgePoolContents 

>./wsadmin.sh 

>set ds [$AdminControl queryNames type=DataSource,name=myDS,process=server2,*] 

>$AdminControl invoke $ds purgePoolContents 

>./wsadmin.sh 

>set mbeans [$AdminControl queryNames type=DataSource,*] 
foreach mbean $mbeans { 
>$AdminControl invoke $mbean purgePoolContents 
}