MIDRANGE dot COM Mailing List Archive

Home » MIDRANGE-L » September 2012

Re: saving date/time windows


It depends. If you're trying to scrape the journal I'd think the
sequence numbers would be a better approach. To my knowledge that's
what all the replication/HA vendors do. Granted you need to deal with
the sequence number being reset but that seems to have a lower degree
of difficulty to me than managing dates and times.

As I understand it Sequence numbers are reset by the CHGJRN command so
you would simply include your control table in whatever process resets
them locally to account for the change to the sequence number.

On Thu, Sep 6, 2012 at 9:26 AM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
So aren't I better off using a date/time window?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Wednesday, September 05, 2012 4:17 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: saving date/time windows

the sequence number gets reset when journal receivers change at IPL.
(i'm not sure how that happens though...)

On 9/5/2012 3:13 PM, Stone, Joel wrote:
Is using the journal seq number better than using a date/time window?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Evan Harris
Sent: Wednesday, September 05, 2012 3:09 PM
To: Midrange Systems Technical Discussion
Subject: Re: saving date/time windows

If I understand what you are trying to do you might want to consider
storing the journal sequence number instead of the date.

On Thu, Sep 6, 2012 at 6:58 AM, Stone, Joel<Joel.Stone@xxxxxxxxxx> wrote:
Collections are used to replicate all our app files onto Wintel for a myAccount web app.

I started using triggers, but those have all sorts of gotchas that are really nasty (must get exclusive use of file to start trigger, same for stopping, must make control pgm to get around, difficult to mod pgms cause users are in file, etc).

I always figure there are those smarter than me that have beaten the blazing trails, and all the commercial replication s/w seem to use journals as opposed to triggers. So I am copycatting them :).

I figure the ultimate goal is to get the data onto Wintel so the company can move off the iseries one day without having to hire an army of COBOL/CL/DDS gurus to interpret what is in place now.

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact