Implementing IBM
DB2
Universal Database
V8.1 Enterprise Server Edition with Microsoft
Cluster Server
January 2003
Aslam Nomani
DB2 UDB System Verification Test
Implementing IBM DB2 Universal Database Extended Enterprise Edtion with Microsoft Cluster Server
ii
iii
© Copyright International Business Machines Corporation 2003. All rights reserved.
Implementing IBM DB2 Universal Database Extended Enterprise Edtion with Microsoft Cluster Server
iv
Trademarks
The following terms are trademarks or registered trademarks of the IBM Corporation in the United
States and/or other countries: IBM, DB2, DB2 Universal Database.
Windows and Windows-based trademarks and logos are trademarks or registered trademarks of
Microsoft Corp.
Other company, product or service names may be the trademarks or service marks of others.
The furnishing of this document does not imply giving license to any IBM patents.
v
Contents
Abstract.......................................................................................................................................vii
About the Author.....................................................................................................................viii
Introduction.................................................................................................................................1
DB2 UDB ESE overview.........................................................................................................2
Conceptual overview................................................................................................................5
Failover and failback.................................................................................................................8
DB2MSCS utility.....................................................................................................................10
Drive mapping..........................................................................................................................13
Planning and preparation........................................................................................................14
Hot standby single-partition configuration........................................................................15
Mutual takeover single-partition configuration..................................................................21
Mutual takeover multiple-partition configuration..............................................................26
Configuring the DB2 Administration Server.....................................................................29
Remote client connections ....................................................................................................32
User scripts...............................................................................................................................34
Testing the configuration.......................................................................................................35
Rolling upgrade........................................................................................................................36
Repairing a cluster after catastrophic machine failure.....................................................37
Managing security....................................................................................................................39
DB2 authentication.....................................................................................................................39
Other sample configurations.................................................................................................40
Mutual takeover load-balancing configuration..............................................................................40