DB2 HADR 最佳实践.pdf
100墨值下载
®
IBM
®
DB2
®
for Linux
®
, UNIX
®
, and Windows
®
Best Practices Best Practices
DB2 High Availability Disaster
Recovery
DB2 High Availability Disaster
Recovery
Dale McInnis Dale McInnis
Senior Technical Staff Member Senior Technical Staff Member
DB2 Availability Architect DB2 Availability Architect
Yuke Zhuge Yuke Zhuge
DB2 Development DB2 Development
Jessica Rockwood Jessica Rockwood
DB2 Development DB2 Development
Robert Causley Robert Causley
DB2 Information Development DB2 Information Development
DB2 High Availability Disaster Recovery Page 2
4
5
6
6
6
7
7
7
8
8
8
8
9
9
10
10
10
11
11
12
12
12
13
16
17
17
17
17
17
18
18
18
19
DB2 High Availability Disaster Recovery.......................................................... 1
Executive summary..............................................................................................
Introduction to HADR...........................................................................................
Setting up your system........................................................................................
Perform an infrastructure analysis...............................................................
Requirements for setting up HADR...................................................................
Use dedicated, high performing disks or file system for the database
logs ...................................................................................................................
Make the location of archived logs accessible to both the primary and
standby databases.........................................................................................
Use a dedicated network for the HADR primary-standby connection ...
Consider using multiple network adapters .................................................
Consider using a virtual IP address for the database server ..................
Consider using automatic client reroute .....................................................
Tuning parameters...............................................................................................
HADR-specific parameters ...........................................................................
Choose the appropri ate HADR synchronization mode...............................................
SYNC mode ....................................................................................................................
NEARSYNC mode .........................................................................................................
ASYNC mode .................................................................................................................
SUPERASYNC mode....................................................................................................
HADR simulator..............................................................................................................
Tune DB2_HADR_BUF_SIZE......................................................................................
Monitoring HADR standby receive buffer usage .......................................................
Tune hadr_timeout.........................................................................................................
Tune hadr_peer_window ..............................................................................................
Tune DB2_HADR_PEER_ WAIT_LIMIT .....................................................................
Tune DB2_HADR_SOSNDBUF a nd DB2_HADR_SORCVBUF ............................
Client-server communication parameters ................................................
Tune DB2TCP_CLIENT_RCVTIMEOUT....................................................................
Database parameters ..................................................................................
Set logfilsiz to a moderate size ....................................................................................
Set logindexbuild to ON ................................................................................................
Set indexrec to RESTART............................................................................................
Tune softmax ..................................................................................................................
Database parameters related to client reroute ........................................
of 27
100墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论