Unix Technical Forum

replication scheduling

This is a discussion on replication scheduling within the DB2 forums, part of the Database Server Software category; --> Hi, I want to schedule replication on a fix time every day. So I have set lastsuccess to that ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 04:12 AM
Klemens
 
Posts: n/a
Default replication scheduling

Hi,
I want to schedule replication on a fix time every day. So I have set
lastsuccess to that time of last day and sleep_minutes to 1440 minutes.
It seemed to work but after Apply was down for one and a half day, instead
of setting lastsuccess to lastsuccess + sleep_minutes it was set to current
timestamp.
Applytrail has 2 entrys one with status 2 and correct lastsuccess and next
with status 0 and wrong lastsuccess.
What could have happened? What can I do to make it work in each situation.

Thanks
Klemens



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 04:12 AM
Norbert Munkel
 
Posts: n/a
Default Re: replication scheduling

Hi Klemens,

Klemens wrote:
> Hi,
> I want to schedule replication on a fix time every day. So I have set
> lastsuccess to that time of last day and sleep_minutes to 1440 minutes.
> It seemed to work but after Apply was down for one and a half day, instead
> of setting lastsuccess to lastsuccess + sleep_minutes it was set to current
> timestamp.


Maybee I am totally wrong because I donīt seem to understand what you
are trying to do. I guess you want to take care, "asnapply" is only
started once a day at a given time.

starting asnapply with the "copyonce" option would do that job.

just my 2 ctīs

cu,

Norbert
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 04:12 AM
Klemens
 
Posts: n/a
Default Re: replication scheduling

with copyonce I have to schedule asnapply every day externally.
I want leaf apply started to look for work. So that it should find to do
someting once a day.

The one and a half day it was down was because the database was abnomally
stopped.

Thanks
Klemens

"Norbert Munkel" <nm@acoreus.de> schrieb im Newsbeitrag
news:sKsye.10$ex3.115@se2-cb104-9.zrh1.ch.colt.net...
> Hi Klemens,
>
> Klemens wrote:
> > Hi,
> > I want to schedule replication on a fix time every day. So I have set
> > lastsuccess to that time of last day and sleep_minutes to 1440 minutes.
> > It seemed to work but after Apply was down for one and a half day,

instead
> > of setting lastsuccess to lastsuccess + sleep_minutes it was set to

current
> > timestamp.

>
> Maybee I am totally wrong because I donīt seem to understand what you
> are trying to do. I guess you want to take care, "asnapply" is only
> started once a day at a given time.
>
> starting asnapply with the "copyonce" option would do that job.
>
> just my 2 ctīs
>
> cu,
>
> Norbert



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:15 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com