Skip to main content
This forum is closed to new posts and responses. New discussions are now taking place in the IBM Developer Answers forum.
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  IBM Sametime Forum

IBM Sametime Forum

developerWorks

  

PreviousPrevious NextNext

RE: Guide to DB2 HADR Setup with Sametime 9
Ben Williams 2.Sep.14 04:23 AM Lotus Notes
Administration 9.0 All Platforms


Thanks for finding my blog!

Not much will have changed with regards to the setup of DB2 and Automatic Client Reroute (ACR). The fail over is manual and commands for this are easily found. If you want automatic fail over you will need Tivoli System Automation for Mutliplatforms (TSAMP) but that is expensive and if you are struggling with configuring HADR then you will certainly struggle with TSAMP.

You are better off looking for documents on DB2 blogs/wikis etc though be mindful that much of the data will be read by people that actually know DB2 so most of it will be using command line interface.

The later version of DB2 withdrew the Control Center http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.wn.doc/doc/i0058731.html so you will need to use IBM Data Studio which I believe requires a license. I don't believe free tools like DB Visualizer will allow you to configure HADR so you are down to using the command line which can be confusing if you're used to a UI.

Personally I would install DB2 on two nodes and get hold of IBM Data Studio and play around with configuring it. You don't need any data, just two nodes with DB2 installed and you can even use the scripts to create the STMS databases.

The output from my commands via the UI are as follows. I ran through this with someone who was training to become a DB2 DBA (which he now is) so I had an educated person to assist. It's much easier if you can lean on someone who knows DB2 who can script this for you or work with you at least.

-- Copy backup images from primary to standby system.
--
-- Location on primary system : /opt/IBM/db2/backups
-- Location on standby system : /opt/IBM/db2/backups
--
-- Restore database on standby system - HEL269 - M269V2 (db2inst1) - STMS2692 (STMS)
--
RESTORE DATABASE STMS FROM "/opt/IBM/db2/V9.5/db2inst1" TAKEN AT 20101214122048 REPLACE HISTORY FILE WITHOUT PROMPTING
--
-- Configure databases for client reroute - HEL268 - db2inst1 - STMS
--
UPDATE ALTERNATE SERVER FOR DATABASE STMS USING HOSTNAME hel269.acme.com PORT 50000
--
-- Configure databases for client reroute - HEL269 - M269V2 (db2inst1) - STMS2692 (STMS)
--
UPDATE ALTERNATE SERVER FOR DATABASE STMS USING HOSTNAME HEL268.acme.com PORT 50000
--
-- Update services file on primary system - HEL268
-- Service name : DB2_HADR_1
-- Port number : 55001
-- Service name : DB2_HADR_2
-- Port number : 55002
--
-- Update services file on standby system - HEL269
-- Service name : DB2_HADR_1
-- Port number : 55001
-- Service name : DB2_HADR_2
-- Port number : 55002
--
-- Update HADR configuration parameters on primary database - HEL268 - db2inst1 - STMS
--
UPDATE DB CFG FOR STMS USING HADR_LOCAL_HOST HEL268
UPDATE DB CFG FOR STMS USING HADR_LOCAL_SVC DB2_HADR_1
UPDATE DB CFG FOR STMS USING HADR_REMOTE_HOST hel269.acme.com
UPDATE DB CFG FOR STMS USING HADR_REMOTE_SVC DB2_HADR_2
UPDATE DB CFG FOR STMS USING HADR_REMOTE_INST db2inst1
UPDATE DB CFG FOR STMS USING HADR_SYNCMODE NEARSYNC
UPDATE DB CFG FOR STMS USING HADR_TIMEOUT 120
CONNECT TO STMS
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
UNQUIESCE DATABASE
CONNECT RESET
--
-- Update HADR configuration parameters on standby database - HEL269 - M269V2 (db2inst1) - STMS2692 (STMS)
--
UPDATE DB CFG FOR STMS USING HADR_LOCAL_HOST hel269.acme.com
UPDATE DB CFG FOR STMS USING HADR_LOCAL_SVC DB2_HADR_2
UPDATE DB CFG FOR STMS USING HADR_REMOTE_HOST HEL268
UPDATE DB CFG FOR STMS USING HADR_REMOTE_SVC DB2_HADR_1
UPDATE DB CFG FOR STMS USING HADR_REMOTE_INST db2inst1
UPDATE DB CFG FOR STMS USING HADR_SYNCMODE NEARSYNC
UPDATE DB CFG FOR STMS USING HADR_TIMEOUT 120
--
-- Start HADR on standby database - HEL269 - M269V2 (db2inst1) - STMS2692 (STMS)
--
DEACTIVATE DATABASE STMS
START HADR ON DATABASE STMS AS STANDBY
--
-- Start HADR on primary database - HEL268 - db2inst1 - STMS
--
DEACTIVATE DATABASE STMS
START HADR ON DATABASE STMS AS PRIMARY

When the primary fails you need to initiate a take over from the standby. You must be careful that you do not induce a split brain when both database instances believe they are the primary.

I recommend that you do a lot of reading before going ahead with this if you do not have someone knowledgeable to lean on or get in touch with a business partner who can help.




Guide to DB2 HADR Setup with Sameti... (Stuart Hickson 1.Sep.14)
. . RE: Guide to DB2 HADR Setup with Sa... (Ben Williams 2.Sep.14)
. . . . RE: Guide to DB2 HADR Setup with Sa... (Stuart Hickson 2.Sep.14)
. . . . . . RE: Guide to DB2 HADR Setup with Sa... (Ben Williams 3.Sep.14)
. . . . . . . . RE: Guide to DB2 HADR Setup with Sa... (Stuart Hickson 10.Sep.14)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Author
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds

Resources

 Resources
Forum use and etiquette
Native Notes Access
Web site Feedback

Lotus Support

 Lotus Support
IBM Support Portal - Lotus software
Lotus Support documents
Lotus support by product
Lotus support downloads
Lotus support RSS feeds

Wikis

 Wikis
IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Connections Cloud Developers
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

Lotus Forums


 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
IBM Connections
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
Lotus Enterprise Integration
Lotus Protector
Lotus Quickr
Lotus SmartSuite