Issue : Deactivation of Database meddles with Point in Time Roll Forward

Harishkumar .Pathangay

Issue : Deactivation of Database meddles with Point in Time Roll Forward

Hi,
I am facing a weird issue.
Issue : Deactivation of Database meddles with Point in Time Roll Forward.
Please have a look at the video and let me know what is happening.
https://youtu.be/t6GaRcJi8wA
I have given detailed test case in the below URL.
http://db2luwacademy.blogspot.in/ - Part 120.

the issue is the archive log file containing deactivation of database is hindering the ability to roll forward  a particular point in time.

I kindly request you to watch the video and let me know your inputs.

Thanks,
Harish Pathangay

Nadir Doctor

Issue : Deactivation of Database meddles with Point in Time Roll Forward
(in response to Harishkumar .Pathangay)
Hi Harish,

Your notes which are listed below seem a little confusing - after restore
and rollforward of db on standby, you probably want to start hadr ... as
standby. Please check the hadr parameters for db on standby to ensure that
all is okay when comparing with hadr parameters for db on primary via a
"db2 get db cfg for <db> [show detailed]|grep -i hadr".

Usually, one would not deactivate a primary as intent for database is to be
highly available.

Stand By:
Note Down Standby Log Chain Id - 4
Primary:
db2 deactivate db hadr
db2 terminate
db2 restore db hadr taken at 20170618191139
db2 rollforward db hadr to end of logs and complete
db2 start hadr on database hadr as primary
db2 connect to hadr
db2 "select count(id) from t_log with ur"
db2 connect reset
Note Down Standby Log Chain Id - 5
Note Down Primary Log Chain Id - 5

deactivate Primary
stop instance
remove backup image


Best Regards,
Nadir



On Fri, Jul 28, 2017 at 1:10 AM, Harishkumar .Pathangay <
[login to unmask email]> wrote:

> Hi,
> I am facing a weird issue.
> Issue : Deactivation of Database meddles with Point in Time Roll Forward.
> Please have a look at the video and let me know what is happening.
> https://youtu.be/t6GaRcJi8wA
> I have given detailed test case in the below URL.
> http://db2luwacademy.blogspot.in/ - Part 120.
>
> the issue is the archive log file containing deactivation of database is
> hindering the ability to roll forward a particular point in time.
>
> I kindly request you to watch the video and let me know your inputs.
>
> Thanks,
> Harish Pathangay
>
> -----End Original Message-----
>

Harishkumar .Pathangay

Issue : Deactivation of Database meddles with Point inTime Roll Forward
(in response to Nadir Doctor)
I kindly request you to look for Topic in http://db2luwacademy.blogspot.in/:
Issue : Deactivation of Database meddles with Point in Time Roll Forward
The script should be taken from Topic DB2 LUW Tips n Tricks Part 120
http://db2luwacademy.blogspot.in/2017/07/db2-luw-tips-n-tricks-part-120.html


You are looking at incorrect script. Please let me know your inputs. Also I kindly request you to watch video, because it contains complete demo of issue. Explaining in words is too difficult in that scenario. That is why I am asking for video watching only for this issue. I will definitely explain if you have questions even after watching my video is not clear.

Thanks,
Harish Pathangay

Sent from Mail for Windows 10

From: Nadir Doctor
Sent: 28 July 2017 13:00
To: [login to unmask email]
Subject: [DB2-L] - RE: Issue : Deactivation of Database meddles with Point inTime Roll Forward

Hi Harish,

Your notes which are listed below seem a little confusing - after restore and rollforward of db on standby, you probably want to start hadr ... as standby. Please check the hadr parameters for db on standby to ensure that all is okay when comparing with hadr parameters for db on primary via a "db2 get db cfg for <db> [show detailed]|grep -i hadr". 

Usually, one would not deactivate a primary as intent for database is to be highly available.

