DB2 Luw HADR issue

Deb Kumar

DB2 Luw HADR issue
Hi All,
I want to know , anyway if it is possible on DB2 LUW


1. I have old offline backup of primary db.2. I am restoring this old backup to both primary and standby.3. After restoring, while enabling HADR , unable to establish HADR and HADR is not working.



If I follow below steps, HADR is working1. Restoring backup on primary2. take the backup of primary3. Restore the same on standby4. Enable the HADR on standby and HADR is working

Mark Barinstein

RE: DB2 Luw HADR issue
(in response to Deb Kumar)

Hi Deb.

Please, provide exact db2 commands you run on both sides in exact sequence, and exact error message you get.

Philip Gunning

DB2 Luw HADR issue
(in response to Deb Kumar)
Why would you restore the primary to the primary? Online backup should be used to establish the standby and it needs to be in roll forward pending ....activate HADR on standby first then immediately on the primary. If doesn’t work review error messages....


> IBM Champion for Analytics
>
> Certified Information Systems Security Professional(CISSP)
>
> Certification Number 539059
>
> Certified Advanced DB2 DBA v10.5
>
> Certified Database Adminstrator, DB2 11.1
>
> IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
>
> Skype: DB2LUW
>
> Twitter: DB2LUW
>
> Direct +1.610.451.5801
>
> IDUG DB2-L Hall of Fame
>
> www.philipkgunning.com
>
> IBM Business Partner
>
>
>
>
Sent from my iPhone

> On Mar 7, 2018, at 12:39 AM, Debabrata <[login to unmask email]> wrote:
>
> Hi All,
>
> I want to know , anyway if it is possible on DB2 LUW
>
>
> 1. I have old offline backup of primary db.
> 2. I am restoring this old backup to both primary and standby.
> 3. After restoring, while enabling HADR , unable to establish HADR and HADR is not working.
>
>
>
> If I follow below steps, HADR is working
> 1. Restoring backup on primary
> 2. take the backup of primary
> 3. Restore the same on standby
> 4. Enable the HADR on standby and HADR is working
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ** ** ** IDUG DB2 Data and Analytics Technical Summit in Bengaluru, India 2018 ** ** **
> ---> Bengaluru, India, March 27, 2018 <---
> http://ibm.biz/IDUGBengaluru2018
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Philip Gunning

DB2 Luw HADR issue
(in response to Philip Gunning)
Of course, below was assuming you have configured the DB CFG parameters on both, configured etc host, etc services addresses and ports, added or enabled any firewall rules on both…. Et al.



IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

BS Comp Sci, MBA

Certified Advanced Db2 DBA v10.5

Certified Database Adminstrator, Db2 11.1

IBM Db2 LUW Support Page -- Db2 Support Portal https://www.ibm.com/mysupport/s/topic/0TO500000001fUNGAY/db2-linux-unix-and-windows?language=en_US&productId=01t50000004WmTk%20

Db2 Analytics Page https://www.ibm.com/analytics/data-management

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner

Microsoft Business Partner

###############See us at IDUG NA in Phila, Pa 4/29 -5/3 Booth 304 ###############





From: Philip Gunning [mailto:[login to unmask email]
Sent: Wednesday, March 07, 2018 7:58 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Luw HADR issue



Why would you restore the primary to the primary? Online backup should be used to establish the standby and it needs to be in roll forward pending ....activate HADR on standby first then immediately on the primary. If doesn’t work review error messages....



IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

Certified Advanced DB2 DBA v10.5

Certified Database Adminstrator, DB2 11.1

IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner



Sent from my iPhone


On Mar 7, 2018, at 12:39 AM, Debabrata <[login to unmask email] <mailto:[login to unmask email]> > wrote:

Hi All,



I want to know , anyway if it is possible on DB2 LUW





1. I have old offline backup of primary db.

2. I am restoring this old backup to both primary and standby.

3. After restoring, while enabling HADR , unable to establish HADR and HADR is not working.







If I follow below steps, HADR is working

1. Restoring backup on primary

2. take the backup of primary

3. Restore the same on standby

4. Enable the HADR on standby and HADR is working



-----End Original Message-----



-----End Original Message-----