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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| 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 |
| ||||
| 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 |