Stand By:
Note Down Standby Log Chain Id - 4
Primary:
db2 deactivate db hadr
db2 terminate
db2 restore db hadr taken at 20170618191139
db2 rollforward db hadr to end of logs and complete
db2 start hadr on database hadr as primary
db2 connect to hadr
db2 "select count(id) from t_log with ur"
db2 connect reset
Note Down Standby Log Chain Id - 5
Note Down Primary Log Chain Id - 5

deactivate Primary
stop instance
remove backup image



Best Regards,
Nadir
 


On Fri, Jul 28, 2017 at 1:10 AM, Harishkumar .Pathangay <[login to unmask email]> wrote:
Hi,
I am facing a weird issue.
Issue : Deactivation of Database meddles with Point in Time Roll Forward.
Please have a look at the video and let me know what is happening.
https://youtu.be/t6GaRcJi8wA
I have given detailed test case in the below URL.
http://db2luwacademy.blogspot.in/ - Part 120.
the issue is the archive log file containing deactivation of database is hindering the ability to roll forward  a particular point in time.
I kindly request you to watch the video and let me know your inputs.
Thanks,
Harish Pathangay


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]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
ttp://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2




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]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


Attachments

  • CD811C87F9074D128A49A2A559FDA4A5.png (<1k)
  • 547A3350776545669574A1C1C47CD592.png (<1k)

Harishkumar .Pathangay

RE: Issue : Deactivation of Database meddles with Point inTime Roll Forward
(in response to Harishkumar .Pathangay)

hi,

please do not think I am making some marketing or making money by suggesting people to watch videos. I ask that only because it is a long scenario to discuss in e-mail.

thanks,

harish pathangay

Harishkumar .Pathangay

RE: Issue : Deactivation of Database meddles with Point inTime Roll Forward
(in response to Harishkumar .Pathangay)

hi nadir,

Any Inputs?

thanks,

harish pathangay

Nadir Doctor

Issue : Deactivation of Database meddles with Point inTime Roll Forward
(in response to Harishkumar .Pathangay)
Hi Harish,

Unsure if this is being noted only with a specific release but this may
assist -

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0006086.html
--If you are using log archiving, the log manager attempts to archive
active logs as they are filled. In some cases, if a database is deactivated
before the log manager can record the archive as successful, the log
manager might try to archive the log again when the database is activated.
Thus, a log file can be archived more than once.

You may want to raise a pmr on this one to get some additional details from
support.


Best Regards,
Nadir



On Sat, Jul 29, 2017 at 1:33 PM, Harishkumar .Pathangay <
[login to unmask email]> wrote:

> hi nadir,
>
> Any Inputs?
>
> thanks,
>
> harish pathangay
>
> -----End Original Message-----
>

Harishkumar .Pathangay

Issue : Deactivation of Database meddles with PointinTime Roll Forward
(in response to Nadir Doctor)
Thanks for your inputs. I do not have any support with IBM. I mean I am like just individual not with any organisation. Raising PMR is not in my hands.
The issue happens in 11.1, 10.5 express-C and ESE also and straight forward repeatable and reproducible.

Hope it was useful information to share in various forums. There ends my territory. Cannot go beyond that.

Thanks,
Harish Pathangay

Sent from Mail for Windows 10

From: Nadir Doctor
Sent: 30 July 2017 05:52
To: [login to unmask email]
Subject: [DB2-L] - RE: Issue : Deactivation of Database meddles with PointinTime Roll Forward

Hi Harish,

Unsure if this is being noted only with a specific release but this may assist -

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0006086.html
--If you are using log archiving, the log manager attempts to archive active logs as they are filled. In some cases, if a database is deactivated before the log manager can record the archive as successful, the log manager might try to archive the log again when the database is activated. Thus, a log file can be archived more than once.

You may want to raise a pmr on this one to get some additional details from support.



Best Regards,
Nadir
 


On Sat, Jul 29, 2017 at 1:33 PM, Harishkumar .Pathangay <[login to unmask email]> wrote:
hi nadir,
Any Inputs?
thanks,
harish pathangay


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]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2




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]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


Attachments

  • E86E27C1BCF0460DA97B694EEB67AECC.png (<1k)
  • A6A9483D0C664A54A0EE42829E1E9FD4.png (<1k)