IBM DB2 - Replication: How to schedule replication to occcur at a fixed time every day. 
Author Message
 IBM DB2 - Replication: How to schedule replication to occcur at a fixed time every day.

I have set up replication to occur every day at 00:30 hours with an
interal of 1440 minutes (1 day) from NT/DB2 to as400/DB2. It is
working fine. The issue is the replication time gets gradually shifted
by a few minutes every day depending on the time taken for previous
replication. The replication is now occuring at 12:30 hours instead of
00:30 hours. This causes problems to us as it captures only the
changes occured upto 12:30 and not later. The changes that occured
after 12:30 are captured on the following day and not on the same day.

I have tried event based replication by specifying an event and time
for the event. But this occurs only for that day and not every day.
For it to occur daily I have to update the event timing every day
which is not an acceptable solution.

I need help to set up replication to occur daily and exactly at 00:30
hours.

thanks for help.

Raju



Fri, 28 Oct 2005 13:18:36 GMT
 IBM DB2 - Replication: How to schedule replication to occcur at a fixed time every day.

Raju,

You can schedule multiple events.  Schedule events with each
one ocurring at 00:30 on a different day.  I don't know of a
limit on the number of events so you could post a year's
worth or more.

Best regards,
Jim



Sat, 29 Oct 2005 07:03:24 GMT
 IBM DB2 - Replication: How to schedule replication to occcur at a fixed time every day.


Quote:

> I have tried event based replication by specifying an event and time
> for the event. But this occurs only for that day and not every day.
> For it to occur daily I have to update the event timing every day
> which is not an acceptable solution.

Maybe it's an option to define a delete or update trigger which
inserts or updates the needed event for the next day?


Sat, 29 Oct 2005 07:15:45 GMT
 IBM DB2 - Replication: How to schedule replication to occcur at a fixed time every day.

Quote:


> > I have tried event based replication by specifying an event and time
> > for the event. But this occurs only for that day and not every day.
> > For it to occur daily I have to update the event timing every day
> > which is not an acceptable solution.

> Maybe it's an option to define a delete or update trigger which
> inserts or updates the needed event for the next day?

Thanks for the suggestions. But I need a better solution.


Fri, 04 Nov 2005 10:06:35 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. merge scheduled for 1 time a day, yet runs every hour

2. Merge replication applies snapshot every time

3. IBM DB2 / MS SQL Server V 6.5 replication

4. how to schedule a job every day

5. Newbie - System Slows then hangs, same time every day

6. Error: 17832: Unable to read login packet(s) every day 1 time

7. Print out Access reports automatically at a set time every day

8. Differences between COM.ibm.db2.jdbc.app.DB2Driver and COM.ibm.db2.jdbc.net.DB2Driver

9. ATTENTION IBM: Please fix this recurring error on your DB2 manuals website

10. Transactional SQL replication failure every night

11. I really don't get it: Asynchronous replication every 2 seconds

12. Scheduled recurring backup jobs getting schedule disabled after last run of day


 
Powered by phpBB® Forum Software