{"id":1033,"date":"2011-04-13T01:49:00","date_gmt":"2011-04-12T19:49:00","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=1033"},"modified":"2016-01-07T11:31:07","modified_gmt":"2016-01-07T05:31:07","slug":"setting-up-db2-hadr-2","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=1033","title":{"rendered":"Setting up DB2 HADR"},"content":{"rendered":"

These days databases are an important part of running the business, hence the availability of the database is astronomicallycritical. \u00c2\u00a0Its really important that critical database needs to have high availability at all times.IBM added HADR to DB2 few years back, it stands for High Availability Disaster Recovery. HADR provides failover capability should the primary database server fails. \u00c2\u00a0If the primary server fails, the workload is transferred over to the secondary server. HADR is not automatic failover, so don’t get confused with DB2 on Cluster Server .<\/p>\n

In a HADR setup there is a primary server which is online and can accept connections from applications and then there is a secondary server which plays the log and keep the data in sync with the primary server.<\/span><\/span><\/p>\n

Below are the tasks I did to setup DB2 HADR :<\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Tasks<\/span><\/p>\n<\/td>\n

\n

Server<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Server names<\/span><\/p>\n<\/td>\n

\n

Tom<\/span><\/p>\n<\/td>\n

\n

Jerry<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

OS<\/span><\/p>\n<\/td>\n

\n

Redhat Linux<\/span><\/p>\n<\/td>\n

\n

Redhat Linux<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

DB2 edition<\/span><\/p>\n<\/td>\n

\n

V9.7 ESE<\/span><\/p>\n<\/td>\n

\n

V9.7 ESE<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IP address<\/span><\/p>\n<\/td>\n

\n

192.168.110.10<\/span><\/p>\n<\/td>\n

\n

192.168.110.11<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Instance<\/span><\/p>\n<\/td>\n

\n

db2inst1<\/span><\/p>\n<\/td>\n

\n

db2inst1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Database<\/span><\/p>\n<\/td>\n

\n

CARTOON<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Backup database<\/span><\/p>\n<\/td>\n

\n

BACKUP DATABASE CARTOON TO \/bkup<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

ftp\/sftp<\/span><\/p>\n<\/td>\n

\n

ftp the backup file from Tom to Jerry<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Update primary database for automatic client reroute;<\/span><\/p>\n<\/td>\n

\n

UPDATE ALTERNATE SERVER FOR DATABASE cartoons USING HOSTNAME jerry PORT 60000;<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Update HADR configuration parameters for primary database<\/span><\/p>\n<\/td>\n

\n

UPDATE DB CFG FOR cartoons USING LOGINDEXBUILD ON ;
\nUPDATE DB CFG FOR cartoons USING INDEXREC RESTART ;
\nUPDATE DB CFG FOR cartoons USING HADR_LOCAL_HOST tom;
\nUPDATE DB CFG FOR cartoons USING HADR_LOCAL_SVC 60006;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_HOST jerry;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_SVC 60007;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_INST db2inst1;
\nUPDATE DB CFG FOR cartoons USING HADR_SYNCMODE NEARSYNC;
\nUPDATE DB CFG FOR cartoons USING HADR_TIMEOUT 120;
\nUPDATE DB CFG FOR cartoons USING HADR_PEER_WINDOW 0;
\nQUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
\nDEACTIVATE DATABASE cartoons;
\nUNQUIESCE DATABASE;
\nCONNECT RESET;<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Restore database<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

RESTORE DATABASE cartoons FROM \/db2bkup TAKEN AT 20110411090137 REPLACE HISTORY FILE WITHOUT PROMPTING;<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Update standby database for automatic client reroute;<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

UPDATE ALTERNATE SERVER FOR DATABASE cartoons USING HOSTNAME tom PORT 60000;<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Update HADR configuration parameters for standby database;<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

UPDATE DB CFG FOR cartoons USING LOGINDEXBUILD ON ;
\nUPDATE DB CFG FOR cartoons USING INDEXREC RESTART ;
\nUPDATE DB CFG FOR cartoons USING HADR_LOCAL_HOST jerry;
\nUPDATE DB CFG FOR cartoons USING HADR_LOCAL_SVC 60007;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_HOST tom;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_SVC 60006;
\nUPDATE DB CFG FOR cartoons USING HADR_REMOTE_INST db2inst1;
\nUPDATE DB CFG FOR cartoons USING HADR_SYNCMODE NEARSYNC;
\nUPDATE DB CFG FOR cartoons USING HADR_TIMEOUT 120;
\nUPDATE DB CFG FOR cartoons USING HADR_PEER_WINDOW 0;<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Start HADR on standby database<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

START HADR ON DATABASE cartoons AS STANDBY;<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Start HADR on primary database<\/span><\/p>\n<\/td>\n

\n

ATTACH TO “db2inst1”;
\nDEACTIVATE DATABASE cartoons;
\nSTART HADR ON DATABASE cartoons AS PRIMARY;
\nCONNECT TO “cartoons”;<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Verify HADR status<\/span><\/p>\n<\/td>\n

\n

db2pd -hadr -d\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/span>>>> should say Primary\u00c2\u00a0 <\/span>Peer<\/span><\/p>\n<\/td>\n

\n

db2pd -hadr -d\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/span>>>> should say Standby Peer<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Manual takeover<\/span><\/p>\n<\/td>\n

\n

\u00c2\u00a0<\/span><\/p>\n<\/td>\n

\n

takeover hadr on database cartoons<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Verify HADR status<\/span><\/p>\n<\/td>\n

\n

db2pd -hadr -d\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/span>>>> should say Standby Peer<\/span><\/p>\n<\/td>\n

\n

db2pd -hadr -d\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/span>>>> should say Primary\u00c2\u00a0 <\/span>Peer<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00c2\u00a0<\/span><\/span><\/p>\n

Try it out and let me know how it goes ? \u00c2\u00a0As always use your best judgement when you try this on your system.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

These days databases are an important part of running the business, hence the availability of the database is astronomicallycritical. \u00c2\u00a0Its really important that critical database needs to have high availability at all times.IBM added HADR to DB2 few years back, it stands for High Availability Disaster Recovery. HADR provides failover capability should the primary database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[583,579,577,94,576,578,581,582,580],"class_list":["post-1033","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2-disaster-recovery","tag-db2-failover","tag-db2-ha","tag-db2-hadr","tag-hadr","tag-high-availability","tag-start-hard","tag-stop-hadr","tag-takeover-hadr"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1033"}],"version-history":[{"count":11,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1033\/revisions"}],"predecessor-version":[{"id":1505,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1033\/revisions\/1505"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}