Re: File transaction date

Journals are used for:
- transaction support (commit/rollback)
- data replication
- database recovery
- analysing error situations
- undoing jobs for test purposes
...

D*B

--------------------------------------------------
From: "David FOXWELL" <David.FOXWELL@xxxxxxxxx>
Sent: Friday, November 26, 2010 1:24 PM
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Subject: RE: File transaction date

So, what are journals really for? Rollback and commit or something else?

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de
dieter.bender@xxxxxxxxxxxx
Envoyé : vendredi 26 novembre 2010 10:43
À : Midrange Systems Technical Discussion
Objet : Re: File transaction date

Hi,

the Journal Receiver will contain this information, but its
not to easy to get it. starting journaling does not touch
your applications and would be a good idea anyway.

what about adding the timestamp (or something like this),
filling it by trigger and letting your application work with
LFs ommiting this field with identical name s to now?

Dieter

--------------------------------------------------
From: "David FOXWELL" <David.FOXWELL@xxxxxxxxx>
Sent: Friday, November 26, 2010 9:44 AM
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Subject: File transaction date

> Hi,
>
> I'm currently adding a date field to an old PF which will hold the
> date that a transaction gets modified. The file has 3 or 4
mentions in
> different RPG modules that get bound by copy to almost everything.
> This results in having to recompile pratically the whole
system. The
> job that migrates the file takes about 2.5 hours to run and
I need to
> plan it in advance so noone is using the file when ir runs.
In other
> words, it's a headache.
>
> I don't know much about journals/receivers as they aren't
used here.
> But aren't they designed for this kind of information? I'm also
> thinking of the rollback feature that they permit. I've never used
> that either. What kind of preparations do we need to think
about to be
> able to switch to this kind of file management?
>
>
> --
> This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take
> a moment to review the archives at
> http://archive.midrange.com/midrange-l.
>
>
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.